Reviewing the Data

Worksheets can quickly become huge and unwieldy. When you need to review your data, you can "freeze" certain parts of the worksheet—the column and/or row titles, for example—so that they’ll remain in view while you scroll through other parts of the worksheet. You can also split the window into several sections if you want different parts of the worksheet to be visible so that you can compare them.

Freeze the Columns and/or Rows

  1. Click in a single cell that’s at the right of the columns and/or below the rows to freeze the columns and/or the rows.

  2. On the View tab, click the Freeze Panes button.

  3. Choose whether you want to freeze both the rows above and the columns to the left, or to freeze just the top row or the first column.

    Freeze the Columns and/or Rows

Tip

Tip

If your data is contained in a table, the table headings will replace the standard column labels (such as A and B) at the top of the window when you scroll the window and the table headings move off the screen.

View Multiple Sections

  1. Click where you want to split the worksheet.

  2. On the View tab, click the Split button.

  3. Use the scroll bars to scroll the contents of the different panes.

  4. Click the Split button again to remove the multiple panes.

    View Multiple Sections
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset