How can I resize columns and rows to inches?

[Guest]

I can't find out how to make my columns and rows conform to inches; in other
words, I want to print squares 1 inch by 2 inches; how?

 

[Guest]

In all honesty, I think that might work easier in word.... you can pull up
rulers in word.. not sure if you can in excel..

 

[JE McGimpsey]

In MacXL04 you can set column width and row height in inches/cm. For
WinXL, it takes a macro. See

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

 

[drlogarithm]

How about just marking the edges of the cell, printing out a few cells
and then measuring with a ruler? Let's say the cell is 9.00 wide in
Excel and the print measures to 1/4 of an inch then change the width to
32 for an inch. Simularly, you can do this for the height.

 

[Gord Dibben]

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 Excel MVP