Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
How do I print the same sheet multiple times with increasing page. | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |