If I double click on a formula with a cell range, Google Sheets will outline the target area:

enter image description here

Is there a way to get similar highlighting at all times, updated as the range or ranges in the formulas are updated?

1 Answer 1


If I read your question correctly, you are looking for a hover "effect".
If that is the case, you can not.
(Try visualizing what it would look like -in a common scenario- moving your cursor around a sheet with many long formulas, in close range with inter-lapping ranges and cells like one with 249 ones)

You could send a feature request to Google.
Go to the top menu, Help >> Report a problem and fill out the pop-up form

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.