98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Change the Default Width of All Columns in Excel 2010

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

Added by Yolande on 27th September 2011

More Excel hints and tips, like:

• Quickly create a list of numbers
• Converting an American date format to European using Formula
• Viewing two Excel 2010 Workbooks at the same time