Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data that comfortably fits in one page in Portrait orientation.
However, there's plenty of space on the sides that is available to expand the data into, thus making the data larger and more visible. The data has been centered vertically and horizontally. Is there a way aside from margins, to enlarge/expand the same centered data to fill the sides while maintaining it in one page? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
While Excel will shrink to fit, there's no corresponding 'expand to fit'.
However, you can achieve the same effect. Just make your source data large (for example, by increasing the font size). In Page Setup, select Fit to one page wide and one tall. Excel will then fill the page, no matter the orientation. Regards, Fred. "Manny" wrote in message ... I have data that comfortably fits in one page in Portrait orientation. However, there's plenty of space on the sides that is available to expand the data into, thus making the data larger and more visible. The data has been centered vertically and horizontally. Is there a way aside from margins, to enlarge/expand the same centered data to fill the sides while maintaining it in one page? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expand a box | Excel Discussion (Misc queries) | |||
Expand a Spreadsheet | Excel Worksheet Functions | |||
Expand columns | Excel Worksheet Functions | |||
How do I expand a worksheet? | Excel Discussion (Misc queries) | |||
How do I expand the Name Box? | Excel Discussion (Misc queries) |