Freeze Panes is a great way to take the pain out of navigating around a large spreadsheet in Excel Video 244. Freeze Panes is a way to lock in rows and/or columns so that when you scroll down or to the right you still see the row and column headings you need to make sure you’re in the right cell on your spreadsheet.
It’s easy to freeze the top row or the first column. You can also freeze a group of rows and/or columns by choosing Freeze Panes from any cell in your spreadsheet. Freeze Panes will freeze all of the rows above your cell and all of the rows to the left of your cell. It’s a fast, easy way to manage data in a large spreadsheet. The same menu will unfreeze the panes when you’re finished.