Related topics
×
Rows & columns
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Rows & columns

Change the column width and row height

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

Try it!

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.

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 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.

Want more?

Resize a table by adding rows and columns

Insert or delete cells, rows, and columns

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×