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 ...

Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.