1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Change Column Widths in Excel

By

5 of 5

Change All Column Widths in a Worksheet Using the Menus
Change Column Widths in Excel

Change Column Widths in Excel

© Ted French

Change All Column Widths in a Worksheet Using the Menus

  1. Click on the Select All button at the top of the row header to highlight all columns in the current worksheet.

  2. Choose Format > Column > Width from the menus to bring up the Column width dialog box.

  3. Columns are measured in character widths. The default column width is 8.43 characters.

  4. If the Column width dialog box is empty it means that some columns in your worksheet are wider than others.

  5. To make all columns wider than the default, enter a number larger than the 8.43 and click OK.

  6. To make all columns narrower than the default, enter a number smaller than 8.43 and click OK.

©2014 About.com. All rights reserved.