G
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?
words, I want to print squares 1 inch by 2 inches; how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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..
rulers in word.. not sure if you can in excel..
J
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
WinXL, it takes a macro. See
http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol
D
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.
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.
G
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
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