You can manually set the Row Height option, whereas Autofit row height will automatically adjust the height based on the cell’s text or font size.īelow are the different ways of changing row height: 1. In the Home tab under the format option, you can adjust the row height or column width. The cell having a row height equal to 1 point is approximately 0.035 cm, whereas the height of a hidden row is zero. One can also set a row height in Excel manually, starting from 0 to 409 points.
This row height varies depending on the display scaling (DPI) from 15 points on a 100% dpi to 14.3 points on a 200% dpi. If the text that you have entered is in Times New Roman font style in Excel 2013, the row height is default 15 points.
Excel functions, formula, charts, formatting creating excel dashboard & others
