How to make cells perfect squares in Excel?
Problem
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: So, these are not on the same scale. Making both of them 8.43 gives me this: Now, what should I do?
Error Output
Row height: 15 Column width: 8.43
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to make cells perfect squares in Excel?
One more way...change your view to Page Layout. This changes the grid scale to inches (or the system default units), and then you can specifically set both height and width to the same value (e.g. 0.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: This technique can be used to create specifically sized charts and tables for use to copy/paste into other productivity products (e.g. …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix