Help, tips, tricks and tutorials for Microsoft Office 2007 - The New Paperclip
24th May
2009
written by The New Paperclip




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 ;)

Share and Enjoy:
  • del.icio.us
  • E-mail this story to a friend!
  • StumbleUpon

Related posts:

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

Leave a Reply

Join the Office 2007 Tips and Tricks Newsletter Name:Email:
-->