Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
change size of in cell drop down list | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
show macro security setting in a cell | Excel Worksheet Functions |