Setting cell size to scale
 

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

Setting cell size to scale
 

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/...vbawssetrowcol


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 10:47:01 -0700, D Brooks
wrote:

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

Gord Dibben MS Excel MVP