everydayExcel Newsletter Header

One in 10 Excel users has this Excel “Bad Habit”

You probably do not notice how you enter data into Excel so long as the number or text appears in the cell you want. But the way you enter data into the cell will determine whether you have to spend hours or just in a few minutes in data cleanup. To test whether you have that “bad habit”, take this test:

  1. Create a new workbook.
  2. Select a range of cells, e.g. B2:B6
  3. Type the letters “abc”.
  4. Press and hold the CTRL key and hit the ENTER key at the same time.

You should see the letters “abc” in the range “B2:B6”.

If you have the bad habit, you will only see B2 contains the letters “abc”.

So what is the “bad habit”?

The “bad habit” is to double click on the cell before typing the letter “abc”. If you double click on the cell, the selected range B2:B6 would have disappeared. Thus, only B2 will have the letter abc.

Next issue: The second bad habit….


Ask us an Excel question and get your question answered by our team of Excel experts

Click on this link to post your question.


Upcoming Courses

With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.

Year 2014
Hidden Secrets in Data Analysis with Excel 2007/2010 - 13 & 14 Nov 2014 (Limited Seats)

Gaining Stunning Business Insights with Excel Power Pivot - 10 & 11 Nov 2014 (confirmed)


Year 2015
Hidden Secrets in Data Analysis with Excel 2007/2010 - 29 & 30 Jan 2015 (confirmed)

The Hidden Key to Excel Reporting and Charting - 19 & 20 Mar 2015 (confirmed)

Unleash the Power of Excel Power Pivot for Data Insights - 22 & 23 Jan 2015 (confirmed)

Learning the Magic of Macros 2007 (Excel VBA) - 5 & 6 Mar 2015 (confirmed)

Breakthrough Performance for HR in Excel 2007/2010 - 12 & 13 Mar 2015 (confirmed)

Dynamic Real-Time Forecasting with Excel 2007/2010 - 23 & 24 Mar 2015 (confirmed)


For the details of the courses, please refer to our Excel courses page.


Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.


Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.


Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"

 

Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.