Monthly Archives: June 2015

How unorganized data could drive you crazy!

Posted on June 27, 2015 by

This is about how to clean up data for a simple VLOOKUP task.  To be more specific, how to separate data delimited by line break in a cell, as you see in the following screen shot. The one who input … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Interesting Magnifier in Windows 7

Posted on June 19, 2015 by

This is not an Excel tip… One day I intended to press Alt+= (which is the shortcut for Auto Sum), but I wrongly press Windows+=, and something interesting pop up… Instead of an auto sum formula I expected, I saw a … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Hidden Rows vs. Filtered Rows

Posted on June 13, 2015 by

One day, a friend asked me: “If she deletes contents from a filtered range, would she also delete the hidden content?”  I answered: “Try and observe!” 😛 I know that is not the answer she expected.  Nevertheless, I believe that … Continue reading →

Rate this:

Posted in Excel Basic | Tagged , | Leave a comment

When you forget to hold Ctrl key for inputting same value to a range…

Posted on June 6, 2015 by

… Ctrl+D or Ctrl+R is ready to help 🙂 Ctrl+Enter is one of my favorite shortcuts.  It helps me to input a value or a formula to a range simultaneously.  As usual, Ctrl+Enter won’t let me down.  But many times, … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment