This Excel tutorial explains how to freeze panes to keep the first row and first column visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions).
- May 13, 2016 Go to Window in Menu Bar and select Freeze Panes Then you should be able to scroll down the sheet with Row 1 left in place. If you needed for example the first three rows frozen, just go to fourth row and select Freeze Panes.
- Re: Freeze Rows-Mac Excel 2008 Select A2, then Window-Freeze Panes. As long as you are in Normal view, not Page Layout view, as Emerald said, you should be fine.
- Jul 22, 2009 Re: Freeze Rows-Mac Excel 2008 Select A2, then Window-Freeze Panes. As long as you are in Normal view, not Page Layout view, as Emerald said, you should be fine.
- On a Mac go to the Window menu and then select freeze pane. On a PC, you’ll go to the View menu. One nice time saver on the PC version is it has the option on the View / Freeze Pane menu to freeze the first row and/or the first column.
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet with column headings. I need to freeze the first row and also freeze the first column. That way, I can see the first row and first column at all times even when I scroll. How can I do this?
When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet. Freezing Several Rows / Panes In Excel On A MAC. Unfreeze Panes. Freeze Top Row. Freeze First Column. I have tried all kinds of work-arounds with no luck. (Placing my cursor several rows down, Highlighting several rows.
Answer: If you need to see the first column (column A) and first row (row 1) even after scrolling, you could try freezing the pane in Excel. Microsoft office.
Microsoft Excel Mac Freeze Row 10
To freeze the first row and column, open your Excel spreadsheet.
Excel For Mac Freeze Top Row
Select cell B2. Then select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu.
Microsoft Excel Mac Freeze Row 2017
Now when you scroll, you should still continue to see row 1 and column A.