Excel - Set Cell Size (Column Width and Row Height) in Inches, Centimeters or Millimeters

preview_player
Показать описание
In this video I demonstrate how to set cell size in Microsoft Excel (column width and row height) in either inches, centimeters or millimeters (US spelling).
------------------------
Рекомендации по теме
Комментарии
Автор

Thanks Chester. Did not know about this feature. When I set Col and Row to both 1 inch and then go back to Normal View, the Col width is shown as 12 and the Row height is shown as 72. What are these numbers? If pixels, shouldn't they be the same? Just curious. Thanks for sharing! Thumbs up!!

wayneedmondson
Автор

Thank you very much for this very helpful lesson!

arturhawk
Автор

Thank you for putting this online for all to see. I knew this was possible but had forgotten how.

blizziej
Автор

Aloha from Hawaii🌺
Thank you for this great video, it really helped me alot regarding inches. I've always had problems with that in particular. 🖥 😊

raynebannister
Автор

Thank you for this tutorial Chester. Happy new year!!

IvanCortinas_ES
Автор

Thanks Chester! Super helpful. When I went to print this out, the column widths were spot on. The row heights, however, were about 3% smaller than they were supposed to be. Going back to my file, I noticed that the same discrepancy was reflected in the Page Layout view when comparing the row heights to the ruler. Any idea why this doesn't line up?

jacobworthington
Автор

Why doesn't Excel let us do this in pixels? Google sheets defaults to pixels when you adjust a column. Unfortunately my professor doesn't accept work done in Sheets, smh.

FalonElise
Автор

Using Excel 365, this method generates an error.

rcsontag