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:
Figure 1. The Standard Width dialog box.
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 .
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!
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
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
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."