If I want to keep that first column frozen, I can go to the View tab of the ribbon, and then click Freeze First Column. You see that column A, the month headers, were disappearing because I scrolled away from them. So let's say that I want to be able to scroll left and right and not have the months disappear, as I'm doing here.

My month headers are in the first column, column A, and my column headers are in row four. This workbook contains a single worksheet and in it I have monthly revenue data for eight calendar years. My sample file is the Freeze workbook and you can find it in the Chapter04 folder of your Exercise Files collection.

But what do you do if you need to use data in two different parts of the worksheet at the same time? Or what do you do if you have a data list and you want to keep the headers on the screen regardless of how far you scroll? In this movie, I will show you how to handle those situations by splitting the worksheet into separate units and freezing columns and rows. Excel worksheets can contain a lot of data.

Freeze multiple panes in excel mac