While working with a huge dataset, users might often tend to view and edit data from multiple sheets in the same spreadsheet. However, this option isn’t available in Google Sheets like we have in Excel Sheets. Also if you Freeze the Sheet and start entering the data from tabs of the same spreadsheet, the Freeze option doesn’t come in handy and starts hovering here and there. To overcome this issue, we should open the tabs in the Google Spreadsheet in New Window. Let us learn how to do this with the help of Google Sheets Tips provided on this page.
Table of Contents
Google Sheets View Two Tabs At Once
Let us consider the following dataset. Here we want to enter the data from Sheet 2 to Sheet 1. For this, we want to view two tabs at once. The steps to open the Google Sheets tab in the new window are listed below:
- Step 1: Open the Google Spreadsheet which has multiple tabs.
- Step 2: Now open sheet 1 where you want to enter the data from other sheets in the same spreadsheet.
- Step 3: Then move to the other tab of the spreadsheet from which you want to copy the data.
- Step 4: In the Second Sheet tab, copy the Google Sheets URL from the address bar using the keyboard shortcut “CTRL+C”.
- Step 5: Now open the new window in your browser. Since in this example, we are using Chrome, the steps to open a new window are as follows.
- Step 5.1: Open Google Chrome.
- Step 5.2: In the Chrome browser, click on the “+” tab. Now a new window will open on the screen.
- Step 6: Now paste the copied URL in the address bar.
- Step 7: The Google Sheet tab from which you want to copy the data is now open on the screen. Start copy pasting the data from Google Sheet 2 to Sheet 1 as you require.
Important Points to Note:
- Here, whenever you click on the specific tab in the Google Spreadsheet, the URL in the address bar will change. For example, when you click on Sheet 1, the URL in the address bar is different from Sheet 2.
- Simply repeat the process if you want more windows. The Windows key may be used to reorganize the windows. Keep the Windows key pressed and press the left arrow to fill the left half of the screen, then the right arrow to fill the right half. You may also use your mouse to resize the windows in the typical method. You may distribute these windows across multiple monitors if you have more than one.
- Auto Suggested Pivot Chart in Google Sheets: Parameters for Creating Pivot Table Using Explore
- How to Make Tables in Google Sheets? Using Google Sheets Formatting Options
- Named Versions in Google Sheets: How to Name Version History in Google Sheets
Split View in Google Sheets
If you are in a situation where you want to copy the data from the same tab and edit the same tab, then you can simply follow the steps outlined below:
- Step 1: Open the Google Spreadsheet.
- Step 2: Now right click on the spreadsheet from which you want to copy the data.
- Step 3: Choose “Duplicate” from the options listed. This will duplicate the sheet and from the address bar you can copy the URL of the duplicated sheet
- Step 4: Paste the duplicate copied URL and paste it into the address bar and now you can start using duplicated sheet data to edit the current sheet data.