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!