View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default How can I limit a worksheet to one page?

In EXCEL 2007 try this:-

Page Layout tab / Page Setup group / single left hand click on the arrow in
the lower right hand corner / Page Setup should launch / Page tab / slect Fit
to: (so that it has a gree dot in it) / and make ssure that to the right of
this it reads 1 page(s) wide by 1 tall.

Please hit Yes if my comments have helped.

Thanks!

"xicapaty" wrote:

I want my worksheet to be on one page so that a lot of pages don't print out
if I forget to specify only one page when I print.