Setting Row Height and Column Width

Contact Us or call 1-877-932-8228
Setting Row Height and Column Width

Setting Row Height and Column Width

Set a Specific Height or Width

To change the row height or column width of rows and columns in a Microsoft Excel worksheet:

  1. Select a cell in your worksheet in the row or column of which you wish to change the height or width. To change the height or width of multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.
  3. Select Row Height or Column Width:
  4. In the Row Height dialog box or the Column Width dialog box, enter the new size of the row or column:
    1. Rows are measured in points, with each point equaling approximately 1/72 of an inch.
    2. Columns are measured in characters, so the value entered is equal to the number of characters that will fit in the cell (assuming you are using the standard font).

AutoFit Row Height or Column Width

When you AutoFit the row height or column width, Excel sets the height or width based on the contents in the row or column. To AutoFit the row height or column width:

  1. Select a cell in your worksheet in the row or column of which you wish to change the height or width. To change the height or width of multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.
  3. Select AutoFit Row Height or AutoFit Column Width:
Next