How to Split Screen in Google Sheets for Side-by-Side Views

To split a Google Sheets view, open the same spreadsheet in two browser windows, move each window to a different part of the sheet, and place the windows side by side using your computer’s window controls. Google Sheets does not have a built-in Split command for dividing one worksheet window into independently scrolling panes. If you only need column or row headings to stay visible, use View > Freeze instead.

What You’ll Need

A computer with access to Google Sheets in a web browser. The steps below are for the desktop browser version; the mobile app does not offer the same window-arranging workflow.
The spreadsheet’s web address, and permission to open it. You can use the same account and file in both windows.
A screen wide enough to show two windows comfortably. A larger monitor is helpful, but you can still arrange windows on a smaller display and scroll or zoom as needed.
On Windows, the built-in Snap keyboard shortcuts. On a Mac, use the window tiling controls available in macOS.

Step-by-Step

Open the spreadsheet in your browser. Go to sheets.google.com or open the file from Google Drive, then select the spreadsheet you want to work with. Wait for the sheet to finish loading and make sure you can see the tab and rows you need. This first window will become one side of your comparison.
Open a second window on the same file. In most desktop browsers, copy the spreadsheet’s address from the address bar. On Windows, press Ctrl + L to select the address, Ctrl + C to copy it, then Ctrl + N to open a new browser window and Ctrl + V followed by Enter to load the same file. On a Mac, use Command + L, Command + C, Command + N, and Command + V. You can also use a browser’s Duplicate Tab option, then drag the duplicated tab away from the tab bar to make it a separate window. The exact menu wording depends on the browser.
Confirm both windows show the same spreadsheet. Check the file name and, if needed, look at the address bar in each window. Opening the same file twice gives you two views of one document, not two separate copies. Changes you make in one window are saved to the spreadsheet and will appear in the other, although it may take a moment for the second view to refresh.
Choose what to show in the first window. Click the first window and navigate to the first section you want to reference. For example, leave the first window near the top of a list containing customer names and IDs. You can scroll with the mouse wheel or scrollbar, or click a cell and use the name box to go to a specific cell reference. Keep enough of the row and column labels visible to recognize the data.
Move to the other area in the second window. Click the second window and scroll to the section you want to compare, such as a totals area farther down or a different group of columns. The two windows have their own scroll positions, so moving through one should not move the other. You can also select a cell in the second view and use the name box to jump directly to a known location.
Arrange the windows side by side on Windows. Click the first browser window and press Windows key + Left Arrow to snap it to the left half of the screen. Select the second browser window when Windows displays the available windows, or click it and press Windows key + Right Arrow. If the selection prompt does not appear, snap the second window manually. You can also drag each window to the left or right edge until the snap outline appears, then release the mouse.
Arrange the windows side by side on a Mac. Move the pointer over the green window button in the top-left corner of a browser window. Choose Tile Window to Left of Screen or the corresponding right-side option, then select the other browser window for the opposite half. The wording and available tiling choices can vary by macOS version. If the tiling option is not available, resize and drag the windows manually, or use the Mac’s window management controls.
Adjust the view so both sections are readable. Make each window wide enough to show the columns you need. Use the sheet’s zoom control if a little more content must fit, but avoid zooming out so far that labels become difficult to read. You can resize the divider between snapped windows by dragging it, where the operating system allows that, and adjust browser zoom separately in each window.
Keep the two views useful while you work. Click the window you need to edit, then click the relevant cell. Both windows are connected to the same file, so use the file’s tabs and cell coordinates to avoid making changes in the wrong place. If you are comparing data, double-check that both views are on the intended sheet tab and that you have not accidentally opened a different spreadsheet with a similar name.

This setup is especially useful for comparing a source list with a summary, checking a calculation against its inputs, or referring to instructions while entering data. It is a visual workaround rather than a true split-pane feature: each window shows the whole spreadsheet, but at a different scroll position.

Common Mistakes

Looking for a Split option in Sheets. Google Sheets does not provide an Excel-style View > Split command for creating two independently scrollable panes inside one window. Opening a second window is the practical way to keep two distant areas visible at once.
Duplicating the file instead of the view. If you choose Make a copy in Google Drive, you create a separate spreadsheet. That copy will not update when the original changes. Open the same file address in the second window instead.
Assuming Freeze creates a second scrolling section. Freezing keeps selected top rows or left columns in place while the rest of that window scrolls. It does not give you two separately scrolling worksheet areas.
Editing without checking which window is active. Since both windows show the same document, a click in the wrong window can take you away from the area you meant to keep on screen. Before typing, check the selected cell and sheet tab.
Expecting the two views to stay on different tabs automatically. Each window can display a different sheet tab, but changing a tab or scrolling in one view can be confusing if you are not watching the active window. Label the relevant tabs clearly, or note the tab name and cell range you want to compare.

