Making Grid in Excel 1

[BigH]

Does anyone know how to adjust excel cells to give a uniform grid at, say, 1 cell = 5mm?

I want to make a design brief and would rather do it in excel than in Autocad.

Thanks - Best of the holiday season. (GO BUCKEYES!!)

 

[melone]

How about sizing it to pixels? The number of pixels are displayed whenever you manual resize a row / column.

 

[FH]

Dear BigH,
To set the width and height of cells so that both be equal in size, you should set the height about 6 times the width.
It need some trial and error to find the no. of pixels required to make 5mm length.

Farzad

 

[owg]

I have used Excel many times to prepare block flow diagrams. Holding down the Alt key while drawing lines, locks the ends of the lines to the grid. Make blocks cover an even number of squares then joining lines can enter the middle of the the blocks. Use copy and paste to replicate blocks and position them by holding down Alt. Use a shading effect to distinquish blocks from lines.

 

[BigH]

Thanks - will try your comments.