Forum Discussion
Using cm or mm instead of pixels for height/width
Hi there, I have checked help, I have checked the forums and all seem to agree that to change the units from pixels to another unit i.e. cm or mm, you should go to advanced options and in the drop do...
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)