To split an Excel worksheet into independently scrollable areas, select the cell where the split should begin, then choose View > Split. Excel adds horizontal and vertical dividers so you can view different rows or columns at the same time. This guide covers splitting the worksheet window in Microsoft Excel for Microsoft 365 on Windows; if you mean dividing a printed page, see the note in the troubleshooting section, because print page breaks are a different feature.
What You’ll Need
- An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365.
- A worksheet with enough rows or columns that viewing distant areas together would be useful.
- A moment to choose where the dividing lines should fall. Save the workbook first if you are making other changes, although creating or removing a split does not change cell data.
Step-by-Step
- Open the worksheet you want to split. Click its sheet tab at the bottom of the workbook. The split applies to the current worksheet view, not to the workbook as a whole. If the sheet is very wide or long, use the Name Box to the left of the formula bar to jump to a cell near the area you want to examine. For example, typing C5 in the Name Box and pressing Enter selects that cell.
- Choose the split point. Click the cell that marks the top-left corner of the area you want to view separately. Excel places a horizontal divider above that cell’s row and a vertical divider to the left of that cell’s column. For instance, selecting C5 makes one pane show rows 1–4 and columns A–B, while the other panes can show row 5 onward and column C onward. The exact result depends on the active cell, so check the selection before continuing.
- Turn on the split. On the ribbon, select View > Split. Excel draws split bars across the worksheet. Selecting C5 normally creates four panes: an upper-left area, an upper-right area, a lower-left area, and a lower-right area. Each pane shows part of the same worksheet, rather than making copies of the data. If you select a cell in column A, the split will not create a vertical division to its left; if you select a cell in row 1, it will not create a horizontal division above it.
- Scroll the panes to the areas you need. Click inside a pane to make it active, then scroll with the mouse wheel, scrollbar, or keyboard. Panes can show different portions of the worksheet, which is useful when comparing a heading or summary with rows far below it. If you have four panes, you can scroll each one separately. Excel keeps the worksheet content connected: editing a value in one pane changes that same cell wherever it is visible in another pane.
- Adjust the divider positions if needed. Point to a split bar until the pointer changes, then drag the bar to a more useful position. Drag a horizontal bar up or down to change how much vertical space the panes receive; drag a vertical bar left or right to change their widths. You can reposition the dividers to make room for row labels or a long description. If the bars are difficult to grab, maximize the Excel window or zoom in, then try again.
- Remove the split when you are finished. Select View > Split again to turn the feature off and return to one worksheet view. If you only want to remove one of two split directions, drag the relevant divider to the edge of the worksheet window; if that is awkward, turn off the split and create it again with a cell selection that produces the arrangement you want. Removing the split does not delete rows, columns, formulas, or formatting.
On Excel for Mac, select the worksheet and use View > Split on the ribbon if the command is available in your version. The controls may be arranged differently from Windows, but the principle is the same: choose a cell to set the split position, then use the Split command. Excel for the web has a more limited set of window-view controls; if you cannot find Split under View, open the workbook in the desktop app to use this method.
Common Mistakes
- Choosing the wrong active cell. The split is based on the selected cell when you turn it on. If the bars appear too high or too far left, turn the split off, select the intended cell, and apply it again. For a split after row 10 and after column B, select C11 before choosing View > Split.
- Expecting a frozen heading. Split panes are not the same as Freeze Panes. A split lets you scroll sections independently; it does not necessarily keep a heading fixed while the rest of the sheet moves. To keep a top row or left column visible as you scroll, use View > Freeze Panes instead. Choose the appropriate freeze option for the rows or columns you want to keep in place.
- Assuming the split creates separate worksheets. All panes display the same sheet. A cell changed in one pane is changed in the underlying worksheet, and the same cell may appear in more than one pane if the scroll positions overlap. Use separate worksheets or workbook windows if you need independent copies of information.
- Confusing worksheet panes with printed pages. The Split command changes how the sheet appears on screen; it does not divide or arrange printed output. For printing, use View > Page Break Preview to inspect page boundaries, or use Page Layout > Breaks to insert or remove a page break.
- Trying to make too many narrow panes. Four panes can be useful, but each has less room for data and labels. A vertical split through a worksheet with many wide columns can make values hard to read. Start with one horizontal or vertical division if that is sufficient, and adjust the bars before adding extra complexity.
Tips
- Use the split to compare distant sections. For a long transaction list, keep the upper pane near the column headings and scroll the lower pane to later records. For a wide budget sheet, position the vertical bar after the labels so you can compare those labels with columns farther to the right. The split is most helpful when you need to refer to one area while working in another.
- Choose a sensible zoom level first. If the worksheet is zoomed in too far, a pane may show only a few cells. If it is zoomed out too far, the text may be difficult to read. Set zoom using the status-bar control or the Zoom command on the View tab, then position the split bars so each pane has usable space.
- Keep headings visible with the right feature. If your main goal is to retain column names while scrolling down, use Freeze Panes rather than relying on a split. To freeze both a header row and label columns, select the cell below the rows and to the right of the columns to keep fixed, then choose View > Freeze Panes > Freeze Panes. Check the result by scrolling before continuing with your work.
- Use a split temporarily. It is a viewing aid, not a change to the layout of the data. Turn it off before handing the workbook to someone if the panes are likely to confuse them. If you need the same comparison regularly, consider saving the workbook with a useful active cell and view, and explain the pane arrangement to colleagues.
- Remember that printing is separate. Split bars do not appear as page dividers in a printout or PDF. To control printed pages, set the print area and scaling under Page Layout, and inspect the result in Print Preview. A worksheet that looks convenient in split view may still need its own print layout adjustments.
Troubleshooting
- The Split command is missing or unavailable. Confirm you are in the desktop Excel app and that a worksheet is active. If you are viewing the workbook in a browser, open it in Excel for Microsoft 365 on Windows or Mac and check the View tab there. Ribbon layout can vary with window size, so maximize the application and look through the View tab commands.
- The bars appear in unexpected places. Turn off the split, click the desired cell, and select View > Split again. Check that you did not leave the active cell in a different row or column. As a concrete example, choose C11 for a divider above row 11 and to the left of column C. This leaves rows 1–10 and columns A–B on the upper-left side.
- One pane will not scroll the way you expect. Click inside the pane before using the mouse wheel or scrollbar; the active pane determines which area responds. Also check whether a pane is already at the top, bottom, left, or right edge of the used area. If the view feels confusing, switch Split off and recreate it with fewer panes or a more central selection.
- The dividers are hard to move. Drag directly on the thin split bar, not on a cell border or the worksheet scrollbar. Maximizing the window can make the bars easier to reach. You can also turn the split off, select a better cell, and turn it back on rather than trying to drag a divider into an exact position.
- You meant to divide a printed sheet into pages. Do not use View > Split. Go to View > Page Break Preview to see print-page boundaries. To add a manual break, select the row below where a horizontal break should go or the column to the right of a vertical break, then choose Page Layout > Breaks > Insert Page Break. Use Print Preview afterward to confirm how the pages will come out.
- The workbook opens with an unexpected view. Split panes affect the on-screen view, not cell contents. Select View > Split to remove the split, or close and reopen the workbook if the view does not refresh as expected. If the sheet is protected or the workbook is shared in a restricted mode, some view controls may be limited; check whether the file can be edited normally or ask the owner for an editable copy.
Frequently Asked Questions
Does splitting an Excel page split the data into separate files?
No. It creates multiple viewing panes for one worksheet. The cells remain in their original locations in the same workbook, and changes made in one pane affect the same underlying cells.
Can I split a worksheet into two panes instead of four?
Yes. Select a cell in column A to create a horizontal division without a vertical one, or select a cell in row 1 to create a vertical division without a horizontal one. Then choose View > Split. You can also drag one of the bars to the worksheet edge to remove that direction of the split.
How do I keep the top row visible while I scroll?
Use View > Freeze Panes > Freeze Top Row. A split creates independently scrollable areas, while freezing keeps selected rows or columns fixed in place. Choose the option that matches what you want the sheet to do.
Will the split show up when I print or save as PDF?
No. The split is a screen-view arrangement and does not set print-page boundaries. Use Page Break Preview and Page Layout print settings to control pages, then check Print Preview before printing or exporting.
Can I use Split in Excel for the web?
Some worksheet-view controls differ between the browser and desktop versions, and Split may not be available in every web interface. If you do not see the command on the View tab, open the workbook in the Excel desktop app and make the split there.
Is there a keyboard shortcut for splitting panes?
There is no standard single keyboard shortcut for the Split command in the Windows ribbon. Use View > Split. Keyboard access keys can vary with ribbon configuration and Office updates, so the ribbon path is the dependable option; Mac users can also use the View menu or ribbon.
Related
- Resize a Table in Word From Excel Without Clipping
- How to Resize an Image in an Excel Cell and Keep It Fitted
- Resize an Image in an Excel Header: Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Break Preview: Remove the Watermark?To remove the large gray “Page 1” label in Excel, switch out of Page Break Preview: choose View…
- Inventory Spreadsheet Template for Google SheetsFor an inventory spreadsheet, use Google Sheets rather than Google Docs: Sheets is Google’s spreadsheet app, while Docs…
- Access Database Import from Excel: Steps and TipsTo import an Excel worksheet into Microsoft Access for Microsoft 365 on Windows, open the database, choose External…
- Can You Merge Cells in Excel? Options and LimitsYes, you can merge cells in Excel for Microsoft 365 on Windows: select the cells, then choose Home…
- Inventory Spreadsheet in Google Sheets or Google Docs?For an inventory spreadsheet, use Google Sheets rather than the Google Docs word processor. Sheets is built for…
- Close Multiple Windows in Excel: Keep Workbooks OpenTo close multiple Excel windows without closing a workbook, close each window separately: save any changes, select a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.