Resizing Rows and Columns

Rows and Columns default width

The table below shows the minimum, maximum and default sizes for each based on a point scale.

Change the default width for all Columns

You can specify a different number for the default column width for a worksheet or entire workbook.

1. Do one of the following:
   • To change the default column width for a worksheet, click its sheet tab.
   • To change the default column width for the entire workbook, right-click a sheet tab, and then click Select All Sheets.
     
2. Click Home tab > Cells group > Format > Cell Size > Default Width.
   
3. In the Standard column width box, type the value that you want.
   
4. Click OK.

Set a column to a specific width

1. Select the column or columns that you want to change.
2. Click Home tab > Cells group > Format > Cell Size > Column Width.
   
3. In the Column Width box, type the value that you want.
   
4. Click OK.

AutoFit Column Width

You can change the column width to automatically fit the contents.

1. Select the column or columns that you want to change.
2. Click Home tab > Cells group > Format > Cell Size > AutoFit Column Width.
   

Copy 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 click Home tab > Clipboard group > Copy.
3. Select a cell in the target column.
4. Do one of the following:
   • To copy all (format, formula...) and column widths: Click Home tab > Clipboard group > Paste > Paste > Keep Source Columns Widths.
     
   • To copy only column widths: Right-click a cell in the target column, point to Paste Special, and then click Paste Special, in the Paste Special box, select Column widths, and then click OK. To quickly open Paste Special box, you can press shortcut: Ctrl+Alt+V
     

Change the width of columns by using the mouse

Quickly change the width of one column

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.

Quickly change the width of multiple columns

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.

For example:

To increase the widths of columns A to C

1. Move your mouse pointer over the letter A until you see a downward pointing arrow.
2. Click on A to select the column and drag to column C to select columns A to C.
   Tip

   Another way to select a range of columns is to select the first column, hold down the Shift key, and select the last column.

3. Click on the right edge of the column C letter and drag it to the right to widen the column.

Quickly change the width of columns to fit the contents

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.

Quickly autofit all columns on a worksheet

To change the width of all columns on the worksheet:

1. Click the Select All button.
   
2. Then double-click any boundary between two column headings.
   

Set a row to a specific height

1. Select the row or rows that you want to change.
2. Click Home tab > Cells group > Format > Cell Size > Row Height.
   
3. In the Row height box, type the value that you want.
   
4. Click OK.

AutoFit Row Height

You can change the row height to automatically fit the contents.

1. Select the row or rows that you want to change.
2. Click Home tab > Cells group > Format > Cell Size > AutoFit Row Height.
   

Change the height of rows by using the mouse

Quickly change the height of one row

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

Quickly change the height of multiple rows

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.

Quickly change the height of rows to fit the contents

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.

Quickly autofit all rows on a worksheet

To change the height of all rows on the worksheet:

1. Click the Select All button.
   
2. Then double-click any boundary between two row headings.
   

This will adjust each column to fit the height of all entries. This is useful if you have Wrap text enabled and some cells have more than one line of text.