Hello, I remember I had done this successfully some years ago but I can’t remember how I set it up:
On a giant sheet which contained many charts, I set it up so that there was a sort of “table of contents” (manually set up) at the very top left, so when you opened that sheet you would see cells which you could click to view all the charts in that sheet.
For example, cell C5 might contain text reading “click here to view chart ABC.” When you click C5, your view would jump so that cell AA576 was in your top left corner, and you were looking at chart ABC. Then cell AB577 would have text saying “click here to go back to the table of contents” and you would click it and your page view would jump to A1 in the top left.
It was very handy for navigating large sheets and made the file much more user friendly than using vast amounts of scrolling or switching between vast numbers of sheets. I don’t remember what option I used to make this type of link. Can anyone help with this?