To freeze the heading row of the table, you will have to freeze the first five rows in the worksheet. If you look at the first screenshot in this lesson, you'll see that the first row doesn't actually contain the headings for the sales data table - it contains the title of this worksheet. Things get slightly more complicated if you want to freeze more than one row or column.
Freeze panes in excel mac#
In the Mac version of Excel the options are the same, but you don't get the explanations of each option that you see here: The screenshot below is from Excel 2010 for Windows. If you wanted to freeze the first column, you would then go back and choose that option.
When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes options. To freeze just one row, click the View menu, and find the Freeze Panes button (if you're using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) Note that these steps also apply to freezing columns: You have two options for freezing panes in Excel.
Freeze panes in excel windows#
The proces for doing this is slightly different between Excel 2010 for Windows and Excel 2011 for Mac, so I've covered both here:
Why you might need to freeze rows or columns in your spreadsheet
Freeze panes in excel how to#
This lesson explains how to freeze rows and columns (officially known as "Freeze Panes") in Excel 2010 for Windows and Excel 2011 for Mac. Step 3 - As you can see from below image, Column A is frozen and it is always visible as you scroll to right-side within Excel worksheet.Īn animation about how to Freeze an Excel worksheet at a Column is copied below.When you are working with a large spreadsheet in Microsoft Excel, it's easy to find yourself scrolling down or across and losing track of where you are. Step 2 - Click "Freeze Panes" menu and then select "Freeze Panes" from Excel Ribbon > "View" Tab > "Window" Group as shown below. So I had selected Column B, by clicking on its Column Letter. In this example, I want to freeze at Column A (left-most column). Step 1 - Select the right-side Column of the Column which you want to freeze by clicking on its Column Letter, as shown below. To Freeze Pane vertically at a Column, follow below steps. There is a feature in Excel called Freeze Panes to keep some Columns always visible while you scroll horizontally. For example, you may want to see the first Column of the worksheet while you scroll horizontally to right-side within Excel worksheet.
Sometimes you want to scroll a large worksheet by keeping one or more Columns of a worksheet visible while you scroll columns.