how to freeze panes in microsoft 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.

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.

Suppose we want to lock row 1 and columns A to C, we follow these steps.

How To Freeze Panes In Microsoft Excel For Mac