Monthly Archives: February 2015

Compare two documents for changes – Word and maybe Excel

If you use Word, I believe there is high chance that you send out a document to someone for comment, and you expect the receiver would know how to use  Track Changes in Word, which is a great function to … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 3 Comments

Mouse Tip – Move cell with Shift Key

If you have read my post about Move Cells with Right Click, you should know it is possible. However for continuous improvement, we often look for faster way to achieve the same thing.  With a simple trick, you may move cells … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

Pay attention when you concatenate – A1 & B1 vs. A1 & “|” & B1

In many case, we may want to combine texts from different cells.  This can be done by either CONCATENATE function or simply an Ampersand &.  E.g. A1 & B1 & C1 …… We may take it for granted as it looks so … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

Ctrl+Enter won’t let you down!

As you may be aware of, Ctrl+Enter enables you to input the same thing (be it text, value or formula) in multiple cells simultaneously.  See screenshot below for example: It is quite handy and I use this trick a lot in … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 9 Comments