How to make cells perfect squares in Excel?

Question

In Microsoft Excel,

I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done?

---

Surprisingly, Excel says:

Row height: 15
Column width: 8.43

So, these are not on the same scale.

Making both of them 8.43 gives me this:

Now, what should I do?

Answer 1

Excel's column width is measured by the number of zeros (0) that can fit in the cell at the Normal style. To convert to points (how row height is measured), see

http://www.dailydoseofexcel.com/archives/2004/06/01/column-widths-in-points/

If you don't need to be exact, just eyeball it. If you do need to be closer than eyeballing, put a square from the Drawing toolbar on your sheet and size it. If you want it 10 x 10, use code like this:

sheet1.Shapes(1).Height = 10
sheet1.Shapes(1).Width = 10
sheet1.Shapes(1).Top = sheet1.Shapes(1).TopLeftCell.Top
sheet1.Shapes(1).Left = sheet1.Shapes(1).TopLeftCell.Left

Then you can manually size your row and column to fit the square and read the height and columnwidth.

Answer 2

First, select the cells you want to resize. Then on the Home tab, go to Cells box and click on Format option. Here you can change the Row Height and Column Width of the selected cells as you want.

Answer 3

Select all (or the rows/cols you need), then drag to resize to your desired size.

1. You can drag to resize the column width.
2. When you do, a tooltip appears with the exact pixel count.
3. Remember the pixel value!
4. You can also drag to resize row height, it works the same way.
5. Drag to the same pixel value.
6. Done!

Answer 4

Click and drag on the border between the rows. To resize more than once column/row at a time, select them all, right click and click "Row Height..." and set it to the same height as the rows are wide.

Answer 5

• Select the columns (click the A column, then hold shift and click the other end)

• Right click on one of the columns, click Column Width and then enter a new value.

• You can do the same with a row, then click Row Height to get the height of a row.

Answer 6

If you wanted to do it for the whole sheet, you could use this trick - which may be helpful anyway: click the box to the left of column heading A to select all cells; click on and drag one of the column header dividers to the size you want, noting the number of pixels for the resulting cell width (I'm using Excel 2007, which shows this); do the same for one of the row label dividers, matching it to the column width by pixels. This should make all cells in the sheet boxes. Which of course is not what you asked, but I had hoped this trick would work with a subset of cells. Unfortunately it doesn't.

Answer 7

I wanted to make a perfect square grid for a sewing project and kept getting all kinds of weird answers for this question, so I decided to play with it myself to figure it out. I discovered it's impossible to get a perfect square, but I came as close as you can get, just a sliver off. highlight the squares you want to format, then go to the format tab and format the column width at 12.43, then format the cell height to 75.00. Using a ruler I found I was just a fraction off at 7 and 10 inches in length. Hope this helps.