how do you freeze panes in excel for mac

Select any Cell located immediately to the right of the Column that you want to freeze. If the worksheet spans multiple columns you may want to make certain column/columns always visible when you scroll to the side on the worksheet (Right or Left).Ģ.1.

This will freeze the Row containing Column Headings and this particular Row will always stay visible when you scroll down the worksheet. Next, click on the View tab > click on Freeze Panes and then click on Freeze Panes option in the drop-down menu. Select the Row (or the first cell in the row) located right below the Row that contains the Column headings.ġ.2. In case you want to make the Column Headings stationary and always visible when you scroll down, you can follow the steps below to Freeze the Row containing Column headings.ġ.1. Note: Freezing Rows or Columns has no effect on printing, it only affects the way that worksheet appears on the screen. Similarly, it is possible to Freeze Columns and also Freeze both Rows and Columns at the same time in Excel. Once this is done, the Column headings will become frozen and will always be visible when you scroll down.

A simple solution to this problem is to simply Freeze the entire Row containing Columns headings.

How do you freeze panes in excel for mac