In Microsoft Excel,

alt text

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


It's quite interesting to see excel say

Row height: 15
Column width: 8.43

They're 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). The imo page layout is the best standard view for working on the appearance of a spreadsheet

Here's an example with the actual dimensions of both views

Square Cells