Setting the Standard Column Width

by Allen Wyatt
(last updated November 20, 2015)

You may have noticed that when you first open a new Excel workbook, all the columns are the same width. This width is called the standard column width, and you can easily change it by following these steps:

  1. Choose the Column option from the Format menu. This displays a submenu.
  2. Choose the Standard Width option from the submenu. This displays the Standard Width dialog box. (See Figure 1.)
  3. Figure 1. The Standard Width dialog box.

  4. Specify the width that should be used for columns in your worksheet.
  5. Click on OK.

With this done, the width of all your columns should adjust automatically. However, if you previously had explicitly set the width of any columns, those columns are not affected by changing the standard column width. Instead, they remain the width you previously specified.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2672) applies to Microsoft Excel , 8, , 10, and .

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...


Selecting Text in Linked Text Boxes

Text boxes are often used as design elements in a document layout. If you have linked text boxes, you may have noticed that ...

Discover More

Random Width and Height Changes

Have you ever been using a workbook, only to open it one day and find that Excel has changed the height of your rows or the ...

Discover More

Removing Pictures for a Worksheet in VBA

Excel allows you to add pictures to your worksheet, even within a macro. However, you might have a bit harder time figuring ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!


Hiding Columns Not within a Date Range

Want to automatically hide some columns that don't meet a date criteria that you set? You can't do it automatically, but you ...

Discover More

Countering Compressed Columns

If you open a workbook and find that the width of some of your columns has been changed, the discovery can be frustrating. ...

Discover More

Unhiding a Single Column

In a worksheet with lots of hidden columns it is a real pain to try to unhide just one or two columns. The best solution is ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)