Excel Split Screen: How to Jump Between Panes Quickly

To jump between panes in a split Excel worksheet, click inside the pane you want to use, or press F6 while focus is in the worksheet; press Shift+F6 to move back through the panes. Excel split screen lets you view different parts of one worksheet at the same time, so you can compare distant rows or columns without repeatedly scrolling away from your current location.

What You’ll Need

Excel for Microsoft 365 on Windows, with the workbook open to the worksheet you want to split.
A worksheet with enough rows or columns that viewing separate areas together will be useful. You do not need to select data before navigating between panes, but you will select a cell if you are setting up a new split.
For keyboard navigation, a keyboard with an F6 key. On some laptops, you may need to hold Fn while pressing F6.

Step-by-Step

Open the worksheet you want to work in. Split applies to the current worksheet, not to the entire workbook. If you have several sheets, choose the relevant sheet tab first. The split view is especially useful when you need to compare a heading near the top with data farther down, or a label column at the left with columns far to the right.
Set up a split if the sheet is not already divided. Select the cell where you want the dividing lines to meet. Then go to View > Window > Split. Excel places a horizontal divider above the selected cell’s row and a vertical divider to the left of its column. For example, selecting D5 creates a split above row 5 and to the left of column D. Selecting a cell in row 1 creates a vertical split only; selecting a cell in column A creates a horizontal split only. If the sheet is already split, do not click Split again until you have checked whether you might turn the split off.
Click inside the pane you want to navigate. This is the most direct method, particularly when you only have two panes. Click a cell in the lower pane to work in the lower section, or click a cell in the pane on the right to work with the columns there. The pane containing the active cell is the one that receives your keyboard input. You can then use the arrow keys, the Name Box, or the scroll bar to move around within that pane.
Use F6 to cycle between panes without reaching for the mouse. First make sure Excel’s focus is in the worksheet, for example by clicking a cell. Press F6 to move focus to another worksheet pane. Press it again to continue cycling. With a four-pane split, keep pressing F6 to reach each pane in turn. The cycle can also include other parts of the Excel window, such as the Ribbon or a task pane, so F6 may not appear to move directly from one worksheet pane to the next every time. Press Shift+F6 to cycle in the reverse direction.
Check which pane has focus before typing or scrolling. After switching, press an arrow key and confirm that the selection moves in the pane you intended. Each pane can show a different part of the same worksheet, but it is still one worksheet: editing a cell changes that cell for the whole sheet. If you land in the wrong area, click the intended pane or press F6 again rather than entering data immediately.
Scroll the active pane to the area you need. Use the mouse wheel or the scroll bars while the pointer is over the pane you want to move. You can also select a cell in that pane using the Name Box, which is to the left of the formula bar, and type a cell address such as A1 or M250. The pane’s view will move to show that location, while the other pane can keep showing its own area. If scrolling seems to affect a different area, click inside the intended pane first and try again.
Adjust or remove the split when you are finished. Drag a divider to change how much space each pane gets. To return to one continuous worksheet view, choose View > Window > Split again. The command toggles the split off. You can also set up a different arrangement by removing the existing split, selecting a new cell, and choosing Split again. The current split is a viewing arrangement; it does not create a second copy of the worksheet.

For a quick example, suppose row 2 contains column headings and the records you need to compare are around row 500. Select a cell in row 3 and choose View > Window > Split. Keep the top pane near the headings, click the lower pane, and move to the records around row 500. Press F6 to switch panes as needed, or click the pane you want. This lets you refer to the headings while examining distant rows in the same sheet.

Common Mistakes

Confusing Split with Freeze Panes. Both features can keep part of a sheet visible while you work, but they behave differently. Split creates separate panes that you can scroll independently. Freeze Panes keeps selected rows or columns fixed while the remaining worksheet scrolls. If your goal is to keep headings visible while scrolling, Freeze Panes may be a better fit; if your goal is to view and scroll separate regions, use Split.
Expecting F6 to cycle only between two areas. F6 is an Excel focus-navigation key, not a dedicated two-pane toggle. Depending on your window and open task panes, it can move focus to other interface areas as well as worksheet panes. Keep pressing it, use Shift+F6 to reverse, or click the pane directly if keyboard navigation takes you somewhere unexpected.
Clicking Split a second time by accident. Split is a toggle. If the worksheet is already divided, choosing the command again removes the split instead of adding another one. Check the worksheet before using the command, especially if you are trying to create a four-pane view.
Assuming each pane is a separate worksheet. A split only changes what is visible. All panes show the same sheet, and editing a cell in one pane changes that cell everywhere it appears. Be careful when pasting, deleting, or entering formulas if another pane is showing a related part of the sheet.

