| Trusted Advisor with 41,084 posts. | | Join Date: Nov 2005 Location: McHenry, IL - USA Experience: Intermediate | |
You did not mention what version of MS-Excel you are using and this may or may not work for you. I have MS-Excel 2003 and this is in the Help section: Quote: Print row and column headings or labels on every page
Row headings are the row numbers to the left of the worksheet; column headings are the letters or numbers that appear at the top of the columns on a worksheet.
1) Click the worksheet.
2) On the File menu, click Page Setup, and then click the Sheet tab. To print column labels on every page, under Print titles in the Rows to repeat at top box, enter the rows that contain the column labels, and then click Print.
To print row labels on every page, under Print titles in the Columns to repeat at left box, enter the columns that contain the row labels, and then click Print. | |