how to use page down and freeze in excel for mac

This step by step tutorial will assist all levels of Excel users to freeze rows and columns in Excel, Google sheets and Mac.

Since only the rows are locked, the columns still tend to disappear when we scroll to the right of our data.

Since only the columns are locked, the rows still tend to disappear when we scroll down our data.

This is especially helpful when we are handling a large set of data and there are key cells that we want to be always visible on the screen.

Freezing cells are very helpful in analyzing and scanning through large chunks of data.

Else, those cells will not be displayed on the screen after the freeze.

These are the thick gray bars at the top left corner of the sheet, just above row 1 and to the left of column A.

Nonetheless, the drop-down menu under View tab Freeze may be similar to the following.

Another difference is that the Freeze Panes button in Excel Mac is under the Layout tab, while the Freeze Panes button in Windows Excel is under the View tab.

In order to freeze the top row in Excel Mac or the first column, we can select any cell and click the freeze button.

If you want to save hours of research and frustration, try our live Excelchat service Our Excel Experts are available 247 to answer any Excel question you may have.

How To Use Page Down And Freeze In Excel For Mac