Resize all cells so that entire data fits in screen

%3CLINGO-SUB%20id%3D%22lingo-sub-2759891%22%20slang%3D%22en-US%22%3EResize%20all%20cells%20so%20that%20entire%20data%20fits%20in%20screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759891%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20automatically%20resize%20all%20cells%20in%20a%20spreadsheet%20so%20that%20all%20of%20the%20data%2C%20the%20entire%20spreadsheet%2C%20fits%20onto%20screen%20at%20once.%20Should%20I%20write%20a%20custom%20function%20which%20computes%20the%20size%20for%20each%20cell%20given%20the%20number%20of%20cells%20and%20the%20size%20of%20the%20screen%3F%20How%20could%20I%20get%20the%20%22size%22%20of%20the%20screen%3F%20I.e.%20Excel%20has%20sizes%20for%20cells%2C%20for%20example%20a%20column%20width%20of%2040%20is%20maybe%202%20inches.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2761652%22%20slang%3D%22en-US%22%3ERe%3A%20Resize%20all%20cells%20so%20that%20entire%20data%20fits%20in%20screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154117%22%20target%3D%22_blank%22%3E%40jukhamil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20of%20an%20odd%20request.%20It%20might%20help%20others%20help%20if%20you%20gave%20a%20few%20more%20parameters.%20For%20example%3A%3C%2FP%3E%3CUL%3E%3CLI%3EAre%20you%20talking%20about%20fitting%20the%20spreadsheet%20to%20any%20kind%20of%20screen%20(from%20smart%20phone%20to%20large%20display)%3F%3C%2FLI%3E%3CLI%3EAre%20you%20concerned%20about%20legibility%3F%3C%2FLI%3E%3CLI%3EDoes%20this%20apply%20also%20to%20printing%20on%20a%20single%20page%3F%3C%2FLI%3E%3CLI%3EWhat%20kind%20of%20%22stuff%22%20is%20in%20the%20cells--data%2C%20words%2C%20numbers%2C%20colors%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Contributor

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

@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?