Setting cell size to scale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to structure a worksheet with cell height 2.5 times the cell width. I
need the cell to represent a plot 4 ft wide by 10 ft height. Is there a way
to format a worksheet in this way that does not involve repeated printing and
measuring with a rule?!
 
Brooks

Assuming 96 pixels per inch you could approximate but at different resolutions
your approximation can be off.

If you want to use VBA to set height and width in mm which you then convert to
inches at 25.4 mm per inch..........

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben MS Excel MVP

I need to structure a worksheet with cell height 2.5 times the cell width. I
need the cell to represent a plot 4 ft wide by 10 ft height. Is there a way
to format a worksheet in this way that does not involve repeated printing and
measuring with a rule?!
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top