Project 5A Key Points

Navigating Large Worksheets

  1. Using the Go To Special Command

    On the Home tab, in the Editing Group, click Find & Select, and then click Go to Special. In the resulting dialog box, you can click an option button to move to cells that contain the special options listed.
  2. Hiding Columns

    When you hide columns, the column headings will skip and a dark vertical line will appear where the columns have been hidden. When you click in another cell, the vertical line will disappear but the skip in column headings will remain and the line between column headings will be slightly wider. To unhide columns, select the columns on both sides of the hidden column, right click over the selection, and then click Unhide.
  3. Using the Go To Command - Home tab, in the Editing Group, click Find and Select and then click Go To.
    COUNTIF function - counts the number of cells that meet a specified condition.
  4. Arranging Multiple Worksheets and Splitting Worksheets

    You can arrange the window to display sheets from more than one workbook. With one worksheet open, open another and then in the View tab, in the Window group, click Switch Windows. On the View tab, in the Window group, click Arrange All. Click Horizontal. When multiple worksheets are open on the screen, only one is active at a time. The active window title will be more prominent. To make another window the active window, just click anywhere in that window.

    You can split a worksheet by clicking on a cell and then choosing on the View tab, in the Window group, click Split. If you click on a cell in the first column, the worksheet will be split horizontally. Ctrl-F brings up the Find and Replace dialog box. In this example we will just use the Find tab.

    To remove the split, on the View tab, in the Window group, click Split.

Enhance Worksheets with Themes and Styles

A theme is a set of cell styles and also has a set of table styles for data you format as a table

  1. Changing and Customizing a Workbook Theme

    On the Page Layout Tab, in the Themes Group, click Themes. If you point to any of the themes, Live Preview will show you what your workbook will look like. In the Themes group, you can click Fonts if you want to change from the fonts associated with the theme you chose.
  2. Creating and Applying a Custom Table Style

    On the Home Tab, in the Styles Group, click Format as Table. At the bottom, click New Table Style. See the steps in the text

Format a Worksheet to Share with Others

  1. Previewing and Modifying Page Breaks

    Display Print Preview to see how many pages, and click the Next Page to see the content of each page. Click Back to return to the worksheet. Click the View tab, and then in the Workbook Views group, click Page Break Preview.
  2. Repeating Column or Row Titles

    On the Page Layout tab, in the Page Setup group, click Print Titles. Here you can select rows to repeat at the top of each page and columns to repeat at the left of each page. To repeat rows, click in the Rows to repeat at top box and then click in the row heading (that contains the row number) in the worksheet to select the row. A similar procedure to select columns to repeat.
  3. Inserting a Hyperlink in a Worksheet

    On the Insert tab, in the Links group, click Links. Among other things, you can link to another spreadsheet. (pp. 329-330)
  4. Modifying a Hyperlink

    Right click on the hyperlink and then click Edit Hyperlink.

Save Excel Data in Other Formats

  1. Viewing and Saving a Workbook as a Web Page

    File>Save As>Web Page. You can enter a title which will become the title of the web page. This generates an HTML table (pp. 332-334)
  2. Saving Excel Data in CSV File Format

  3. Saving Excel Data as a PDF file or as Text File (tab-delimited file) )

revised 11/1/21. Comments to Bill Pegram, wpegram@nvcc.edu