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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!