To split an Excel sheet into two viewing panes, select the cell where the split should begin, then choose View > Split. Excel divides the window so you can scroll through different parts of the same worksheet independently; it does not divide or move the worksheet’s data. If you mean separating rows into two worksheets, copy each portion to a new sheet instead. The steps below explain both options so you can choose the one you need.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, with the workbook open.
- For a viewing split, decide where the divider should appear. For a data split, identify which rows belong in each resulting worksheet and whether both need the column headings.
- If the workbook contains important information, save it before rearranging or copying data. A separate copy is especially useful when you are unsure which rows to move.
Step-by-Step
- Decide what “split in half” means for your task. Use Excel’s Split command when you want to see or scroll through two areas of the same worksheet at once, such as the top of a long list and a section much farther down. The command creates panes inside the current window; it does not create a second worksheet, split the file, or change your data. If you need two independent lists, reports, or files, use the separate-worksheet method in steps 7–10 instead.
- Open the worksheet and choose the split point. Click the cell at the row and column where you want the divider to start. Excel places dividers above and to the left of the selected cell when there is content area on both sides. For example, selecting D21 creates a horizontal divider above row 21 and a vertical divider to the left of column D. This can create four panes, not two. The split is positioned in the worksheet window, so choose a cell that puts the divider in a useful place on screen.
- Create a horizontal split only. To divide the view into an upper and a lower pane, select a cell in column A at the first row you want in the lower pane, such as A21. Then select View > Split. Because there are no worksheet columns to the left of column A, Excel has no left-hand area to show, so the result is a horizontal divider. You can scroll the upper and lower panes independently to compare distant rows.
- Create a vertical split only. To compare left and right sections of wide data, select a cell in row 1 in the first column you want in the right-hand pane, such as D1. Choose View > Split. Since there are no worksheet rows above row 1, the result is a vertical divider. This is useful when columns at the far right need to be compared with identifying columns at the left.
- Create a split in both directions if useful. Select a cell away from the first row and first column, such as D21, and choose View > Split. Excel creates horizontal and vertical dividers, making four panes. Each pane can show a different part of the worksheet. This layout can be helpful for comparing distant rows and columns, but it may feel crowded on a small display.
- Adjust and use the panes. Drag a divider to reposition it. Scroll within a pane to move through its rows or columns without moving the other panes. Click inside a pane before scrolling so Excel knows which one you want to move. If a divider is hard to grab, use the scroll bars or adjust the worksheet zoom and window size to make the pane boundaries easier to see.
- Remove the viewing split when finished. Choose View > Split again to turn the split off. You can also use the command to toggle the split state. If you have created four panes and only want to remove one divider, be aware that Split is a toggle rather than a separate control for each divider; clicking it removes the split layout. Create a new split afterward at the cell you want.
- For a permanent data split, add two worksheets. Click the plus button beside the sheet tabs to create a worksheet, and click it again for a second one. Rename the tabs to make their contents clear, for example First half and Second half. Renaming sheets does not affect the original data. Keep the source worksheet intact until you have checked both copies.
- Copy the headings and first group of records. On the original worksheet, select the header row and the first group of data rows. Copy the selection, open the first new worksheet, select A1, and paste. For example, if the table has headings in row 1 and 100 records in rows 2 through 101, you could copy rows 1 through 51 to the first new sheet. That gives the first sheet the headings and 50 records.
- Copy the remaining records to the second worksheet. Select the header row and the other data rows on the source sheet, then copy and paste them into cell A1 of the second new worksheet. With the example above, copy row 1 and rows 52 through 101. Each new sheet now has the same headings and half of the records. If you prefer not to repeat the headings, copy only the remaining data rows to the second sheet, but keeping headings usually makes each sheet easier to understand on its own.
- Check the results before deleting or changing anything. Confirm that the first and last records appear in the intended sheets, the headings are present, and no record is missing or duplicated. Count the data rows in both sheets and compare their combined total with the original. If the original range is an Excel table, check whether the copied ranges retain the table formatting and filters you need. Save the workbook after verifying the split.
When the records cannot be divided evenly, one sheet will have one more record than the other. For example, splitting 101 records gives one group of 51 and another of 50. Decide which group should receive the extra record, and make the cut between complete records rather than through the middle of a row. If a header row exists, count records separately from the header so the heading is not mistakenly treated as a record.
Common Mistakes
- Expecting Split to create new sheets. View > Split changes only how the current worksheet window is displayed. It does not move, copy, or divide cell contents. Use separate worksheet tabs when you need two permanent data sets.
- Selecting a cell without considering both its row and column. Selecting D21 can create four panes, which surprises people who wanted just one horizontal line. Use a cell in column A for a horizontal-only split or a cell in row 1 for a vertical-only split.
- Dividing a table without repeating its headings. A second worksheet with no labels can be confusing, especially when printed or sent to someone else. Include the header row on each sheet unless there is a specific reason not to.
- Cutting through a record or losing a row at the boundary. Select whole records and check the last row copied to the first sheet and the first row copied to the second. Avoid selecting only part of a multi-column row.
- Confusing Split with Freeze Panes. Split gives sections of the window separate scrolling areas. Freeze Panes keeps selected headings or columns visible while you scroll through one main area. Choose View > Freeze Panes when your goal is to keep labels visible, not to scroll two sections independently.
- Overlooking filters, formulas, and formatting. Pasting records into new sheets may not preserve every relationship or setup in the same way as the original. Check formulas, table filters, conditional formatting, data validation, and references that point to the original sheet before relying on the copies.
Tips
- Use Split for comparison, not as a replacement for a second monitor. It is particularly useful when you need to keep a small reference area visible while reviewing distant rows. Resize the panes so the information you are comparing is not squeezed into narrow sections.
- Keep the original worksheet as a backup. Copying to new sheets leaves the source intact. If you choose to move or delete original rows afterward, save a new version first and verify the copied data before removing anything.
- Keep records together. If the list is sorted by date, customer, or category, make the split at a meaningful boundary when that helps readers. Do not separate a group of related rows merely to make the two sheets exactly equal in size.
- Make each new sheet self-explanatory. Give tabs descriptive names, retain clear column labels, and include any notes needed to interpret the records. If the sheets will be printed, check Print Preview and set the print area or orientation as needed.
- Consider a filter or a second window for other needs. If you only need to focus on certain rows, filtering may be simpler than making copies. If you want to look at separate areas without modifying the worksheet view, Excel can also open another window for the same workbook from View > New Window; this creates another view of the workbook, not another copy of its data.
Troubleshooting
Nothing happens when you choose Split. Make sure you are on the View tab and using the Split command in the Window group. If a split already exists, the command may remove it instead of adding another. Click the intended cell first, then select Split again. If you are editing a cell, press Enter or Esc to finish editing before using a ribbon command.
The divider appears in the wrong place. Split placement depends on the selected cell and the current worksheet view. Turn off the existing split, select the cell that corresponds to the intended boundary, and apply Split again. For a horizontal-only line, select in column A; for a vertical-only line, select in row 1. You can drag the divider after creating it, so the selected cell is a starting point rather than the only possible position.
All panes move together when scrolling. Click inside the specific pane you want to scroll, then use the mouse wheel or that pane’s scroll bar. If the movement is still not what you need, confirm that you used Split rather than Freeze Panes. These commands create different behaviors, and Freeze Panes does not provide independently scrolling sections.
The Split command is unavailable or behaves differently. Check whether the worksheet is protected or the workbook is in a restricted editing state; protection and shared-workbook settings can limit some actions. If you use Excel for the web, its available window and pane controls can differ from desktop Excel. Open the workbook in the desktop app for the full Windows ribbon workflow described here.
The new worksheets contain the wrong number of records. Go back to the original sheet and check the boundary rows. Make sure the heading row was not counted as a record, and check that hidden or filtered rows were not skipped unintentionally. Copy the corrected ranges again, then compare the total record count across both sheets with the original. Do not delete the source until the counts and boundary records match.
Formatting or formulas changed after copying. Inspect representative cells at the top, middle, and bottom of each new range. If formulas now refer to different cells or sheets, determine whether those references should stay linked to the original or be adjusted for the new layout. If preserving the appearance is the main concern, use Paste Options after copying and choose the appropriate paste type; values-only pasting, for example, removes formulas, so use it only when that is what you want.
Frequently Asked Questions
Does Excel Split divide the worksheet into two files?
No. View > Split creates separate viewing panes within the same worksheet window. To make separate files, copy the required worksheet or data into another workbook and save that workbook under a different name.
How do I split a sheet exactly in half?
For a viewing split, there is no fixed half of the worksheet: Excel places dividers according to the selected cell and window size, and you can drag them. For a data split, count the records, divide the count by two, and copy the first and remaining groups to separate sheets. With an odd number, one group will have one extra record.
Can I split a sheet into only two panes?
Yes. Select a cell in column A for two horizontal panes, or a cell in row 1 for two vertical panes, then choose View > Split. Selecting a cell farther into the worksheet can create four panes because Excel adds both a horizontal and a vertical divider.
What is the difference between Split and Freeze Panes?
Split creates panes that can scroll independently. Freeze Panes keeps selected rows or columns visible while you scroll through the rest of the worksheet. Use Freeze Panes for persistent headers; use Split to compare different locations at once.
Can I do this in Excel for Mac?
Excel for Mac also provides split and freeze controls on the View tab, though the ribbon layout and available controls can vary by release. Select the intended cell and look for Split on View. Mac keyboard shortcuts differ from Windows shortcuts, but no keyboard shortcut is needed for the steps above.
Will splitting a worksheet change my data?
The View > Split command changes only the display, so it does not alter cell contents. Copying rows to new worksheets creates additional copies; check formulas, filters, and formatting before treating those copies as independent records.
Related
- How to Resize an Image in an Excel Cell and Keep It Fitted
- Resize an Image in an Excel Header: Step-by-Step Guide
- Resize a Picture in an Excel Cell: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Close Group Excel Shortcut: Close Workbooks and RowsIn Excel for Microsoft 365 on Windows, press Ctrl+W to close the active workbook; Ctrl+F4 also closes the…
- Gmail Rules: How to Create and Manage Filters Like OutlookYes. Gmail can automatically sort, label, forward, archive, delete, or otherwise handle messages using filters—the feature that plays…
- How to Merge Cells in Google Sheets and Keep Data SafeTo merge cells in Google Sheets in a web browser, select the adjacent cells, then choose Format >…
- Merge Cells in Google Sheets: Steps and Data TipsTo merge cells in Google Sheets in a web browser, select the cells, then choose Format > Merge…
- Conditional Formatting for Overdue Dates in Excel: GuideIn Excel for Microsoft 365 on Windows, select the date cells, choose Home > Conditional Formatting > New…
- How to Insert a Cursive Signature in Microsoft WordTo insert a cursive signature in Microsoft Word, add a clear image of your handwritten signature with Insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.