Simple Printing Question

B

Bob Newman

Excel 2000. I have a large but simple database with only 5 or 6 fields. If
I want to print the last several records of the database how do I get the
field titles to print at the top of each column, not only the 1st page but
on subsequent pages in the printout also?
 
R

Ron

Go to HELP and search on REPEAT TITLES in the Answer Wizard. Complete
instructions are there.
 
T

Tom Ogilvy

Just an added comment.
Since you stated your scenario as printing the last several records, if you
hide the area you designate in Rows to Repeat at Top,
they will no appear in the printout.

--
Regards,
Tom Ogilvy


Earl Kiosterud said:
Bob,

File - Page Setup - Sheet. "Rows to print at top."
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Pivot Row on when printing 1
How to set up Excel to print wrapped columns on a page. 1
MULTIPLE PAGES PRINT 1
Print Titles: Repeating both left column and top rows 2
Printing multi-pages 1
Printing Excel sheet 2
enlarging printout size 3
Printing Excel 2

Top