Sign in with
Sign up | Sign in
Your question

Excel 2003 - fit printing to page

Last response: in Windows XP
Share
Anonymous
August 30, 2005 6:24:07 PM

Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

There is a facility in Excel to automatically size the spreadsheet to fit
onto one printed page - very useful if you have a sheet which just overflows
on to 2 or 3 pages. It used to work for me in Excel 97, but with my new PC
(XP, Excel 2003 SP1) it does not. If I try to fit a 2-page spreadsheet onto
one page, it produces about 65 pages each with a microscopic bit of print.
Does anyone know if this is a known problem or something peculiar to my
configuration?
August 31, 2005 2:44:18 AM

Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

"John Styleman" <John Styleman@discussions.microsoft.com> wrote in message
news:BA6FC5C0-DA62-49AF-AB3B-FD77661A949E@microsoft.com...
> There is a facility in Excel to automatically size the spreadsheet to fit
> onto one printed page - very useful if you have a sheet which just
> overflows
> on to 2 or 3 pages. It used to work for me in Excel 97, but with my new
> PC
> (XP, Excel 2003 SP1) it does not. If I try to fit a 2-page spreadsheet
> onto
> one page, it produces about 65 pages each with a microscopic bit of print.
> Does anyone know if this is a known problem or something peculiar to my
> configuration?



I think you need to clear your print area (File - Print Area - Clear) and
then reslect the print are by draggin over the data you wish to print and
then setting the print area (File - Print Area - Set Print Area). It sounds
like the area to be printed is bigger than you think

If the area to be printed is too big then Excel just cannot scale it doen to
1 page x 1 page.

Andy
Anonymous
August 31, 2005 8:44:01 AM

Archived from groups: microsoft.public.windowsxp.help_and_support (More info?)

Many thanks, but that's not the answer. I tried it, to no avail! The sheet
I want to print is not very big - it only takes just over a page if I don't
try "fit to page".

"Andrew" wrote:

>
> "John Styleman" <John Styleman@discussions.microsoft.com> wrote in message
> news:BA6FC5C0-DA62-49AF-AB3B-FD77661A949E@microsoft.com...
> > There is a facility in Excel to automatically size the spreadsheet to fit
> > onto one printed page - very useful if you have a sheet which just
> > overflows
> > on to 2 or 3 pages. It used to work for me in Excel 97, but with my new
> > PC
> > (XP, Excel 2003 SP1) it does not. If I try to fit a 2-page spreadsheet
> > onto
> > one page, it produces about 65 pages each with a microscopic bit of print.
> > Does anyone know if this is a known problem or something peculiar to my
> > configuration?
>
>
>
> I think you need to clear your print area (File - Print Area - Clear) and
> then reslect the print are by draggin over the data you wish to print and
> then setting the print area (File - Print Area - Set Print Area). It sounds
> like the area to be printed is bigger than you think
>
> If the area to be printed is too big then Excel just cannot scale it doen to
> 1 page x 1 page.
>
> Andy
>
>
>
!