When working with financial data in Excel it is typical to have thousands of rows. Usually the header text will be in row one and we will be in row 1000 and want to find out what the column represents. Todays tip involves splitting the spreadsheet so the header text is visible no matter which row we are in. The image below shows some typical stock data downloaded from Yahoo Finance.
Click on the split cell portion of the window and drag down to the bottom of row A1.
After completing this step you should now be able to navigate your document and be able to view the column labels from any cell.