Ways to change column widths and row heights in Excel 2007 tables

In an Excel worksheet, you can specify a column width of 0 (0) to 255. This value represents the default text font that can be used in a standard font, standard font: a worksheet. The standard font determines the default font for the General cell style. The number of characters that are displayed in the formatted cell. The default column width is 8.43 characters. If the column width is set to 0, it is hidden.

You can specify a row height of 0 (0) to 409. This value represents the height measurement in points (1 dots equals 1/72 inches). The default row height is 12.75 points. If the row height is set to 0, the row is hidden.

Set a column to a specific width

1, select the column you want to change.

2, on the Start tab, in the Cells group, click Format.

3, under Cell Size, click Column width.

4, in the Column width box, type the value you want.

Change column widths to fit content

1, select the column you want to change.

2, on the Start tab, in the Cells group, click Format.

3, under Cell size, click AutoFit Column width.

Tip To quickly automatically adjust all columns on a worksheet, click the Select All button, and then double-click any boundary between the two column headings.

Match column widths to another row

1, select a cell in the column.

2, on the Start tab, in the Clipboard group, click Copy, and then select the destination column.

3, on the Start tab, in the Clipboard group, click the arrow next to Paste, and then click Paste Selective.

4, under "Paste", select "Column width".

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

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

1. Do one of the following:

• To change the default column width of a worksheet, click its sheet tab.

• To change the default column width for the entire workbook, right-click the sheet tab, and then click the shortcut menu shortcut menu: A menu that shows a list of commands related to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10. , select all sheets.

2, on the Start tab, in the Cells group, click Format.

3. Under Cell size, click Default width.

4, in the Default column width box, type a new measure.

Tip If you want to define default column widths for all new workbooks and worksheets, you can create a workbook template or a worksheet template, and then create a new workbook or worksheet based on those templates. For more information, see Creating Templates.

Change column widths using the mouse

Do one of the following:

• To change the width of a column, drag the right edge of the column heading until the desired column width is reached.

• To change the width of multiple columns, select the columns you want to change, and then drag the right border of the selected column headings.

• To change the column width to fit the content, select the columns you want to change, and then double-click the right border of the selected column headings.

• To change the width of all columns in a worksheet, click the Select All button, and then drag the bounds of any column heading.

Sets the row to the specified height

1, select the row you want to change.

2, on the Start tab, in the Cells group, click Format.

3, under Cell size, click Row height.

4, in the Row Height box, type the value you want.

Change row height to fit content

1, select the row you want to change.

2, on the Start tab, in the Cells group, click Format.

3, under Cell size, click Auto Adjust row height.

Tip To quickly automatically adjust all the rows in a worksheet, click the Select All button, and then double-click the boundary below one of the row headings.

Use mouse to change row heights

Do one of the following:

• To change the row height of a row, drag the boundary below the row heading until the desired row height is reached.

• To change the row height for multiple rows, select the row you want to change, and then drag the boundary below one of the selected row headings.

• To change the row height of all rows in a worksheet, click the Select All button, and then drag the boundary below any row heading.

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