Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"file"...."page setup"...."sheet", click on the 'rows to repeat at top'
button, it will pop up a small window. Then go to your sheet and left click and highlight the column headings and hit enter. It will then automatically print this row(s) of heading names on each sheet. "Sarasmatic" wrote: I've created an Accounts Payable spreadsheet, and I need the names of my columns (Payee, Invoice Date, Invoice Number, etc.) to print at the top of each page. It's such a pain to wait until I've finished the sheet, and then go to where the page breaks are and insert a new row, and then paste the column names in it. If I need to go back and revise any part of the spreadsheet, then I have to delete and recreate in another place those rows that I've added. Is there a way to set print options so that the names of my columns can print at the top of each page? (Not the A, B, C, etc.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Print more then one page in excel from a word object | Excel Worksheet Functions | |||
How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) |