What is a Google Sheet page index and how do I use it effectively? or Can someone explain what is a G

14 Replies, 1448 Views

what is a google sheet page index? It’s like a cheat code for huge spreadsheets!

Here’s how I do it:
1. Make a new sheet called "INDEX"
2. List all sheet names
3. Use =HYPERLINK("#gid="&SHEETID(), A1) to auto-link them (Google SHEETID() script needed tho).

Bit advanced but SO worth it. Script help here: [LINK].

Messages In This Thread



Users browsing this thread: 1 Guest(s)