Search form

You can also use panes to freeze headings in the top rows and first columns so that the headings stay in view at all times, no matter how you scroll through the worksheet. Frozen headings are especially helpful when you work with a table that contains information that extends beyond the rows and columns shown onscreen. In the following figure, you can see just such a table.

MS Excel for Mac: Freeze first row and first column

In fact, this worksheet continues down to row 52 and over to column P. By dividing the worksheet into four panes between rows 2 and 3 and columns A and B and then freezing them on the screen, you can keep the column headings in row 2 that identify each column of information on the screen while you scroll the worksheet up and down to review information on income and expenses. Additionally, you can keep the row headings in column A on the screen while you scroll the worksheet to the right.

Refer to the figure to see the worksheet right after splitting the window into four panes and freezing them.

Excel video training

To create and freeze these panes, follow these steps:. In this example, Excel freezes the top and left pane above row 3 and left of column B.

When Excel sets up the frozen panes, the borders of frozen panes are represented by a single line rather than the thin gray bar, as is the case when simply splitting the worksheet into panes. See what happens when you scroll the worksheet up after freezing the panes shown in the following figure.

Freeze columns and rows.

How to freeze columns or rows in a list

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Not all features are supported in Excel Starter. You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement on Excel User Voice. Freeze panes to lock the first row or column in Excel for Mac. Split panes to lock rows or columns in separate worksheet areas.

How to freeze rows and columns in Excel

Overview of formulas in Excel. How to avoid broken formulas. Find and correct errors in formulas.

  • IT Services!
  • How to freeze columns in Excel?
  • How to freeze panes in Excel (lock rows and columns)?

Keyboard shortcuts in Excel for Windows. Keyboard shortcuts in Excel for Mac. Excel functions alphabetical. Excel functions by category.

In this course: