View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Printing a long spreadsheet on 1 page only??

I had already been playing around with the "Print area" and the
"landscape" options.... but those "scaling" options finally got
it working to my liking.

Thanks soo much!

"JBeaucaire" wrote in message
...
1) Highlight the range of cells, widthwise, that you want to print, then
select
FILE PRINT AREA SET PRINT AREA

2) Then select FILE PAGE SETUP Page: Orientation: Landscape
3) Also use the SCALING options if you wish to limit the # of pages used.

Does that help?