How to make cells perfect squares in Excel?

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?

Solution 1:

One more way...change your view to Page Layout. This changes the grid scale to inches, and then you can specifically set both height and width to the same value (e.g..25 inches). IMO page layout is the best standard view for working on the appearance of the spreadsheet.

Here's an example with the actual dimensions for both views:

Solution 2:

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

1. Drag a column header's edge to resize the column width. A tooltip appears with the exact pixel count.
2. Remember the pixel value!
3. Drag a row header's edge to resize row height, it works the same way.
4. Drag to the same pixel value.

Done!