When working with tabular data in Microsoft Office Excel, it is often necessary to see column or row headers on the screen at any given time, regardless of the current page scrolling position. An operation that freezes specified columns or rows in a spreadsheet is called area freezing in Microsoft Excel.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
Start the spreadsheet editor, open the file with the table in it and go to the required sheet of the document.
Step 2
If you are using Microsoft Excel versions 2007 or 2010, and you need to freeze the leftmost column of the current sheet, immediately go to the "View" tab. Expand the Freeze Areas drop-down list, which is placed in the Window command group. You need the bottom row of this list - "Freeze the first column" - click on it with your mouse pointer or select by pressing the key with the letter "d".
Step 3
If you want to freeze more than just the first column, select the column to the right of the last of the columns of the group to be docked. To do this, left-click the heading of this column, i.e. the cell above the topmost row, when you hover over which it changes shape and becomes a black arrow pointing down.
Step 4
Expand the same Freeze Regions list on the View tab of the spreadsheet menu, but this time select the topmost row - Freeze Regions. This menu item may not appear if there are already other pinned areas on the sheet. In this case, its place in the list will be taken by the "Unpinned Areas" command - select it first, and then open the list again and select the "Freeze Areas" item that has returned to its place.
Step 5
In the 2003 version of this spreadsheet editor, the menu is arranged differently, therefore, having selected the column next to the docked one, open the "Window" section and select the "Freeze regions" line. Here, this command is the same for all pinning options.
Step 6
If you need to freeze not only columns, but also a number of rows, select the first cell of the unfixed area, i.e. the topmost and leftmost scrollable area of the table. Then, in Excel 2007 and 2010, repeat the fourth step, and in Excel 2003, select Freeze Regions from the Window section.
