How to Split an Excel Sheet in Half Using Split Panes

How-to basics · Updated November 20, 2026

To split an Excel worksheet into independently scrollable sections, select the cell where the split should meet, then choose View > Split. Excel divides the worksheet view at that point; it does not divide the data or create a second worksheet. If you mean splitting the data into two separate sheets or files, see the options below.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook open in the desktop app. The Split command is also available in Excel for Mac, though ribbon placement can vary slightly.
  • A worksheet large enough that viewing or scrolling two areas independently would be useful. Save the workbook first if you have unsaved changes.
  • A clear idea of where you want the divider: between columns, between rows, or at a point that creates four panes.

Step-by-Step

  1. Open the worksheet you want to view in sections. Click its sheet tab at the bottom of Excel. The split affects the current worksheet window, not the contents of the sheet. If you have multiple worksheets, confirm you are on the right one before applying it.
  2. Choose the position of the split. Click a cell that is just below and/or to the right of where you want the dividing line. For example, click A21 to make a horizontal split above row 21, or D1 to make a vertical split before column D. Clicking D21 makes a horizontal and vertical split, creating four panes. The split is placed above and to the left of the active cell, so think of the selected cell as the first cell in the lower-right area.
  3. Open the View tab. On the Windows ribbon, click View. In the Window group, click Split. Excel adds divider bars to the worksheet view. If you selected A21 or D1, you should see one divider; selecting D21 should produce two.
  4. Check which area is active. Click inside a pane and use its scroll bars, mouse wheel, or keyboard navigation to move through that area. Each pane can show a different part of the same worksheet. This is useful for keeping headings or identifying columns visible while you inspect distant rows or columns. The panes are views of one sheet, not separate copies: editing a cell in one pane changes the same cell wherever it appears.
  5. Adjust the divider if needed. Point to a divider until the pointer changes, then drag the bar to a more useful position. You can make one pane larger than another; the split does not have to be exactly centered. If you accidentally create the wrong arrangement, click View > Split to remove it, select a different cell, and apply Split again.
  6. Remove the split when you are finished. Choose View > Split again. The divider bars disappear and the worksheet returns to a single scrolling view. Removing the split does not delete, rearrange, or change any worksheet data.

On Excel for Mac, select the cell and use View > Split from the menu or ribbon, depending on your Excel layout. The same general rule applies: the active cell determines where the split begins. Keyboard shortcuts for navigating panes can differ between Mac and Windows, so using the visible divider and scroll bars is the most reliable way to move around.

If you are using Excel for the web and cannot find Split, open the workbook in the desktop app for this view feature. The web app’s available viewing commands can differ from the Windows desktop version. Do not confuse Split with Freeze Panes: freezing keeps selected rows or columns stationary as you scroll, while splitting creates separate, independently scrollable areas of the worksheet window.

If You Mean Splitting the Data

Sometimes “split an Excel in half” means dividing a list into two sets, worksheets, or workbook files. The Split command above will not do that. For a small list, make a copy of the worksheet first, then select the rows for one group and copy them to a new worksheet. Repeat for the other group, keeping the header row in both sheets if each needs its own headings. Use copy and paste rather than deleting or cutting the original rows until you have checked the results.

For two separate files, create and verify the two worksheets first, then use File > Save As to save a copy of the workbook under a new name. In that copy, remove the sheet you do not want, and repeat from the original workbook for the other half. This is safer than repeatedly editing the only copy. If formulas refer to other sheets, check those references after separating them; formulas may continue to point to sheets that are no longer included or may need updating. For a very large or regularly refreshed list, decide how to divide the records (for example, by date or category) before copying, and verify that every original record appears in exactly one group.

Common Mistakes

  • Expecting the Split command to divide the file. Split only changes how the worksheet is displayed. It will not create new sheets, separate records, or save two workbooks.
  • Selecting the wrong cell before applying Split. Excel uses the active cell to position the divider. A cell farther down or farther right can create more panes than intended. If the result is awkward, remove the split and retry with a cell closer to the desired boundary.
  • Confusing a split with frozen headings. A split gives each pane its own scrolling position. If the goal is to keep the top row or first column visible while scrolling one continuous view, use View > Freeze Panes instead.
  • Thinking a repeated value is a duplicate record. The same cell can appear in more than one pane when the panes are positioned to show overlapping areas. Editing it in either view changes the single underlying cell.
  • Moving or deleting rows before making a safe copy. When you mean to divide data, cutting rows can disrupt formulas, references, or formatting. Copy the data to new sheets first, compare the results, and only then decide whether to remove anything from the original.

