I want to change the grid into a pattern of square cells. I want the hight
and width to be equal. Can this be done?
The reason is that I want to use the grid as a background for simple
drawings of products. Is there perhaps a better way to do this in an
office-program?
elika
Row heights are measured in points or pixels. There are 72 points to an inch
and quot;maybequot; 96 pixels to the inch.
The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.
For an interesting and enlightening discussion on this subject see
snipurl.com/dzz8
If you want to use VBA to set height and width in mm.
Ole Erlandson has code for setting row and column dimensions.
www.erlandsendata.no/english/...vbawssetrowcolGord Dibben Excel MVP
On Wed, 5 Apr 2006 07:45:01 -0700, elika gt;
wrote:
gt;
gt;I want to change the grid into a pattern of square cells. I want the hight
gt;and width to be equal. Can this be done?
gt;
gt;The reason is that I want to use the grid as a background for simple
gt;drawings of products. Is there perhaps a better way to do this in an
gt;office-program?
Gord Dibben MS Excel MVP
Elika,
You will be better served to use a different application for your purpose.
You might even find it easier to simply use some 1/4quot; square lined paper, but
if you need to have your drawings in electronic format, then MS Visio might
be able to accommodate what you need; otherwise you could find a simple (but
less functional) design or floorplan software.
quot;elikaquot; wrote:
gt;
gt; I want to change the grid into a pattern of square cells. I want the hight
gt; and width to be equal. Can this be done?
gt;
gt; The reason is that I want to use the grid as a background for simple
gt; drawings of products. Is there perhaps a better way to do this in an
gt; office-program?
Thank you so much for your help! I think I got it!
quot;elikaquot; skrev:
gt;
gt; I want to change the grid into a pattern of square cells. I want the hight
gt; and width to be equal. Can this be done?
gt;
gt; The reason is that I want to use the grid as a background for simple
gt; drawings of products. Is there perhaps a better way to do this in an
gt; office-program?
- Jun 22 Fri 2007 20:38
square cells
close
全站熱搜
留言列表
發表留言