Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. Choose the column(s) to change, go to the Home tab and select  Excel Format Button icon Format in the Cells group.

  2. Under Cell Size:

    1. For fixed width, choose  Column width button Column Width, enter a value, and select OK.

    2. To automatically set width, select AutoFit column width.

Tip: To quickly change one column's width, point your mouse at the right boundary of the column heading. When the pointer changes to Column width mouse pointer, click and drag to the width you want.

Need more help?

Want more options?

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