Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bafludnfront
 
Posts: n/a
Default I cannot get my sheet to fit the page

I have followed all formatting suggestions but in printing landscape, onto an
8.5 x 11" page, my worksheet still doesn't fit the entire page and is too
small to read, the spaces aren't adequate enough. I have tried adjusting row
height, and if I choose the scaling option then the end of my columns spill
onto another page....help! I use excel 2003
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

and if the sheet will not fit the page, is to small to see print, then how else would
you make it fit on one page but to make it even smaller. What are you actually
asking for.

The adjustments that have available are
-- margins, which are a bit easier to set from Pint Preview.
-- portrait or landscape
-- size of font, and squeezing some cells more than others
-- using cell wrap so that columns can be narrower
-- actually truncating some columns or rows
-- the scaling need not be applied in both horizontal and vertical directions
they are independent settings and you need only set one of them.

Another option to save paper is to get and use a duplex printer.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bafludnfront" wrote in message ...
I have followed all formatting suggestions but in printing landscape, onto an
8.5 x 11" page, my worksheet still doesn't fit the entire page and is too
small to read, the spaces aren't adequate enough. I have tried adjusting row
height, and if I choose the scaling option then the end of my columns spill
onto another page....help! I use excel 2003



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Page scaling & Page break preview prob Martin ©¿©¬ @REMOVETHIS.plus.com Excel Discussion (Misc queries) 1 July 17th 05 09:10 PM
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
How do I print the same sheet multiple times with increasing page. C&S Excel Discussion (Misc queries) 4 March 31st 05 09:21 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"