View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Problem Scaling to 1 Page Wide

Well there was something out there, but I've deleted rows and columns so that
now ctrl-end goes to the bottom-right corner of my content.

I saved the spreadsheet, re-opened, hit ctrl-end to ensure it still goes to
the bottom-right of my content (it does), but I still have the problem.

--
Pete


"Stephen" wrote:

"Pete" wrote in message
...
I format most spreadsheets I create to 1 page wide, <blank pages tall.

Occasionally, when Il receive a spreadsheet from someone else and try to
reformat it to be "1 page wide, <blank pages tall", it isn't formatted
wide
enough. There is between one-half inch to one inch space between the
spreadsheet contents and the left and right margins.

If I adjust the scaling manually to a particular %, it's fine.

Suspecting a print driver problem, I've tried changing printers, but no
luck.

Any idea what setting might be preventing me from using the full 1 page
wide?

Thanks

--
Pete


It could be that there is something, even just a space character, in a cell
to the right of the data you can see. Use CTRL+END to take you to the last
used column/row to see if this is the case. If so, delete any column(s)
between the rightmost one you want and the last used one.