Note that a thick gray line will always show you where the freeze point is.

As youre scrolling through large sheets in Excel, you might want to keep some rows or columnslike headers, for examplein view.

Excel lets you freeze things in one of three ways: You can freeze the top row.

You can freeze a pane that contains multiple rows or multiple columnsor even freeze a group of columns and a group of rows at the same time.

Its the Inventory List template that comes with Excel, in case you want to play along.

Switch to the View tab, click the Freeze Panes dropdown menu, and then click Freeze Top Row.

Now, when you scroll down the sheet, that top row stays in view.

On the View tab, hit the Freeze Panes dropdown again, and this time select Unfreeze Panes.

Freeze the Left Row Sometimes, the leftmost column contains the information youll want to keep on screen as you scroll to the right on your sheet.

To do that, switch to the View tab, click the Freeze Panes dropdown menu, and then click Freeze First Column.

Now, as you scroll to the right, that first column stays on screen.

And again, to unfreeze the column, just head to View Freeze Panes Unfreeze Panes.

Freeze Your Own Group of Rows or Columns Sometimes, the information you need to freeze on screen isnt in the top row or first column.

In this case, youll need to freeze a group of rows or columns.

This one is the Employee Attendance template included with Excel, if you want to load it up.

Notice that there are a bunch of rows at the top before the actual header we might want to freezethe row with the days of the week listed.

Obviously, freezing just the top row wont work this time, so well need to freeze a group of rows at the top.

First, select the entire row below the bottom most row that you want to stay on screen.

In our example, we want row five to stay on screen, so were selecting row six.

To select the row, just click the number to the left of the row.

Next, switch to the View tab, click the Freeze Panes dropdown menu, and then click Freeze Panes.

Now, as you scroll down the sheet, rows one through five are frozen.

How To Freeze Multiple Rows In Excel For Mac