February 21, 2011

new tab in Google Spreadsheet

Posted in office tagged , at 7:23 am by weiszguy

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?

Bingo.

Here’s the text of the URL from my bookmark:

https://spreadsheets.google.com/ccc?key=0AujXCaDA7ic1ctobe0oxN2N3OU5tSWZjc25rbUprSEE&hl=en#gid=5

and here’s the text of the URL from my docs list:

https://spreadsheets.google.com/ccc?key=0AujXCaDA7ic1ctobe0oxN2N3OU5tSWZjc25rbUprSEE&hl=en#gid=6

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.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: