To split an Excel worksheet into independently scrolling panes, select the cell below and to the right of where you want the split, then choose View > Split. To divide a printed sheet across pages, use Page Layout > Breaks instead. These are different features: Split helps you compare parts of a worksheet on screen, while page breaks control printed output.
What You’ll Need
- Excel for Microsoft 365 on Windows and a worksheet with enough rows or columns to make separate viewing areas useful.
- A saved workbook is recommended, particularly if you plan to change print settings or page breaks.
- If you are working in Excel for the web, open the workbook in the desktop app to use the Split command. The browser version has some viewing options, such as Freeze Panes, but does not offer the same worksheet-splitting controls as desktop Excel.
Step-by-Step
- Open the worksheet and decide what you need to compare. Split is useful when two relevant areas are far apart, such as column A with employee names and column Z with monthly totals, or the top rows of a long list and the latest records near the bottom. It keeps both areas visible in one worksheet window, rather than creating a second copy of the sheet. If your goal is to keep headings fixed while you scroll through one area, consider Freeze Panes instead; the distinction is explained below.
- Choose the split point. Click the cell immediately below and to the right of the point where the panes should meet. For example, to keep columns A and B in a pane on the left and split the sheet before column C, select a cell in column C. To keep rows 1 through 5 above the split, select a cell in row 6. Selecting a cell such as C6 creates both a vertical split before column C and a horizontal split above row 6. Select a cell in row 1 if you want only a vertical split, or in column A if you want only a horizontal split.
- Turn on the split. Select the View tab on the ribbon, then choose Split in the Window group. Excel adds a divider through the worksheet at the selected location. With a split in both directions, the sheet appears in four panes; with only one direction, it appears in two. The selected cell determines where the divider is first placed, so check the position before continuing.
- Adjust the divider if needed. Point to the horizontal or vertical divider until the pointer changes to a move cursor, then drag the divider to a more convenient location. Leave enough room in each pane to see the information you want to compare. If you drag a divider too close to the worksheet edge, one pane may become difficult to use. You can reposition the divider later without removing the split.
- Scroll each pane to the area you want to see. Click inside a pane to make it active, then use the mouse wheel, scroll bar, or navigation keys to move through that pane. Each pane can show a different part of the same worksheet. For instance, keep a summary near the top in one pane while scrolling another pane to the detail rows that feed it. If you have four panes, click in the particular pane you want to move before scrolling so you do not accidentally work in another area.
- Use the sheet normally, but check which pane is active. You can select cells and enter or edit data while a split is on. The active pane has a visible selection, so confirm that the cell outline is where you expect before typing or pasting. A split does not lock cells, protect data, or create a separate editable copy. Changes made to a cell appear in every pane that displays that same cell.
- Remove the split when you are finished. Choose View > Split again to turn the split off. This toggles the split display; it does not delete rows, columns, or worksheet content. If you want to keep using the split but change its position, drag the divider instead of toggling the command. If the divider is hard to locate, use View > Split to remove it and then set it up again from a carefully selected cell.
- If you meant printed pages, set a page break instead. Select the row below where a horizontal printed-page break should go, or the column to the right of where a vertical break should go. On the Page Layout tab, choose Breaks > Insert Page Break. To inspect the print divisions, choose View > Page Break Preview. You can drag a manual break in that view. To remove one, select a cell adjacent to it and choose Page Layout > Breaks > Remove Page Break; choose Reset All Page Breaks to remove manual breaks from the sheet. Check File > Print to preview the result.
For a quick comparison: View > Split changes how a worksheet is displayed in its window; it does not set the printed page layout. Page breaks affect where printed or exported pages divide, not how many independently scrolling areas appear on screen. If the worksheet is splitting unexpectedly in print preview, look at page breaks and scaling rather than the Split command.
Common Mistakes
- Confusing Split with Freeze Panes. Split creates separate panes that can scroll to different locations. Freeze Panes keeps selected rows or columns visible while you scroll the rest of the worksheet. For a header row that should remain at the top, select the cell below the rows to keep and choose View > Freeze Panes > Freeze Panes. For a simple top-row heading, choose View > Freeze Panes > Freeze Top Row. Do not use Split if all you need is a persistent header.
- Picking the wrong cell before splitting. Excel places the dividers above and to the left of the active cell. Selecting a cell too far down or across can create an awkwardly narrow pane. Turn the split off, select the intended boundary cell, and use View > Split again.
- Expecting the panes to show separate worksheets. All panes belong to the same worksheet. They are viewing windows into the same grid, not separate tabs or independent copies. To compare two different worksheets, use View > New Window, then arrange the workbook windows; Split itself does not divide one window between different sheets.
- Using a screen split to fix printing. A worksheet can look right on screen and still print across unwanted pages. Use Page Break Preview and File > Print to check printed divisions. Paper size, orientation, margins, scaling, and print area can all change the result.
- Thinking a split protects the data. A pane divider is only a viewing aid. It does not prevent edits or keep a range fixed. Use worksheet protection for editing controls or Freeze Panes for fixed headings.
Tips
- Choose a boundary that leaves enough width and height for useful content. A pane only a few pixels wide is technically present but rarely helpful.
- Use row and column headings to orient yourself when panes show distant areas. The Name Box to the left of the formula bar can also help you identify the selected cell.
- For a long table, compare a key column with distant details by creating a vertical split, then scroll the right pane horizontally. This can help you keep identifying information in view while checking columns farther across the sheet.
- For a large worksheet, a horizontal split can keep an overview or earlier section visible while you inspect lower rows. Consider whether Freeze Panes would be simpler if the upper area is only a set of headings.
- Before printing, switch to Page Break Preview and check the page divisions at the intended paper size. If a manual break does not land where expected, review scaling and print area; Excel may adjust the displayed breaks to fit the sheet.
- On Excel for Mac, the Split command is also on the View tab. Ribbon placement can vary slightly with the window size, but the same idea applies: select the boundary cell, then use View > Split. There is no standard keyboard shortcut for toggling Split. In Excel for the web, use the desktop app if you need this exact pane-splitting behavior.
Troubleshooting
- Nothing seems to happen after selecting Split. Look for a thin divider near the selected cell, and make sure you are on the worksheet View tab rather than another ribbon tab. A split can be subtle if the panes are nearly the same size or the divider is close to a gridline. Try selecting a cell farther down or across, then choose View > Split again.
- The split appears in the wrong place. The active cell at the time you use the command controls the initial position. Toggle the split off, select the cell immediately below and to the right of the desired boundary, and turn it on again. You can also drag an existing divider to adjust it.
- Scrolling moves the area you wanted to keep still. With Split, each pane can move, so click the pane you want to scroll before using the wheel or scroll bar. If you need a title row or identifier column to remain fixed while the rest moves, remove the split and use the appropriate Freeze Panes option.
- The worksheet prints on too many pages or breaks in the wrong place. Split does not control printing. Open View > Page Break Preview to inspect the printed divisions, and use File > Print to check the preview. Review orientation, paper size, margins, scaling, and the print area. Insert, move, or remove manual breaks only after confirming those settings.
- You cannot find Split in the browser version. Excel for the web has a different set of window commands. Open the file in Excel for Microsoft 365 on Windows or Mac to create independently scrolling panes with Split. If the aim is simply to keep headings visible in the browser, check whether View > Freeze Panes is available for your workbook.
- The divider will not move as expected. Position the pointer directly over the divider and wait for the move cursor before dragging. If you cannot grab it, turn the split off and create it again from the correct cell. A very small Excel window can also make divider placement awkward, so enlarge the window if necessary.
Frequently Asked Questions
How do I split an Excel worksheet into two parts?
Select a cell in the row or column where the boundary should begin, then choose View > Split. A cell in row 1 creates a vertical division; a cell in column A creates a horizontal division. A cell elsewhere creates both.
Can I split a worksheet into four panes?
Yes. Select a cell that is below the intended horizontal boundary and to the right of the intended vertical boundary, then choose View > Split. Excel creates four panes, which you can scroll separately.
How do I remove a split screen in Excel?
Choose View > Split again. This removes the pane dividers without changing worksheet data. If you only need to move a divider, drag it rather than turning the split off.
What is the difference between Split and Freeze Panes?
Split lets panes display different parts of the worksheet and scroll separately. Freeze Panes keeps selected rows or columns visible while you scroll the rest. Use Freeze Panes for persistent headers; use Split to compare distant areas.
How do I split an Excel sheet into printed pages?
Use Page Layout > Breaks > Insert Page Break, then inspect the result in View > Page Break Preview or File > Print. A screen split made with View > Split does not change printed page divisions.
Can I split one cell into two cells?
Not with the Split command, which divides the worksheet view. If you mean separating text stored in a cell, use Data > Text to Columns for suitable delimited or fixed-width content, or place the parts in separate cells using another appropriate method.
Related
- How to Search in Google Sheets
- Search in Excel: Keyboard Shortcuts, Find and Replace
- Save an Excel Workbook as a Copy Without Replacing It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Block an Email Sender in Outlook? How It WorksYes. Outlook lets you block an email address, and many versions also let you block an entire sending…
- How to Keep Track of Bills in ExcelTo keep track of bills in Excel, create a list with one row per bill due, record its…
- Google Sheets Filter Only for Me? Use Filter ViewsYes. In Google Sheets, use a filter view when you want to sort or filter rows without changing…
- How to Create a Badge Template in Word for PrintingTo create a badge template in Word, set up a page for your badge inserts, place a precisely…
- Excel Insert Page Break Based on Cell Value?Excel has no built-in setting or worksheet formula that automatically inserts a page break when a cell contains…
- How to Check Duplicate Values in ExcelTo check for duplicate values in Excel, select the cells you want to inspect and choose Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.