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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!