View Ranges Used in a Sheet (or all sheets)
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.
Comments
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!