Working with large spreadsheets can sometimes be frustrating; especially when all you're looking for is a quick snapshot of information.
Keep Column Headings Visible
As you scroll through a large document in Excel, you may lose sight of the column headings. In the example below, after scrolling down in the document, a user wouldn't know what the number "143" in Cell D28 refers to because the column headings are no longer visible.
To keep column and row headings visible:
In order to freeze BOTH columns AND rows, you need to place your cursor in the cell directly below and to the right of the columns and rows you wish to freeze before selecting Windows, Freeze Panes.
In the example below, placing the cursor in cell C4 will freeze rows 1 - 3 and Columns A and B so they will not scroll out of view.
Do Fast Calculations in Excel
Have you ever scanned a column of numbers in Excel, trying to "guess-ti-mate" the average or guess the number of entries in the column? You can certainly write a formula to do the calculation, but there is a faster way.
To view the average of a series of cells:
1. Select the cells in which you are interested, and you will see the sum of the range displayed on the status bar, which is the horizontal area below the worksheet window.
2. If the status bar is not displayed, click Status Bar on the View menu.
3. Right-click the status bar, and then click Avg. Now you can see the average value displayed on the status bar.
4. You can use the same method to quickly find the maximum value, or the minimum value in the selected range. You can also count the cells that contain numbers (by selecting Count Nums) or count the number of filled cells (by selecting Count).