Thread: Print Setup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Leah Leah is offline
external usenet poster
 
Posts: 9
Default Print Setup

The print area is set for the information that needs to print. I just need
it to print all on one page without resizing the first few rows.

"Trekman" wrote:

On Feb 4, 5:15 pm, Leah wrote:
I am trying to print multiple tabs with the same first 5 or 6 rows. The
pages vary in length, but I need them to be one page each. I set the page to
"Shrink to Fit Page" so that all the information print out on one page.
However, I need those first 5 or 6 rows to be uniform through out all the
pages for uniformity. Is there a way to set the page up to print everything
on one page without shrinking certain rows. I can't add the information as a
header. It doesn't line up the information with the body of the report
correctly if I do. Somehow I just need the size of those rows to be fixed
even though the rest of the report "shrinks". Does anyone know if that's
possible?


I believe you should set the print range on each separate page for
what you want to see on your printout. Then when you select numerous
tabs for printing, each will print as its setup as you have
specified. Use print preview to be sure it is like you want it.
.