Excel Tip of the Day–Freeze Panes
Save time and freeze those panes!
Tired of scrolling back and forth between the cells in which you’re working and the headers at the top of the page? By freezing panes, you can avoid this time-consuming headache.
Even better, it’s super easy (and totally cool).
Step 1: Simply go to the cell that is below and to the right of the rows/columns you want to always appear on the screen. (Example: If you want to freeze what’s in the top row and farthest left column, just go to cell B2.)
Step 2: In the toolbar, click on Window, then “Freeze Panes.”
Step 3: Relax and enjoy the time you’ve saved, or use this trick to attract potential suitors.
Advertisement
This is one of my all time favorite Excel tricks ever!!!!!