Tips

Freeze headings in one or both windows. In the window where you need persistent labels, choose View > Freeze > 1 row to keep the first row visible, or choose View > Freeze > 1 column to keep the first column visible. The menu also offers choices for freezing more rows or columns, including options up to a selected row or column. Freezing can make a side-by-side comparison easier, but it does not change the other window’s scroll position.
Use a clear reference point. Note the sheet tab and cell address for each view, such as Orders!A1 and Orders!N1, before moving between them. This is useful when the sheet is large or when row numbers are easy to lose track of.
Give the more important view more room. If you need to read a wide table in one window and only glance at a small summary in the other, make the table window wider. You do not need an exact 50/50 split for the arrangement to help.
Use browser zoom carefully. Browser zoom changes the size of the page and interface, while the Google Sheets zoom control changes the size of sheet content. If the text is too small, try adjusting the sheet zoom first; if browser controls or menus are taking too much space, adjust browser zoom separately.
Keep edits deliberate. Two windows make it easier to compare information, but they do not create a protected reference copy. If you need an unchanged record, make an authorized copy separately and be clear about which file is the working version.

Troubleshooting

The second window opens the wrong spreadsheet. Copy the complete address from the original spreadsheet’s browser address bar and paste it into the new window. Check that the account shown in the browser has access to the file. If the file is open under a different Google account, switch accounts or request access rather than creating a copy by mistake.

Both windows move to the same place. Make sure they are genuinely separate browser windows, not two views of the same tab or a single window you have resized. Click the second window and check whether its scroll position can be changed independently. If you used a duplicate tab, drag that tab out of the browser window so it becomes a separate window.

The windows will not snap side by side. Confirm that the browser windows are not maximized in a way that prevents dragging, then use the Windows key + Left Arrow and Windows key + Right Arrow shortcuts. On a Mac, use the green window button’s tiling options if available. As a fallback, restore each window from maximized mode, drag its edges to resize it, and position the windows manually. Closing extra windows can also make it easier to select the correct one in the snap chooser.

The sheet looks too narrow or text is hard to read. Widen the window that contains the important table, reduce the number of visible columns by scrolling horizontally, or adjust the sheet zoom. If the screen is small, alternate between a side-by-side layout and one maximized window rather than shrinking everything until the data is unreadable.

Changes do not appear immediately in the other view. Confirm that both windows display the same file, then wait briefly for Sheets to save and update. Check for an offline indicator or an internet connection problem. If necessary, reload the second window after ensuring that edits in the active window have been saved; avoid reloading while an unsaved change is in progress.

You need the top headings to remain visible. Use View > Freeze and choose the relevant row or column option. If you need to compare two distant areas that both scroll independently, freezing alone will not achieve that; keep the two-window arrangement and freeze headings in whichever view needs them.

Frequently Asked Questions

Can you split a Google Sheets window into two panes?
No. Google Sheets in a browser does not have a built-in command that divides one sheet window into two independently scrolling panes. Open the same spreadsheet in two browser windows and arrange them side by side for a similar comparison workflow.

Will changes in one window appear in the other?
Yes. If both windows are open to the same spreadsheet file, they are views of the same document. Saved edits should appear in the other view, though updates may not be instantaneous. Opening a separate copy is different; edits to a copy do not update the original.

Can I show two different tabs from the same spreadsheet?
Yes. Select one sheet tab in the first window and a different tab in the second. Both remain part of the same spreadsheet file. Check the tab name before entering data so that you edit the intended sheet.

Does View > Freeze split the screen?
No. Freeze keeps selected rows or columns visible as you scroll the rest of the sheet. It is useful for maintaining headings, but it does not create separate scrolling areas or display two distant sections at once.

Can I do this on a phone or tablet?
The Google Sheets mobile app is designed around one spreadsheet view and does not provide the same straightforward desktop window workflow. Some tablets support operating-system multitasking or split-screen apps, but the exact controls depend on the device. For reliable side-by-side views, use Sheets in a desktop browser.

Is this different from splitting a screen in Excel?
Yes. Excel for Microsoft 365 on Windows includes a Split command on the View tab, which can divide a workbook window into panes. Google Sheets does not offer the equivalent worksheet split-pane command, so the two-window method is the practical alternative in a browser.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.