Forum Discussion
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.
1 Reply
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?
