When you’re working on an expansive spreadsheet that is getting out of hand, it can be frustrating when you scroll through a table, lose sight of the horizontal or vertical label and no longer know which entry you’re looking at.
That’s where freeze panes come to the rescue! Setting up freeze panes allows you to keep the horizontal and vertical labels ‘frozen’ on the page so that when scrolling you don’t lose site of important data.
Using freeze panes is incredibly easy on modern versions of Microsoft Excel, there’s a button that allows you to freeze and unfreeze in two clicks. You can find the button under the ‘View’ tab, in the ‘Window Section’ – helpfully called ‘Freeze Panes’.
Clicking the button brings up three options:
- Freeze Panes
- Freeze Top Row
- Freeze First Column
The second two options are self explanatory. They’re the simplest it you only want the top row or first column frozen. However you may want to freeze both at once, or more than one column. To do this you use the top option. Clicking ‘Freeze Panes’ freezes everything above and to the left of the cell you’ve highlighted. So if you want the top row and left column, select cell B2 and click Freeze Panes. Here are some other combinations to help you figure out which cell to select: Read the rest of “How to Freeze Panes in Microsoft Excel”
Microsoft have announced