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 ?