Tag Archives: Ctrl Enter

Replace blanks with zero in #Excel

Posted on May 2, 2020 by

Following the techniques used in the previous post , we can perform many Excel magics for different scenarios.  On top of my mind is to replace blank cells with zero.   The first task is to select all blank cells in … Continue reading →

Rate this:

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

Unstack data across columns with #Excel Pivot Table

Posted on May 29, 2019 by

Another commonly seen problem in daily work.  Many hours are spent on reshaping data, we all know that.  Nevertheless, if you are good in Excel, doing this task is not difficult at all.   Indeed, there are many ways to solve … Continue reading →

Rate this:

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

Ctrl+Enter won’t let you down!

Posted on February 7, 2015 by

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