Cells

Resize a table, column, or row

Resize a table, column, or row

You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.

Note: The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Resize rows

  1. Select a row or a range of rows.

  2. Select Format > Row Width.

  3. Type the row width and select OK.

Resize columns

  1. Select a column or a range of columns.

  2. Select Format > Column Width.
    Select column

  3. Type the column width and select OK.

Automatically resize all columns and rows to fit the data

  1. Select the Select All button Select All at the top of the worksheet, to select all columns and rows.

  2. Double-click a boundary. All columns or rows resize to fit the data.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Insert or delete cells, rows, and columns

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×