2 reasons to format cells before you enter data in Excel

Stop! Think! Consider! Develop a plan!

Before you enter any data in your spreadsheets.

Ask yourself questions about your data.  Why?

  1. To save yourself time
  2. To maintain consistency in data entries
  3. To prevent GIGO  (Garbage in equals Garbage out)
50 Best Tips for Excel 2007

Excel Tips

In this video lesson I demonstrate the advantages you will obtain when you:

  1. Stop – before you start to enter data
  2. Pre-plan your data list
  3. Format your data fields / columns BEFORE you make your 1st entry

Here are the steps to follow in this video lesson:

  1. Set up and Format your Column / Field Headers for each data field.
  2. For each Column / Field Header, select the columns and format the cells (Ctrl+1) BEFORE you enter any data.
  3. On the NUMBER tab, choose “Special” to select formats for Social Security #, Phone #, and Zip Code

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Find the Free Excel Training Video that you want – Click here to go to my Index of Excel Video Lessons

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Hello, I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have enjoyed reading. Nice blog. I will keep visiting your site often.That is some inspirational stuff. Never knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here.


  1. […] Format cells before entering data in your worksheet Share and Enjoy: […]

  2. […] you have control over your data, pre-format your Zip Codes column using the “Formant Cells, Number, Special, Zip Code” […]

  3. […] 2 Reasons to Format Cells Before You Enter Data in Excel […]

  4. Websites worth visiting…

    […]here are some links to sites that we link to because we think they are worth visiting[…]……

Speak Your Mind