Figure 1: Excel's Page Layout command disables the Freeze Panes command and unfreezes rows/columns, as well. I rarely use Page Layout view, so that wasn't my culprit yesterday. I simply had a large workbook that had started behaving erratically. If you would prefer to freeze a combination of rows and columns, it’s possible but it’s only just slightly more tricky: Open your Excel spreadsheet and go to If you want to freeze the top row and the first column, you’ll select cell B2. Click the Freeze Panes button and again, click the Freeze Panes option.
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).
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?
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.
NOTE: Freezing panes only works when you are in Normal View.
To freeze the first row and column, open your Excel spreadsheet.
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.
Now when you scroll, you should still continue to see row 1 and column A.
Amazon affiliate: Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting
Let’s say you have a number of rows of data, and you need to be able to scroll or search up and down them, but whenever you do, you lose sight of the headings.These instructions work for Calc in both OpenOffice.org AND NeoOffice.
In order to freeze the header rows so that they don’t move and you can scroll up and down, simply click on the first cell in the row immediately below the row(s) you want to freeze. In this example, I would click on cell A2 in row 2, as I want to freeze the header row – row 1.
Click on the cell in column A in the row BELOW the header
From the menu, select Window >> Freeze
You will then see that you can scroll up and down, but the header row will remain where it is.
In the example below, I have scrolled down to show Row 40. Rows 2-39 are hidden, but you can still see the header row (row 1).
Unfreeze / Unlock
To unfreeze, just select Window >> Freeze (you will notice that there is a tick next to Freeze – clicking on this will remove it).
Window >> Freeze
Freeze / Lock Columns and Cells
You can use this method to freeze both columns and rows.
For example, let’s say you want Row 1, and Column A to be frozen.
Click on cell B2 (one row immediately below the rows to be frozen, and one column immediately to the right of the column to be frozen).
Again, from the menu select Window >> Freeze
Select Window >> Freeze
And you will notice that the first column (A) and the first Row (1) do not move, allowing you to scroll up and down, left and right.
To unfreeze, simple select Window >> Freeze
Window >> Freeze
The tick will be removed, and your spreadsheet will return to normal.
Related content:?