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!!
Just figured it out. The standard Row Height number seen in the dialog box is based on point measurement where 72 points equals 1 inch. The Column Width number seen in the dialog box is based on character units of the Normal font for display. So, the standard of 8.43 for Calibri 11 means that 8.43 characters of Calibri 11 will fit in the standard column width of a worksheet. Pretty obscure, but that is what it means :))
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?
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.
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!!
Just figured it out. The standard Row Height number seen in the dialog box is based on point measurement where 72 points equals 1 inch. The Column Width number seen in the dialog box is based on character units of the Normal font for display. So, the standard of 8.43 for Calibri 11 means that 8.43 characters of Calibri 11 will fit in the standard column width of a worksheet. Pretty obscure, but that is what it means :))
Thank you very much for this very helpful lesson!
Thank you for putting this online for all to see. I knew this was possible but had forgotten how.
Thank you for this tutorial Chester. Happy new year!!
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. 🖥 😊
thank you so much it helps a lot
Thank you very much. 👍🏻
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?
Thanks. Just what I need to know.
Thank you Mr Tugwell
very Persis video thank you sir
nice...thanks..
thanks a lot
Welcome!
Brilliant
Thanks!
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.
Using Excel 365, this method generates an error.