Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Centerally Expand for Better Printing

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Centerally Expand for Better Printing

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expand a box Ruth Excel Discussion (Misc queries) 1 September 29th 08 07:46 PM
Expand a Spreadsheet Doug Excel Worksheet Functions 0 April 2nd 08 06:32 PM
Expand columns valiantria Excel Worksheet Functions 2 January 11th 07 10:05 PM
How do I expand a worksheet? cubc Excel Discussion (Misc queries) 1 October 14th 06 01:33 AM
How do I expand the Name Box? JohnnyQuick Excel Discussion (Misc queries) 4 July 8th 05 04:51 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"