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 '17 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 '17 at 13:19

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, privacy policy and cookie policy

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