Freeze or split the workbook window

  1. Select the row, column or cell where you want the new window to start.
    • The most common cell to select is the one just below your row labels and just to the right of your column labels. For example, if there were labels in column A and row 1, you could select B2 and freeze the first row and the first column.
    • If you have column headings in rows 1-3 and you want to see them when you are further down in your worksheet, row 4 is the row where you want a new window to start: it is allowed to scroll under rows 1-3. So select row 4 (by clicking on the row heading “4”) and choose Window → Freeze Panes.
    • Similarly, if column A has headings that you want to see, column B becomes the first column of the new window. Click the column heading “B” and choose Window ? Freeze Panes.
    • Finally, if you want to preserve both rows 1-3 and column A as headings, cell B4 becomes the first cell of the new window, allowed to scroll either horizontally or vertically under the headings. So select B4 and choose Window ? Freeze Panes.
  2. Choose Window ? Freeze Panes (or Window ? Split)
    • Note that you also have the option to “split” the window. Split is similar to freeze except that the split areas are allowed to scroll independently. Freeze allows you to see headings while you work in the body of your sheet. Some users use Split to work on several parts of the sheet at once.
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish