Change column width and row height

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

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.). If the column width is set to 0, 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). If the row height is set to 0, the row is hidden.

What do you want to do?

Change the column width

Set a column to a specific width

Change the column width to fit the contents

Match the column width to another column

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

Change the width of columns by using the mouse

Change the row height

Set a row to a specific height

Change the row height to fit the contents

Change the height of rows by using the mouse

Set a column to a specific width

  1. Select the column or columns that you want to change.
  2. On the Format menu, point to Column, click Width, and then type a value.

Top of Page Top of Page

Change the column width to fit the contents

  1. Select the column or columns that you want to change.
  2. Point to Column on the Format menu, and then click AutoFit Selection.

Tip    To autofit all columns on the worksheet, click the Select All button and then double-click any boundary between two column headings. Or select all columns, point to Column on the Format menu, and then click AutoFit Selection.

Select All button

Top of Page Top of Page

Match the column width to another column

  1. Select a cell in the column.
  2. Click Copy Button image on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), and then select the target column.
  3. On the Edit menu, click Paste Special, and then select Column widths.

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:

Sheet tabs with Sheet2 selected

  1. On the Format menu, point to Column, and then click Standard Width.
  2. In the Standard column width box, type a new measurement.

Tip    To define the default column width for all new workbooks and worksheets, create a workbook template and a worksheet template, and then base new workbooks and worksheets on those templates. For more information, see Create a template.

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. Point to Row on the Format menu, click Height, and then enter a value.

Change the row height to fit the contents

  1. Select the row or rows that you want to change.
  2. Point to Row on the Format menu, and then click AutoFit.

Tip    To autofit all rows on the worksheet, click the Select All button and then double-click the boundary below one of the row headings. Or select all rows, point to Row on the Format menu, and then click AutoFit.

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 2003