How can I resize columns and rows to inches?
 

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?

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

"Max Gough" wrote:

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?

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

In article ,
Max Gough <Max wrote:

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?

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.

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


On 30 Jun 2005 12:05:18 -0700, "drlogarithm" wrote:

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.