Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module:Ĭode for setting row height in centimeters: Sub RowHeightInCentimeters()Ĭm = Application.InputBox('Enter Row Height in Centimeters', _ Select the cells that you want to set them in centimeters.Ģ. The below two codes can help you to set column width and row height. You can’t set the height and width in centimeters with Excel’s functions, except for using VBA code. Set cell size in cm (centimeters) with Kutools for Excel Set cell size in cm (centimeters) with VBA code But, sometimes you need to change the height and width to centimeters for some purpose. And in Excel, it is difficult for you to set the row height or column width in inches or centimeters. On a worksheet, the default units for the row height and column width are preset, and the default column width is 8.38 characters and the default row height is 12.75 points. How to set cell size in cm (centimeters) in Excel?