In this Article we will learn to create a Grid in Excel:

The trick is to square up the cells. The gauge is less important. Like graph paper, a cell can equal anything you want. The hard part is getting the width and height settings to produce a square because there's no easy way to match a cell's height and width settings. You can't just set the row height and column width to the same value because:

  • Excel measures row height in points.
  • Excel considers the current font when calculating column width; a column width of 5 means that the column will display 5 digits, using Normal style.

You could spend a lot of time tweaking the height and width and you could even try holding a ruler up to your screen, but there's an easier way. Format an AutoShape as a square and use it as a guide. First, you need to insert and format an AutoShape as follows:

1. From the Drawing toolbar, choose Basic Shapes from the AutoShapes drop-down list Insert this rectangle to the first cell A1:

basic shapes

2. Right click on the rectangle and select size and properties:

size and properties

3. Make width and height equal as per your requirements:

width and height

4. Now Select all cells and make the dimensions equal to the shape:


5. We can add borders to make it look good.

add borders