To Freeze both rows and columns, select the Cell located to the right of the Column that you want to Freeze and below the Row that you want to Freeze. In our case, we have selected Cell B2 in order to Freeze the second Row containing column headings and also Freeze Column A containing “Items”. I am trying to freeze the header row in my Excel app for Mac. The following instructions do not work –– there is no choice to freeze the top row under the Layout tab! 'To freeze the top row, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen.
This Excel tutorial explains how to freeze panes to keep the top row visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet with column headings. I need a way to scroll down the rows, but still see the column headings that are contained in the top row. How can I do this?
Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel.
NOTE: Freezing panes only works when you are in Normal View.
How To Freeze A Row In Excel
To freeze the top row, open your Excel spreadsheet.
Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu.
Freeze Row Excel For Mac Free
Now when you scroll down, you should still continue to see the column headings.