In MS-Excel, is there a way to print column headings on every page....?

Question

....of a long document?

Thanks to all who answered: lots of smart folk out there when you need them.
Your instructions worked like a charm, first time!

Answer 1

Yep, it's in File-page setup, then click the sheet tab at the top. "Rows to repeat at top".

To make it easier to work, you may also want to do Window-Freeze Panes (after clicking the cell below the one you want to freeze) so the rows freeze at the top of your spreadsheet and the rest of the spreadsheet scrolls past them.

Answer 2

It is in the page setup. From the menu click File - Page Setup. Go to the sheet tab and where it ways Rows to repeat at top, click the red arrow (makes a smaller box) and then click the row number (far left side of columns), then click the red arrow again. Say ok and you're done!

Oh, don't forget to save!

Answer 3

I am not sure what you are asking but you could cut or copy the data on the second and third pages and paste (or highlight and drag) it to a new column on the first page. Print the first page just for checking. It is then up to you to "save as" that version or undo the changes.

Answer 4

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.

Click the worksheet.
On the File menu, click Page Setup, and then click the Sheet tab.
Do one of the following:
Print row and column headings

Select the Row and column headings check box, and click Print.

Print row and column labels on every page

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.

Answer 5

http://www.officearticles.com/excel/repeat_rows_at_top_when_printing_in_microsoft_excel.htm