This day the editor just went to work, the old editor sent a message: quickly use Excel to type a few square grids, here is an urgent need! I thought to myself, what squares do you make in an editorial department? Having said that, the old editor has to listen. I had to turn on the computer, open my beloved Excel, first set the row height to “50”, and then set the column width to “50”, eh? Why is it different from what you imagined, the thing in front of you doesn’t look like a square. What’s the matter?
The effect after the row width and column height are all set to “50”
In fact, this problem is related to a very NC design in Excel. It turns out that in Excel, the units used for row height and column width are not the same. The row height uses “points” and the column width uses “pixels”. The two are neither the same kind of unit, nor can it be directly converted. This is what happened at the beginning of the article: setting the two to the same value, of course, it is impossible to get a square of equal length and width.
So in Excel, is it really impossible to draw a square directly?
1. Convert “row height” to “CM”
The first thing to be clear is that the “pound” in Office is actually a unit of length (point), which can be approximated to cm, that is, 72 points = 1 inch = 2.54 cm . Therefore, when we want a row height of 3CM, we can solve the corresponding pound value according to the above formula: 3x(72/2.54)=85.0394 (pounds). Finally, enter this value into the “row height” dialog box, and you will get a cell approximately 3CM high.
After conversion, it is the point size in “cm”
2. Convert “Column Width” to “CM”
The same is true for the column width, but it uses a more special unit-“pixel” . Pixel is neither a unit of length nor can it be converted to CM, because it is also related to another important parameter, which is-“resolution”. But we can skip this restriction in another way.
Switch to “page view”
First open the workbook, click “View” → “Page Layout”, then a “ruler” will appear above the original worksheet. Next, right-click the column you want to set (or Ctrl+A to select all and right-click), and click “Column Width”. At this point, you will find that there is an extra “cm” unit under the original column width prompt box.
A set of rulers will appear at the top of the table under “Page View”
With “cm”, the rest of the operation is much simpler. Enter the line height cm value that has just been set (3cm). Finally, return to the “normal view”, and finally we get a set of squares with equal length and width.
note! The unit of column width here has been automatically changed to “cm”
Write at the end
This problem is not uncommon in daily work. Especially when making some special forms or copybooks, the problem of inconsistent units such as Excel often makes many people a headache. As for finding the cm unit in the page view, it is a little secret hidden by Excel.
The final square cell
For more such interesting article like this, app/softwares, games, Gadget Reviews, comparisons, troubleshooting guides, listicles, and tips & tricks related to Windows, Android, iOS, and macOS, follow us on Google News, Facebook, Instagram, Twitter, YouTube, and Pinterest.