Change the column width and row height

On a worksheet, you can specify a column width of 0 (zero) to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.). The default column width is 8.43 characters. If you set a column width to 0 (zero), the column is hidden.

You can specify a row height of 0 (zero) to 409. This value represents the height measurement in points (1 point equals approximately 1/72 inch or 0.035 cm). The default row height is 12.75 points (approximately 1/6 inch or 0.4 cm). If your set a row height to 0 (zero), the row is hidden.

If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches. In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters (On the File tab, click Options, click the Advanced category, and under Display, select an option from the Ruler Units list).

What do you want to do?


Set a column to a specific width

  1. Select the column or columns that you want to change.
  2. On the Home tab, in the Cells group, click Format.

On the Home tab, click Format

  1. Under Cell Size, click Column Width.
  2. In the Column width box, type the value that you want.
  3. Click OK.

 Tip    To quickly set the width of a single column, right-click the selected column, click Column Width, and then type the value that you want.

Top of Page Top of Page

Change the column width to automatically fit the contents (auto fit)

  1. Select the column or columns that you want to change.
  2. On the Home tab, in the Cells group, click Format.

On the Home tab, click Format

  1. Under Cell Size, click AutoFit Column Width.

 Note    To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

Select All button

Top of Page Top of Page

Match the column width to another column

  1. Select a cell in the column that has the width that you want to use.
  2. Press Ctrl+C, or on the Home tab, in the Clipboard group, click Copy.

On the Home tab, click Copy

  1. Right-click a cell in the target column, point to Paste Special, and then click the Keep Source Columns Widths Button image button

Top of Page Top of Page

Change the default width for all columns on a worksheet or workbook

The value for the default column width indicates the average number of characters of the standard font that fit in a cell. You can specify a different number for the default column width for a worksheet or workbook.

  1. Do one of the following:

Click the Sheet tab

  1. On the Home tab, in the Cells group, click Format.

On the Home tab, click Format

  1. Under Cell Size, click Default Width.
  2. In the Standard column width box, type a new measurement, then click OK.

 Tip    If you want to define the default column width for all new workbooks and worksheets, you can create a workbook template or a worksheet template, and then base new workbooks or worksheets on those templates.

Top of Page Top of Page

Change the width of columns by using the mouse

Do one of the following:

  • To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want.

Column boundary being dragged

  • To change the width of multiple columns, select the columns that you want to change, and then drag a boundary to the right of a selected column heading.
  • To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.
  • To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.

Select All button

Top of Page Top of Page

Set a row to a specific height

  1. Select the row or rows that you want to change.
  2. On the Home tab, in the Cells group, click Format.

On the Home tab, click Format

  1. Under Cell Size, click Row Height.
  2. In the Row height box, type the value that you want.

Top of Page Top of Page

Change the row height to fit the contents

  1. Select the row or rows that you want to change.
  2. On the Home tab, in the Cells group, click Format.

On the Home tab, click Format

  1. Under Cell Size, click AutoFit Row Height.

 Tip    To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings.

Select All button

Top of Page Top of Page

Change the height of rows by using the mouse

Do one of the following:

  • To change the row height of one row, drag the boundary below the row heading until the row is the height that you want.

Row boundary being dragged

  • To change the row height of multiple rows, select the rows that you want to change, and then drag the boundary below one of the selected row headings.
  • To change the row height for all rows on the worksheet, click the Select All button, and then drag the boundary below any row heading.

Select All button

  • To change the row height to fit the contents, double-click the boundary below the row heading.

Top of Page Top of Page

 
 
Applies to:
Excel 2013