LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim M
 
Posts: n/a
Default How do I print the names of my columns on each page? (Excel)

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print a single column of data in two columns on one page Neal Excel Discussion (Misc queries) 1 January 8th 06 11:31 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Print more then one page in excel from a word object Alex Martinez Excel Worksheet Functions 0 October 14th 05 06:22 AM
How to print multiple columns on same page ocpsduke Excel Discussion (Misc queries) 2 October 8th 05 06:19 PM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"