Re: Need help with printing Excel document

What CLR wrote is true BUT only if you don't have too much information to
fit onto a page. If you have more than will 'naturally' fit into a page
you'll have to get up to a few neat tricks. It is possible to put in page
breaks to ensure breaks at 'convenient points. But let's assume, for the
moment that you want everything to go onto a single page.

Trick one (and a good habit to get into anyway): Make sure that column
widths are the minimum possible. This is a god thing to do anyway as it
reduces white space and makes information easier to read. Wrapping some
columns so that a line is extended into two or so increases the space
required vertically and reduces the space required horizontally.

Trick two: Reduce the font size. Reducing the font size by just 0.5 is,
more-or-less, imperceptible to the naked eye but may be just enough to
squeeze information into a page.

Trick three: Reduce the margins. Again, depending on the amount of space
required a slight change may be just enough.

Trick four: Print in landscape instead of portrait.

You may have to use some or all of these tricks.

Regards.

Bill Ridgeway
Computer Solutions

"CLR" <croberts@xxxxxxxxxxxxxxx> wrote in message
news:uWI97ApeFHA.1040@xxxxxxxxxxxxxxxxxxxxxxx
> Highlight all the cells you wish to see printed out. Then do File >
> PrintArea > SetPrintArea...........then do File > PrintPreview.......what
> you see is what will print out, assuming you have the correct print
> drivers
> and margins set etc.........
>
> If it still don't work, post back with more details.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "jody mullis via OfficeKB.com" <forum@xxxxxxxxxxxx> wrote in message
> news:507040B8C48C0@xxxxxxxxxxxxxxx
>> I want to print it out exactly as it looks on the screen. With all the
> cells
>> and rows visable.
>
>


.

Relevant Pages

  • Re: we got one ;P
    ... >> If enemy troops do come marching down my block, ... >> fit in my house will do the trick. ...
    (rec.photo.equipment.35mm)
  • Re: feedback
    ... I need to leave a detailed feedback on a scammer and it won't fit on one ... What trick can I use to allow me to add a second line? ...
    (alt.marketing.online.ebay)
  • Re: feedback
    ... I need to leave a detailed feedback on a scammer and it won't fit on one ... What trick can I use to allow me to add a second line? ... How about giving us the name of the seller and everything that happened as ...
    (alt.marketing.online.ebay)
  • Re: feedback
    ... I need to leave a detailed feedback on a scammer and it won't fit on one ... What trick can I use to allow me to add a second line? ...
    (alt.marketing.online.ebay)
  • Re: Font-size buttons
    ... >changing the page's font size: ... AFAIK *every* graphical browser has that sort of ability (as long as the ... >This page button trick may be more convenient. ...
    (comp.infosystems.www.authoring.html)