Freeze Excel column and row titles (2003/2007/2010)

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data columns or rows contain once you begin scrolling around the sheet and lose sight of the column and row labels. Fortunately, you can freeze rows and columns that contain headings so you always know what data you're looking at.



To freeze a row, select the row number or the cell in column A that's immediately beneath the last row you want frozen. Then, select Window | Freeze Panes from the menu bar. Excel inserts a thin line to show you where the frozen pane begins. To freeze a column, select the column letter or the cell in row 1 that's immediately to the right of the last column you want frozen. To freeze horizontal and vertical areas simultaneously, select the cell that's in the upper-left corner of the range you want to remain scrollable and then invoke the Freeze Panes feature. (In 2007, click the View tab on the ribbon, then click on Freeze Panes in the Window section, and make a selection from the resulting dropdown list.) If you later want to make all regions scrollable again, simply select Window | Unfreeze Panes from the menu bar.