Freeze Rows and/or Columns in Excel

This may not be sexy, but I find it very helpful, and it seems few people know about it.

You can freeze rows and/or columns in Excel. This is great for keeping column headings and/or the first few columns of data on the screen as you scroll through the data.

To do this, move to the cell just below the last row you want to remain on the screen and just to the right of the last column you want to remain on the screen. For example, if you want the first row and the first column to remain on the screen, move to cell B2. Next, select "Window" "Freeze Panes" from the menu options.

If you want to unfreeze, select "Window" "Unfreeze Panes" from the menu options.