Change the default width of cells in Excel

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”


‘till next time!

Leave a Reply

Your email address will not be published. Required fields are marked *