One of the things I frequently do is Freeze Panes in my worksheet. This command keeps column headings, row headings, or both in view. So when scrolling down (or to the right) I know what type of data I’m looking at because the headings are still visible.
To keep the command handy in Excel for Windows, open View, right-click Freeze Panes, and select Add to Quick Access Toolbar. The toolbar button opens the freeze menu without another trip to the View tab.
Same Command, More Clicks
Freezing Panes was easy when using Excel 2003. Just two clicks on the menu and the panes were frozen.
Then Excel 2007 introduced the Ribbon, which I still haven't forgiven them for. Starting from the Home tab, freezing panes meant three clicks: View > Freeze Panes > Freeze Panes. That doesn't sound like a big deal; I mean it's just one extra click, right?
But many of the commands I use are on the Home tab, so I kept switching back and forth. Another click, more aggravation.
Luckily, the Quick Access Toolbar brought me back to two-click functionality: open the menu, then choose the freeze option. The same right-click method works in current Windows desktop Excel. If the toolbar is hidden, right-click the Ribbon and select Show Quick Access Toolbar. Its position can vary; Microsoft explains the options in Customize the Quick Access Toolbar.
Choose What to Freeze
Clicking the Freeze Panes icon shows you three options:
- Freeze Panes keeps the rows above and columns to the left of the active cell visible.
- Freeze Top Row keeps the top row visible.
- Freeze First Column keeps the first column visible.
Start at the top-left of the worksheet. For example, select C2, then choose Freeze Panes to keep row 1 and columns A:B visible. The last two choices don't depend on the active cell. For more examples, see how to freeze cells so rows and columns stay visible.
Once panes are frozen, the first menu choice changes to Unfreeze Panes. Choose it from your toolbar menu, or use View > Freeze Panes > Unfreeze Panes. Unfreeze first if you want to change the boundary.
A later discovery: Excel 2007 and 2010 also had a separate, one-click command called Freeze Sheet Panes. I covered it in my follow-up on adding Freeze Sheet Panes to the toolbar. Its availability in current Microsoft 365 builds hasn't been verified; the standard button described here opens the three-choice menu.
These toolbar instructions are for Windows desktop Excel. On a Mac, use the Freeze buttons on View; if they're grayed out, select View > Normal, as described in Microsoft's Mac instructions. In Excel for the web, use the freeze controls on View instead of this desktop toolbar setup.