I would like to know if it is possible to just click one cell and then different cells be automatically highlighted. For example, when I click B3 cell I would like to highlight cells: G3, L3, Q3, V3, AA3:


It doesn't need to change colour or anything, I just want to "see" them more easily.

  • any idea how in different way make it looks good ?
    – Bart
    Dec 6, 2017 at 11:48
  • 1
    super! it is not what I was looking for but it will do the job! Many thanks pnuts!
    – Bart
    Dec 6, 2017 at 13:19

1 Answer 1


A hack (seemingly adequate according to OP) but options are limited. Put:


in a cell somewhere and double-click on that to pick out the locations of the components of the formula.

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.