Forum Discussion
Using cm or mm instead of pixels for height/width
For instance i know a box label is 204*38mm, so when i go to excell, i want to be able to set column width to 204 mm and row height to 38 mm (for instance as is possible on Google Sheets).
First, on ribbon you select View->Page Layout
After that select any column(s), right click->Column width and here you may define it in cm or inches, whatever
Thank You!
It is much more complicated that i would expect it to be, but it does exactly what i need in the end.
You saved me a lot of nerves, thank You a lot 🙂 !
- One only fault of this method is, even if i set for instance 19mm for row heigh, excell changes the value to 18.79mm..
Finally Excel in any case operates in terms of pixels and points. Point scale for row height is from 0 to 409 Change the column width and row height - Microsoft Support , point is proportional to pixel.
If to define row height as 1.9 cm Excel takes nearest number of points and adjust the height accordingly. Above is just an idea, I could be wrong in details. Bit more info in that discussion Excel Row Heights in Fixed Increments (microsoft.com)