Tips

Choose the split point based on what you need to keep in view. For a top-and-bottom comparison, select a cell in the first column so Excel creates a horizontal divider without an unnecessary vertical one. For a left-and-right comparison, select a cell in the first row. To divide the sheet both ways, choose a cell away from the top row and first column.
Use the Name Box for long-distance navigation. Click in the pane you want, enter a cell reference such as H400 in the Name Box, and press Enter. This is often faster than dragging a scroll bar through hundreds of rows. Confirm that the target cell appears in the intended pane before editing.
Give each pane enough room to be useful. Drag the divider so the reference area is large enough to read, but leave enough room in the other pane to inspect your working data. If a pane becomes too narrow, column headings and values may be truncated, making comparisons harder.
Remember laptop function-key settings. Some keyboards use the F-key row for brightness or media controls. If pressing F6 changes a system setting instead of moving Excel focus, try Fn+F6. The exact behavior depends on your keyboard’s function-key setting.
On Mac or Excel for the web, use the visible controls if shortcuts differ. Excel for Mac also provides a Split command under the View tab, though function-key behavior can depend on macOS and keyboard settings; use Fn with F6 if your Mac assigns a hardware function to that key. Excel for the web can have a different interface and feature availability. If you cannot find Split in its View controls, open the workbook in the desktop app and use View > Window > Split.

Troubleshooting

F6 moves to the Ribbon or another part of Excel. This can be normal. Press F6 again to continue cycling, or press Shift+F6 to go in reverse. If you need to switch immediately, click inside the target worksheet pane. Clicking a cell also returns focus to the worksheet before you try F6 again.
F6 seems to do nothing. Check whether the worksheet has actually been split, and make sure Excel is the active application. On a laptop, try Fn+F6. If your keyboard or system intercepts the key, use the mouse to select a pane; navigating by clicking does not require a shortcut.
The wrong section scrolls. Click a cell in the pane you intend to move, then scroll again. When using a mouse wheel, place the pointer over that pane before scrolling. If the pane is too small to click easily, drag the divider to make it larger or use F6 to move focus first.
The split lines are missing or the sheet looks unusual. Go to View and check whether Split is enabled. If the worksheet has returned to one view, select a suitable cell and choose View > Window > Split. If the divider is in the wrong place, remove the split, select the desired cell, and create it again rather than trying to guess which cell originally set it.
The view does not behave like a split. Check whether Freeze Panes is active instead. A frozen area stays fixed rather than scrolling as an independently navigable pane. Use the Freeze Panes controls on the View tab to unfreeze if needed, then create a split if independent scrolling is what you want.

Frequently Asked Questions

What is the shortcut to move between split panes in Excel?
Press F6 to cycle focus, starting from the worksheet. Use Shift+F6 to cycle in reverse. Because the cycle can include the Ribbon and other interface areas, clicking the target pane is a reliable alternative.

Can I jump between panes with the mouse?
Yes. Click any cell in the pane you want to activate. That pane then receives keyboard input and can be scrolled separately from the other pane or panes.

Can I split a worksheet into four sections?
Yes. Select a cell that is below row 1 and to the right of column A, then choose View > Window > Split. Excel creates horizontal and vertical dividers. Use F6 repeatedly or click a cell to move among the four panes.

Does changing a cell in one pane change it in the other pane?
Yes. The panes are different views of the same worksheet, not separate copies. A change to a cell is reflected wherever that cell is visible.

How do I get rid of split screen?
Choose View > Window > Split again to toggle the split off. If you want to keep a heading fixed rather than remove it, consider using Freeze Panes instead.

Why does F6 not switch straight to the pane I want?
F6 cycles through Excel focus areas, which can include the Ribbon or a task pane as well as worksheet panes. Continue pressing it, use Shift+F6 to reverse, or click directly in the destination pane.

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.