Making Grid in Excel 1

BigH · Dec 28, 2002

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 · Dec 28, 2002

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

FH · Dec 28, 2002

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 · Dec 29, 2002

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 · Dec 30, 2002

Thanks - will try your comments.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Making Grid in Excel 1

BigH

Geotechnical

melone

Electrical

FH

Mechanical

owg

Chemical

BigH

Geotechnical

Similar threads

Part and Inventory Search

Sponsor