LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Maximize all collumns and rows (evenly distributed) on 1x1 page la

I want to automatically make my worksheet maximize all rows' heights and
columns' widths for printing on 1 page. When I set the page to print on 1x1
size it always seems to have a large blank spot that I can only get rid of by
trial and error adjustments of all the rows and columns. Is it possible to
do this automatically via a macro.

I have a worksheet with 6 rows and 4 columns that I am working with at first.

thanks

 
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
Summing large number of non contiguous cells evenly distributed James D Excel Worksheet Functions 5 September 7th 08 04:53 PM
Columns distributed evenly in worksheet Aussie[_2_] Excel Discussion (Misc queries) 3 July 2nd 08 09:10 PM
Switching from collumns to rows Shazza Excel Discussion (Misc queries) 3 February 20th 07 12:15 PM
evenly spaced page breaks sorrywm Excel Discussion (Misc queries) 2 December 15th 05 12:25 AM
Collumns and rows smintey Excel Discussion (Misc queries) 2 February 15th 05 05:10 PM


All times are GMT +1. The time now is 02:24 AM.

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"