February 21, 2011
new tab in Google Spreadsheet
I have a couple Google Spreadsheets that I use to track annual items. Every year, I add a new tab, and I keep the old tabs around for reference.
I have these spreadsheets bookmarked in my browser so I can get to them quickly without going through the docs list on Google Docs. The bookmarks are great, but after I added a new tab for 2011, the spreadsheet would still open in the old 2010 tab.
I discovered that the spreadsheet would open on the old tab if I used the bookmark, but it would open on the new tab if I used the docs list. The difference had to be the text of the URL, right?
Here’s the text of the URL from my bookmark:
and here’s the text of the URL from my docs list:
The ‘gid’ number at the end of the URL is a tab number. In this case, the spreadsheet will open on tab number 6, instead of tab number 5. I can open any tab in the spreadsheet just by changing that last digit.
If you’re having a similar problem, the solution is to delete your bookmark, open the spreadsheet from the docs list, then add a new bookmark.