Excel 2007: How to Freeze/Unfreeze Panes, Columns, and Rows

In Excel 2007, you can freeze rows and columns so that when you scroll, those panes stay in place. This can be handy for header sections so that you can see your headers no matter where you scroll to in the spreadsheet.

Freezing a Row

To freeze a row, or a set of rows, you need to select the row below the row you want to freeze. To select a row, you need to click on the number of that row on the left side so that it hi-lights that entire row. With your row selected, click on the View tab at the top and you’ll see the Freeze Panes button. Click on Freeze Panes and you’ll see several different options. Selecting Freeze Panes will freeze all rows above your selected row, and selecting Freeze Top Row will freeze only the top row no matter what row you currently have selected.

Freezing a Column

To freeze a column, or a set of columns, you need to select the column to the right the column you want to freeze. To select a column, you need to click on the letter of that column at the top so that it hi-lights that entire column. With your column selected, click on the View tab at the top and you’ll see the Freeze Panes button. Click on Freeze Panes and you’ll see several different options. Selecting Freeze Panes will freeze all columns to the left your selected row, and selecting Freeze First Column will freeze only the left most column no matter what column you currently have selected.

Freezing Columns and Rows

Freezing a column and a row at the same time is a bit trickier unless you only want to freeze the left column and the top row, since those options are there all the time. To freeze a set of columns and rows at the same time, click on the cell below and to the right of the panes you want to freeze. For example, if you wanted to freeze columns A through C, and rows 1 through 3, you would select cell D4 since it’s below and to the right of these columns and rows. With the proper cell selected, click on the View tab at the top and click on the Freeze Panes button, and select the Freeze Panes option in the drop-down.

Unfreeze Panes

To unfreeze your panes at any time, just click on the View tab and click the Freeze Panes button, then select Unfreeze Panes.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>