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.

Do any of the following:

Change the width of columns

  1. Click and drag across the column headings for the columns that you want to change.

    Column headings and separators

    Column separator

    Column headings

    Note: If you have to change the width of only one column, you don't have to select it first.

  2. Point to the separator on the right side of any selected column heading.

    The pointer becomes a Solid vertical split arrow.

  3. Do one of the following:

To

Do this

Change the column width to fit the contents

Double-click the separator.

Change the column width to any size

Drag the separator until the column is the width that you want.

Tip: To set an exact width measurement, on the Format menu, point to Column, and then click Width.

Change the width of all columns on a sheet

  1. Select all cells on the sheet by clicking the Select All triangle at the upper-left corner of the sheet grid.

    Select all cells icon

    Triangle

  2. Point to the separator on the right side of any selected column heading.

    The pointer becomes a Solid vertical split arrow.

  3. Do one of the following:

To

Do this

Change the column width to fit the contents

Double-click the separator.

Change the column width to any size

Drag the separator until the column is the width that you want.

Copy a column width to other columns

  1. Select any cell in the column that has the width that you want to copy.

  2. In the Standard toolbar, click Copy  Copy button.

  3. Select any cell in the column where you want to copy the width.

  4. On the Edit menu, click Paste Special, select Column Widths, and then click OK.

Change the height of rows

  1. Click and drag across the row headings for the rows that you want to change.

    Row headings and separators

    Row separator

    Row headings

    Note: If you have to change the height of only one row, you don't need to select it first.

  2. Point to the separator underneath any selected row heading.

    The pointer becomes a Solid horizontal split arrow.

  3. Do one of the following:

To

Do this

Change the row height to fit the contents

Double-click the separator.

Change the row height to any size

Drag the separator until the row is the height that you want.

Tip: To set an exact height measurement, on the Format menu, point to Row, and then click Height.

Change the height of all rows on a sheet

  1. Select all cells on the sheet by clicking the Select All triangle at the upper-left corner of the sheet grid.

    Select all cells icon

    Triangle

  2. Point to the separator underneath any selected row heading.

    The pointer becomes a Solid horizontal split arrow.

  3. Do one of the following:

To

Do this

Change the row height to fit the contents

Double-click the separator.

Change the row height to any size

Drag the separator until the row is the height that you want.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Hide or show rows or 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!

×