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
Help, Tips, Tricks, and Tutorials for Word, Excel, Outlook, Office 365 and more
Copyright 2006-2013 Paul Woods. All rights reserved. Proudly powered by WordPress. TheNewPaperclip.com V3 theme based on Fresh Editorial by BrightCherry.
Office 2007 and Office 2010 Help, Tips and Tutorials hosted by Dreamhost.For more web, email, collaboration, CRM, contact center and voice hosting options - visit www.hostedoptions.com