Use CTRL+Click to speed up your formula entry [Quick Tips]
Sometimes we think there is very little we can improve in something and then we come across an idea that would change our perceptions. I have been writing excel formulas for such a long time that it was easier to remember when I first shaved than when I first wrote a formula. (may be, because of the razor-blade-thin-chin-trembling-hands experience)
Today I want to present a very interesting functionality in Excel that would save a lot of time when you are entering formulas in spreadsheets.
If we have 5 cells and we want to CONCATENATE all the text in them to one cell, we would usually write =CONCATENATE( and then start typing addresses of each cell one by one. But there is a faster and simpler way to do this. You can just hold the CTRL key down and select all the five cells one after another and excel will neatly type the references for you and include a comma to separate them. See this:
You can also use the same technique for speeding up formula entry for other multi-argument formulas like VLOOKUP, MATCH etc. Just select the cells corresponding to each parameter in that order while holding the CTRL key down.
Read more quick tips and save a ton of time and impress everyone.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Automatic Rolling Months in Excel [Formulas]||Make your Chart Legends Legendary »|