View Ranges Used in a Sheet (or all sheets)

Kate F.

Hello,

 

I would like to know where I can go to make edits to some of the ranges I created.  Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page.  Please see attached screenshots.

Any help you can provide would be very much appreciated.

 

 

J. Craig Williams

I copy / paste long formulas to my editor of choice to make edits and then copy them back.

To update X-Sheet References, in a spare cell somewhere, I use something like

=COUNT({the current reference})

and then I edit that reference using the formula aide. 

Changes will be reflected for that reference everywhere on the current Sheet (name and/or range)

Craig