Use Mouse to Edit Formula Ranges [quick tip]

Nice one. I had no idea this could work. :-O Thanks for tip.

What?

Why did no-one tell me this before?!

Nice tip

Is there a way to do this when the ranges are on different sheets?

Chandoo,

nice tip (as always). I am using this all day long.

A short amendment: the technique works with the data source of a chart as well. Instead of F2, simply click on the data series of the chart and you will see the colored border around the data source cell range (as long as chart and data source are on the same worksheet).

A time-saving feature if you have to create a lot of charts (same format, different data sources): Create one chart, format and resize it the way you need it, copy and paste the chart and simply change the data source of the new chart by dragging the colored border to the desired cell range.

thank nice method.
in 4 you can click other cell replce press Enter when done.

I feel identified with Robert; the best use I give to this feature is to change data source in charts.
Other way to use it is when you insert rows above a SUM formula and need to expand the sum range.

A final note: be aware that this method does not work with named ranges

Thank You so much for all your hard work gathering & documenting this wealth of information.
Most of all THANK YOU for sharing.
These busy days don’t allow much time to study.
Over time You have been there & answered questions & taught me a great amount of understanding.
You are a respectable value!
All the best,
Charly