Forum Discussion

jukhamil's avatar
jukhamil
Brass Contributor
Sep 17, 2021

Resize all cells so that entire data fits in screen

Hey,

 

I would like to automatically resize all cells in a spreadsheet so that all of the data, the entire spreadsheet, fits onto screen at once. Should I write a custom function which computes the size for each cell given the number of cells and the size of the screen? How could I get the "size" of the screen? I.e. Excel has sizes for cells, for example a column width of 40 is maybe 2 inches.

 

Thank you very much.

Macros and VBA

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor
    Sep 17, 2021

    jukhamil 

     

    Kind of an odd request. It might help others help if you gave a few more parameters. For example:

    • Are you talking about fitting the spreadsheet to any kind of screen (from smart phone to large display)?
    • Are you concerned about legibility?
    • Does this apply also to printing on a single page?
    • What kind of "stuff" is in the cells--data, words, numbers, colors?

Resources