Always in Sight

As your worksheet grows, there comes a point where you can't see the whole thing on screen, and you lose sight of your column and row headings. This setup makes it difficult to know whether you're in the right column or row. Fortunately, the answer is simple--freeze your headings.

Select a cell just to the right of the row or just below the column that contains your headings. Choose Window, Freeze Panes. Now the rows to the left and the columns above the cell(s) you selected before freezing your headings will always remain on screen--no matter how far down or to the right you scroll. You can turn this feature off just as quickly by selecting Window, Unfreeze Panes.