top of page

Set Excel Cell as A Square

Updated: Oct 28, 2020

Have you tried to set the Excel cells to have the column width equal to the row height? However you will never get a square as what you expect. Frustrated? In this section, you will learn the tip to do so.

"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi

What we usually do is to select the columns and right click the column header to open the Column Width input box. For example, you set the value to 10. Then select the rows and right click the row header to open the Row Height input box and key in the same value 10. However you will get a rectangle unfortunately.

The easiest way to set the cell as a square is to change the view to Page Layout at the first step. On the menu strip, click View then switch from Normal to Page Layout.

From there, you can repeat the same method to change column width and row height to the same value. But this time, if you are careful enough, you will find a unit behind the value in both input boxes, e.g. row height: 0.98cm. However you won't see it in Normal View, right? After you set the column height at 0.98cm, a square cell is available.

In the above example, the unit is cm. Actually Excel has other units as well, e.g. Inches, Millimeters. You can open Excel Option->Advanced->Display to change the ruler unit from the drop down list.

With all the square boxes, your Excel suddenly becomes a simple graphic design tool. Do you believe the logo of Excel Magic World was first designed with Excel cells? Try it yourself now.

17,115 views0 comments

Recent Posts

See All
bottom of page