How to Use Column Headings in Excel

How to Freeze Column Headings
1. Start Microsoft Excel. Open the worksheet in which you want to freeze the column headings.
2. Click inside of the first cell in the row just beneath the one containing the column headings.
3. Go to the 'Window' menu in Excel 2003 and select 'Freeze Panes.' Go to the 'View' tab in Excel 2007 or 2010 and click 'Freeze Panes' in the 'Window' group. Select 'Freeze Panes' from the drop-down list. Excel freezes the rows above and the columns to the left of the cell you select, so if your heading is in 'Row 1' and you click inside cell 'A2,' only the first row will freeze. When you scroll down the page, the row with the headings will be 'frozen' so that you can still view the headings as you move down the worksheet.
4. Unfreeze the row if desired. Go to the 'Window' menu in Excel 2003 and click 'Unfreeze Panes.' In Excel 2007 or 2010, go to the 'View' tab, click 'Freeze Panes' and select 'Unfreeze Panes.'
How to Print Column Headings on All Pages
5. Start Microsoft Excel. Open the worksheet in which you want to print the column headings.
6. Go to the 'File' menu in Excel 2003, click 'Page Setup' and go to the 'Sheet' tab. In Excel 2007 or 2010, go to the 'Page Layout' tab, click the 'Page Setup' dialog launcher in the bottom right corner of the 'Page Setup' section and go to the 'Sheet' tab.
7. Select the 'Row and Column Headings' check box in the 'Print' section of the dialog box in Excel 2003, 2007 and 2010 to ensure that the column headings print.
8. Click the button at the right end of the 'Rows to Repeat at Top' box in all versions of Excel. This reference button gives you access to the worksheet. Simply click the row number to select the row containing the column headings. Click the reference button once more. This enters the reference for the row number that you want to print into the 'Rows to Repeat at Top' box.
9. Click 'OK.' When you print the worksheet, the heading row will print at the top of every page.