Sunday, April 28, 2013

How to Print Continuing Row and Column Headings in Excel 2003


1. Open the Excel file that you want to work on. With Excel open, go to 'File > Open' and find your file.
2. Click on 'File > Page Setup.'
3. Click on the Sheet tab.
4. Click on the chart icon next to the box for 'Rows to Repeat at Top.' This will take you back to your Excel sheet. You can now click on the row that you would like to appear on subsequent pages. For example, if there is a row with headings you'd like to repeat, choose that one. After you click each row, your choice will appear in a box on the main screen. Hit 'Enter' to return to the dialog box.
5. Click on the chart icon next to the box for 'Columns to Repeat at Left.' Click on the column that you want to see repeated. In this case, choose the column that contains your headings. Hit 'Enter.'
6. Click 'OK' to save your settings.

Blogger news