+ Reply to Thread
Results 1 to 5 of 5

Sheet Size (not file size)

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    84

    Sheet Size (not file size)

    Hello,

    Does anyone know if there is a macro out there that minimizes the physical size of a spreadsheet - so that it fits on the smallest sized printout? I'm looking for something that will play with column and row width/height of a large spreadsheet and come back with an "optimized" solution.

    * No sample document.

    Thank you,

    Vitaly

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,888

    Re: Sheet Size (not file size)

    How about something like this?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-15-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Sheet Size (not file size)

    So Autofit doesn't always optimize, it has trouble with wrapped text and knowing how much it can push the width together at the expense of height. When I do it manually it almost requires playing around with the manual autofit function. I think the issue is that autofit considers just the row/hight but not the spreadsheet as a whole.

  4. #4
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Sheet Size (not file size)

    What you are asking is a human choice. There is no "best", especially if your dealing with wrapped text and odd formatting like merge cells.

    The page setup/print features in Excel provide some means for fitting content, but it does it in 2 primary ways: spreading it across pages and/or scaling all of the content. It does so base don the print area that has been defined. Basically an all or nothing approach.

    You can use the built in autosize feature, in which case Excel decides what is best which may differ from you or someone else's concept of what the best fit would be or you can tell Excel what size to use for rows/columns. This can be done static or potentially using some sort of calculation I guess...but itd be quirky and likely not help. The issue is as per the first point and scaling. What fits within a row or column now when printing may not scale the same as more/less rows/columns are in the print area and Excel scales everything to fit in your desired page setup. Ex: a column at 10 width may fit all the content just right now because its scaled at lets say 54% (even fit x by y pages becomes a scaled %) and the next time you go to print the content requires a scale of 45% (presuming rows/columns added), meaning everything is smaller, meaning the content may get cut off at the same column width (10) as before.

    Usually people decide how many pages wide x tall they are willing to have, how many rows/columns they are willing to have on each sheet...and then size rows/columns to fit into that paradigm as this way you are limiting the scaling and your efforts sizing rows/columns isnt superseded by scaling.

  5. #5
    Registered User
    Join Date
    04-15-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Sheet Size (not file size)

    Fair enough. I was hoping there would be a way to optimize to the most "square" shape or one that would
    overall take the least amount of sqr inches for the whole document. It makes sense that this is not built out somewhere.

    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 08-07-2017, 02:49 PM
  2. Replies: 2
    Last Post: 03-11-2016, 12:41 PM
  3. Size of Size of the Excel File saved on a networkdrive
    By cpmsimoes in forum Excel General
    Replies: 0
    Last Post: 08-12-2015, 06:01 AM
  4. How to get file size from a given folder as input and categorize the files based on size
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 05:49 PM
  5. Replies: 8
    Last Post: 11-28-2012, 02:33 AM
  6. [SOLVED] Excel 2007 : File size has increased in size...Why
    By THORmx in forum Excel General
    Replies: 3
    Last Post: 02-12-2009, 02:39 AM
  7. Sheet vs File size when sending email in Outlook
    By matchball in forum Excel General
    Replies: 0
    Last Post: 01-04-2006, 03:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1