Home » Questions » Computers [ Ask a new question ]

How to open google spreadsheet's extra sheets in new window or tab?

How to open google spreadsheet's extra sheets in new window or tab?

How to open google spreadsheet tab in new window or tab?

Asked by: Guest | Views: 147
Total answers/comments: 2
bert [Entry]

"You can open the document twice and have the first tab set on the first sheet and the second tab set on the second sheet. All you have to do is go back to the Google Docs file browser and click to open the file again.

I have tested that:

If you edit the second sheet in the
second tab, then open the second
sheet in the first tab, it will have
all your updates.
If you have a cell
in the second sheet that looks up
data on the first sheet (eg. =Sheet1!A1), if you edit
the first sheet in the first tab, the
second sheet will pick up your
change."
bert [Entry]

"A middle-click will open the spreadsheet from the google-doc file browser. (You can select what happens from a normal click via settings, either current window or new).

This does not however work once the spreadsheet is open, this has to do with the interface Google uses for the actual spreadsheet. Right now best as I can tell there is no way to do this.

A very clunky workaround is to open two copies of the spreadsheet via middle click (or left click if you have it set as such) and have each tab on a separate worksheet.

Perhaps if you already have the spreadsheet open you can drag its URL into the tab area (to open a duplicate) and then quickly navigate to other worksheet."