Admit it, we’ve all been there. Getting frustrated trying to find a specific sheet inside a huge workbook, and not being able to see it amongst all the other sheets.
Well, here’s a quick Apps Script to create a hyperlinked index page at the start of your workbook.
Quick caveat first: There’s one drawback – the hyperlinks open the sheets in new tabs, which unfortunately I can’t do anything about. However, it should still be useful for anyone working with workbooks with 10+ sheets.
Here it is in action:
What if we already have a sheet by the name ‘Index’?
Well, you’ll be prompted to enter a different index name or to cancel the operation:
Steps to create your own hyperlinked index sheet in Google Sheets
Step 1: Open up the workbook you want to add the index sheet to and open the apps script editor (
Tools > Script editor...).
Continue reading How to add a hyperlinked index sheet to your large Google Sheet workbooks
Want tons of great Google Sheets, Apps Script and Data Studio resources in one place?
Then you’ll love this list.
These are my go-to resources when I’m building spreadsheet applications for clients or developing content for this blog. I have hundreds of bookmarks on the subject but here I’ve whittled it down to just the very best.
Feel free to suggest any other resources in the comments below!
Google Sheet Resources
Google Help Resources
Starting this list off is the official Google Sheets documentation. This guide covers everything about sheets, including all 346 formulas.
Google spreadsheets function list – all 346 of them! A good place to start when you want to find out the syntax details or how formula X works.
The Google Docs blog – the official source for product announcements, updates and tips from Google.
Forums and communities
Aka, good places to ask questions!
Google Sheets Help Forum. The place to go to get your Google Sheet questions answered. Read this getting started guide if you’re new to it. There are also forums for the other Google Docs.
Continue reading Google Sheets, Apps Script and Data Studio Resources: The Ultimate List for 2019
Happy New Year to you all!
If 2015 was a year of huge change, then 2016 was more incremental, building on the foundations of 2015. I still tried lots of different things – different gigs, different projects, different tools – but I’ve found creating apps and solving data problems on the Google platform is my sweet spot of skills, experience and enjoyment.
On this site
Investing so much time and effort into this site really started to pay off over the course of 2016.
Over 2,500 of you have subscribed to my email list and enjoyed a free copy of my ebook: Spice Up Your Sheet Life.
Midway through the year, I passed 100k pageviews, then 150k pageviews and am now close to 200k.
Several posts have garnered some really great commentary from readers, adding tons of value to the original post. This one in particular has 112 comments and counting!
Continue reading 2016 in review and a look forward to 2017