A Google sheet page index is basically a way to organize your spreadsheet so you can jump between sheets super fast.
To make one, just create a new sheet and list all your sheet names as hyperlinks. Use =HYPERLINK() function like this:
=HYPERLINK("#gid=123456789", "Sheet1")
Pro tip: Name this sheet "Index" so it’s easy to find. Saves tons of time if your workbook has like 10+ sheets!
I use it all the time—totally worth the 2 mins it takes to set up.
To make one, just create a new sheet and list all your sheet names as hyperlinks. Use =HYPERLINK() function like this:
=HYPERLINK("#gid=123456789", "Sheet1")
Pro tip: Name this sheet "Index" so it’s easy to find. Saves tons of time if your workbook has like 10+ sheets!
I use it all the time—totally worth the 2 mins it takes to set up.