I want to make all rows and all columns the exact same size. How do I do that?
C ChessNut Sep 20, 2005 #1 I want to make all rows and all columns the exact same size. How do I do that?
G Gord Dibben Sep 20, 2005 #2 Chess 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
Chess 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
G Gary''s Student Sep 20, 2005 #3 Height is measured in points (72 points to the inch) Width is measured in points (12 points to the inch) To make a chess board with 1 inch squares, select the entire worksheet and set all the row heights to 72 and column widths to 12
Height is measured in points (72 points to the inch) Width is measured in points (12 points to the inch) To make a chess board with 1 inch squares, select the entire worksheet and set all the row heights to 72 and column widths to 12
B bill kuunders Sep 20, 2005 #4 Or to do it in pixels 17 pixels high and 20 wide will give you the smallest possible square