Windows – How to make cells perfect squares in Excel

microsoft excelmicrosoft-excel-2007windows

In Microsoft Excel,

alt text

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:

alt text

Now, what should I do?

Best Answer

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:

Square Cells

Related Question