View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default Printing: fit to 1 page

I have a large list of data that I am trying to print. I have about 160 rows
by about 35 columns give or take 5; I am often hiding and unhiding columns. I
set it so everything fits to 1 page. When i hide and unhide rows it is often
not expanding to take up the entire page when it prints. I have to
constantly adjust my fonts and columns to strecth to the full page. Is their
a way that it will automatically adjust to ttake up the whole page?

thanks,

Jase