Are you always having to resize your columns in Excel 2007? 

Wouldn’t it be great if you could reset the default column width so whenever you open a spreadsheet you didn’t have to resize those columns once you start filling them with data!

It is very simple to do…

1) In Excel 2007, on the “Home” tab look for the “Cells” group

2) Click on the “Format” button”

3) On the menu that appears Click on “Default Width…” (about the fifth one down)

4) Type in your preferred default column width and click “OK”

So there you have it – no more unnecessary column dragging!

‘till next time!
TNP

Related posts:

1. Insert a column in Excel 2007
2. Save as .doc as default in Word 2007
3. Set the default font in Outlook 2007
4. Number Formatting in Excel 2007
5. Make working in Excel 2007 easier on your eyes! Zoom to Selection