Freezing Panes in Excel

You receive a spreadsheet from your Regional Director. Let's say it contains ten different supply account variances for the month, and there are 45 facilities on the same spreadsheet. Your facility is near the bottom of the sheet, but when you scroll down to view your info, you lose the account headings at the top. You see you're over $850, but can't remember which account you were looking at.

Did you know that you can freeze the header columns at the top of the spreadsheet to view your information and the titles simultaneously?

By freezing panes, you select specific rows or columns that remain visible when scrolling in the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll. Here's a step by step:

1. To lock rows, select the row below where you want the split to appear. To lock columns, select the column to the right of where you want the split to appear. To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

2. Under the Window menu, click Freeze Panes.

3. To unlock rows, click Unfreeze Panes on the Window menu.

Now, when you scroll down , the row you froze will stay on the screen and everything else will scroll accordingly.