5

In a Google Sheets, I have a Results main sheet, and the Details sheet.

I would like to modify the Details and see the Results changing.

Is it possible to split the view between two sheets in the same browser window?

Improve this question

2 Answers 2

Reset to default
3

Unfortunately you cannot split the view between two sheets in the same browser window.

As a workaround though, you can use INDEX and place the content of the ranges you need from Results to columns next to your content in your Details

(This is just one way. There are more depending on the situation.)

enter image description here

Improve this answer
1

In (Ubuntu) Linux using the Gnome extension Shell Tile it would be possible to show two (or more) instances of Google Sheets with the separate, individual tabs displayed in each tile to achieve this effect. As for Windows, I can't be certain.

enter image description here

This produces this effect - two separate tabs selected, same Google Sheet

enter image description here

Improve this answer
4
  • OP asks "the same browser window". Thanks
    – serge
    Nov 19, 2020 at 23:37
  • @Serge but this is still a valid solution for those who can exploit it. Moreover, it doesn't alter the structure of the main sheet or detail sheet.
    – Low Rep Mods are bad
    Nov 20, 2020 at 7:29
  • @User24610 maybe, but my idea was to let users that has the viewer shared link to the file see the both sheets at the same time...
    – serge
    Nov 20, 2020 at 9:25
  • @Serge That requirement wasn't clear in your question.
    – Low Rep Mods are bad
    Nov 20, 2020 at 10:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.