Tips

  • Use a vertical split to compare distant columns. For example, if product names are in column A and annual results are far to the right, place the vertical divider between the sections. Scroll one pane toward the names and the other toward the results.
  • Use a horizontal split to compare distant rows. This can help when checking a summary near the top against detailed records farther down. Choose the row where you want the lower pane to begin, then adjust the bar for comfortable viewing.
  • Choose Freeze Panes for a persistent header. If you want headings to remain at the top while the rest of the worksheet scrolls, click the cell below the rows and to the right of the columns to keep visible, then choose View > Freeze Panes. For a simple top-row header, use View > Freeze Panes > Freeze Top Row.
  • Zoom each area for readability. If one pane feels cramped, adjust the zoom control in the status bar while that pane is active. Check that text and values remain legible before comparing figures.
  • Save a useful view as part of your routine. The split is a viewing arrangement, not a new worksheet layout. If you share the workbook, tell collaborators what the panes are intended to show, or remove the split first if it could confuse them.

Troubleshooting

I clicked Split but nothing seemed to happen. Look closely for a thin horizontal or vertical divider near the selected cell. If the sheet is zoomed out, the bar can be hard to see. Try selecting a more distant cell, such as D20, and applying Split again. Also check that you are using the desktop Excel app rather than Excel for the web, where the command may not be available in the same way.

I got four panes when I wanted two. The selected cell was both below row 1 and to the right of column A, so Excel applied horizontal and vertical dividers. Click View > Split to clear them. For a horizontal-only split, select a cell in column A; for a vertical-only split, select a cell in row 1. Apply Split again.

The panes do not scroll the way I expected. Click inside the pane you want to navigate before using the mouse wheel or scroll bar. Each pane has its own position, and scrolling over a different pane moves that area instead. If you want one fixed heading rather than separate scrolling areas, remove the split and use Freeze Panes.

The divider is in the wrong place or takes up too much room. Drag it to reposition it. If it is difficult to grab, click Split to remove the bars, select the correct cell, and create the split again. You can also maximize the workbook window or reduce the number of panes to give each visible area more space.

I cannot find the Split button. On Windows, check the View tab’s Window group. If the Excel window is narrow, some ribbon commands may be condensed or shown in a menu. On Mac, check the View menu or View ribbon tab. If the command is still missing, confirm that you are in the desktop Excel application and not viewing the workbook in a browser.

My data is now in the wrong sheet or file. If you copied records, use Undo immediately if the action is still reversible. Otherwise, return to the original or saved copy and compare row counts and key identifiers. When splitting a list, include the header row where needed and check for missing or repeated records before treating the new sheets as final.

Frequently Asked Questions

Can I split an Excel worksheet into exactly two equal halves?

The Split command creates viewing panes, but it does not automatically divide the screen or the data into equal halves. Select the cell that marks the divider, then drag the bar to balance the visible areas. If you mean dividing records evenly, count the data rows and copy the first and second groups to separate sheets.

Does splitting a worksheet change or copy any data?

No. It only changes the worksheet window so you can view and scroll different areas. The cells remain in their original positions, and edits made in one pane affect the same worksheet cells shown in any other pane.

How do I split only vertically or only horizontally?

For a vertical-only divider, select a cell in row 1 to the right of the desired split, such as D1. For a horizontal-only divider, select a cell in column A below the desired split, such as A21. Then choose View > Split.

What is the difference between Split and Freeze Panes?

Split creates independently scrollable areas in the worksheet window, which is useful for comparing separate locations. Freeze Panes keeps chosen rows or columns visible as you scroll through one continuous area. Use Freeze Panes for headings that should stay in view; use Split when you want to inspect different parts side by side or above and below.

Can I split a worksheet into two separate workbook files with one click?

No. Split is not a file-splitting tool. Copy the relevant records to separate worksheets, check formulas and references, and save separate workbook copies using File > Save As. Keep an untouched original until both files are verified.

Will the split appear when I reopen or share the workbook?

The split is a worksheet-window view, not worksheet content. What another person sees can depend on how the workbook is opened and the view state that was saved. If the panes are important, save the workbook after arranging them and explain what each pane shows; otherwise, remove the split before sharing for a simpler initial view.

Related

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.