Use Mouse to Edit Formula Ranges [quick tip]
Here is an interesting way to edit formula ranges. This time using mouse.
1. Select the formula for which you want to edit the range.
2. Press F2.
3. Now you see borders around all the ranges for that formula. Just select one of the ranges by clicking on its border and start dragging / resizing it.
4. When you are done, press Enter.
5. That simple.
It seems like a fun way to edit formulas.What do you think ?
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
|« Bonavista Chart Tamer Kicks ass.||Most Popular Posts in PHD – The March and April edition »|