HOW TO SEE HEADINGS AS YOU SCROLL AROUND A REPORT
You have a spreadsheet with headings at the top, as shown in pic. You want to be able to scroll through the data and always see the headings.Use the Window ==> Freeze Panes command to keep certain rows visible at the top of the window as you scroll through the data
Use the Freeze Panes command on the Window menu. It is not obvious, but in order to make the Freeze Panes command work, you must place the cell pointer in the correct location before using the command.
1. Place the cell pointer in cell A5, before you select the Freeze Panes command. The Freeze Panes command will freeze all visible rows above the cell pointer and all visible columns to the left of the cell pointer. By placing the cell pointer in column A, you will not freeze any columns, only the rows.
2. With the cell pointer in cell A5, select Window ==> Freeze Panes. A solid horizontal line will be drawn between rows 4 and 5.
3.With the cell pointer in cell A5, select Window==> Freeze Panes. A solid horizontal line will be drawn between rows 4 and 5. As you scroll down past row 48, you will always be able to see the heading rows, as shown in pic.
