Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem Scaling to 1 Page Wide
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem Scaling to 1 Page Wide
"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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem Scaling to 1 Page Wide
Why not to go to File Page Setup Margins and click the bottom section
"Center On Page" and select Horizontally? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem Scaling to 1 Page Wide
DNA - thanks, but it is already centered horizontally, with equal extra space
on both the right and left. -- Pete "DNA" wrote: Why not to go to File Page Setup Margins and click the bottom section "Center On Page" and select Horizontally? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem formatting for printing | Excel Discussion (Misc queries) | |||
Totaling Each Page | Excel Discussion (Misc queries) | |||
page break preview | Excel Discussion (Misc queries) | |||
tOTALS WON'T PRINT ON SAME PAGE | New Users to Excel | |||
Page Break Problem | Excel Discussion (Misc queries) |