How to Split an Excel Row in Half

How-to basics · Updated November 20, 2026

To split a row’s contents between two rows in Excel, insert a blank row beneath it, then cut and paste the cells you want to move into the new row. Excel does not have a one-click command that divides a worksheet row automatically. Before you start, decide which columns belong in each half and save a copy if the sheet contains important data.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or access to the workbook in another Excel version. The core steps are similar on Mac and Excel for the web, though ribbon labels and shortcuts can vary.
  • A clear plan for which cells should stay in the original row and which should move to the new one. For example, if a row has eight populated columns, you might leave the first four in place and move the last four.
  • Permission to edit the worksheet. If the sheet is protected, you may need its password or the workbook owner’s help before you can insert rows or change cells.

Step-by-Step

  1. Check what you mean by “split.” This guide’s main method divides the contents of one row across two worksheet rows. Excel rows span the full width of a sheet, so the operation does not create two independent row halves or a divider inside one cell. If you instead want to divide text that is inside one cell, see the alternatives below and the FAQ.
  2. Choose the row and the dividing point. Find the row you want to divide, then decide which cells should remain in it and which should move. For example, suppose row 8 contains an order number in A8, a customer name in B8, a date in C8, a product in D8, a quantity in E8, a price in F8, a shipping status in G8, and a note in H8. You could keep A8:D8 on the first row and move E8:H8 to the second. Think about whether the information in each half will still make sense on its own.
  3. Inspect formulas, merged cells, and neighboring data. Look along the row for formulas, merged cells, hidden columns, and cells that appear blank but contain spaces or formulas. Note any formulas that refer to the row you are changing. If the row is part of a sorted list, check that the new row will remain with the right record. For a complex worksheet, save a separate copy before editing so you can restore the original if the result is not right.
  4. Insert a blank row immediately below the row you want to split. On Windows, click the number of the row below the target row to select that entire worksheet row. For the example, select row 9. Go to Home > Insert > Insert Sheet Rows. You can also right-click the selected row number and choose Insert. Excel adds a blank row above the selected row, which places it directly under row 8. Check that the blank row is in the right position before moving anything.
  5. Use the table-specific option if the data is an Excel table. If the row is inside a formatted table with filter arrows, avoid assuming that an ordinary worksheet row will behave like a table record. Right-click a cell in the table row immediately below where you want the new record, choose Insert, then select Table Rows Above if that option appears. This keeps the added row within the table structure. If you do not see the table option, confirm that you selected a table cell, not a cell outside the table.
  6. Select only the cells that should move. In the example, select E8:H8, not the whole row. Drag across the cells, or click E8 and Shift-click H8. If the cells are not adjacent, you can select multiple ranges with Ctrl-click on Windows, but moving one continuous block is usually easier to manage. Check the selection border and the Name Box before cutting; selecting the whole row by clicking its row number would move or replace all of its contents.
  7. Cut the selected cells. Press Ctrl+X on Windows. A moving dashed border indicates that the range is ready to move. On Mac, use Command+X. You can also use Home > Cut. Cutting is preferable to copying here because it moves the values and formulas rather than leaving duplicate entries in the original row.
  8. Paste into the matching columns of the new row. Click the first destination cell directly below the first cell in the range you cut. In the example, click E9, then press Ctrl+V on Windows or Command+V on Mac. Excel pastes the block into E9:H9, leaving A9:D9 empty. The original cells E8:H8 become empty, so the first row now contains A8:D8 and the second contains E9:H9. Confirm that each value is under the intended column heading.
  9. Review the result and adjust formatting. Compare both rows with the original data and check that no values have shifted into the wrong columns. Excel may carry the source cells’ formatting into the pasted range, but the new row’s height, borders, and shading may not match the surrounding rows. Use Home > Format for row height, or use the Format Painter if you want to copy a consistent look. Avoid merging cells just to make the two parts appear joined; merged cells can complicate sorting, filtering, and later edits.
  10. Check calculations and save. Verify formulas, totals, conditional formatting, and any charts or summaries that depend on the changed range. Inserting a row can cause Excel to adjust many references automatically, but do not assume every formula or external link still represents the intended calculation. If everything is correct, save the workbook. If the change was accidental, use Ctrl+Z on Windows or Command+Z on Mac immediately, before performing unrelated edits.

If your goal is to split a single cell’s text rather than move part of a row to a new row, select that cell or column and use Data > Text to Columns. Choose Delimited if the text has a separator such as a comma or space, or Fixed width if each part begins at a consistent position. Follow the wizard and choose a destination with enough empty cells so the results do not overwrite existing information. Text to Columns splits content into columns, not into two worksheet rows; it is a different operation.

Common Mistakes

Moving the entire row instead of part of it: Clicking a row number selects every cell across that worksheet row. If you cut that selection, you may move all the data, not just the portion you intended to split. Select the cell range itself, such as E8:H8, and check it before cutting.

Inserting the blank row in the wrong place: Excel inserts a row above the selected row. If you select row 8 rather than row 9, the blank row will appear above the target data. You can undo the insertion and repeat it, or insert the row at the correct position before proceeding.

Leaving the new row disconnected from its record: Moving only some columns can make the second row look like a separate record, even when it is meant to continue the first. Decide whether repeating an ID, name, or date is important for sorting and filtering. If you repeat identifying values, do so deliberately and check whether formulas or reports treat the repeated entry as a duplicate.

Overwriting existing cells: Pasting into a destination that already contains data replaces its contents. Confirm that the new row is blank in the columns where you plan to paste. If a warning appears or the destination is not empty, stop and choose another location rather than dismissing the warning without checking.

Assuming a visual split changes the data structure: Adding a border, changing row height, or using merged cells may make a row look divided, but it does not split its contents into separate records. Keep the actual data layout clear so sorting, filtering, and formulas continue to work as expected.

Tips

Keep the same column meaning on both rows. If column E means Quantity, for example, put quantities in column E on either row rather than shifting the moved values left to fill blank cells. A consistent layout makes the data easier to sort, filter, chart, and use in formulas.

Use a short, meaningful identifier on both rows when they represent parts of one item, if that suits the data. For example, a project ID can help show that two lines belong together. Avoid duplicating a unique transaction number if a report counts each appearance as a separate transaction; consider adding a line number or parent ID instead.

When handling a large range, use the Name Box to select cells precisely. Click the Name Box to the left of the formula bar, type a range such as E8:H8, and press Enter. This reduces the chance of accidentally selecting a neighboring cell. The same approach works for selecting a destination range, though for a normal paste you can simply click the top-left destination cell.

For a one-time change, cutting and pasting is usually the clearest option. If you need the same split repeatedly, plan the sheet layout first or use a repeatable data-cleaning process. Do not use formulas or macros just to make a simple manual move unless you have a specific reason; extra automation can make a workbook harder for other people to maintain.

On Excel for the web, the row-insertion and cut-and-paste approach is broadly similar, but some context-menu labels or formatting controls may differ. On Mac, use Command instead of Ctrl for cut, paste, and undo. If a shortcut is intercepted by your browser or operating system, use the corresponding ribbon command instead.

Troubleshooting

The Insert option is unavailable: The worksheet may be protected, the workbook may be read-only, or you may not have edit permission. Check Review > Unprotect Sheet if you have authorization and the password. If the file is shared or stored online, confirm that you have editing access. Do not try to bypass protection; ask the workbook owner if you need permission.

Excel says it cannot shift cells: There may be content or formatting at the bottom or edge of the worksheet that prevents an insertion, or the selection may be part of a table or merged area. Try selecting only the row number below the target and inserting a sheet row. Check for merged cells around the target, and unmerge them only if you understand how the layout will change. If the workbook has data near the last worksheet row, move or remove only confirmed-unused content after making a backup.

The paste lands in the wrong place: Press Ctrl+Z on Windows or Command+Z on Mac right away. Select the intended destination’s top-left cell and paste again. If you have made other changes since the paste, undo carefully and verify each change rather than repeatedly pressing the shortcut without checking.

Formatting looks inconsistent: The inserted row may inherit formatting from adjacent rows, and pasted cells may retain the source formatting. Select the affected cells and use the Home tab’s number, fill, border, and alignment controls to match the surrounding data. If only the appearance is wrong, avoid retyping values; fix the formatting separately so formulas and data types remain intact.

A formula or total changed unexpectedly: Inspect the formula bar and compare the formula with the original. Row insertion can adjust cell references, and moving formulas can change their location. Also check whether a total uses a fixed range that excludes the new row. Restore the saved copy if the workbook’s logic is difficult to verify, then ask the person responsible for the calculations before making further changes.

The row is part of a filtered list: Clear or review filters before deciding where the inserted row belongs. A filtered view can hide records, making the new row appear out of sequence or suggesting that data has disappeared. In a table, add the row using the table-specific insertion option and confirm that the new record is included in the table’s filters.

Frequently Asked Questions

Can Excel split one worksheet row into two automatically?
No. Excel does not provide a command that automatically divides a row into two rows. Insert a blank row, then move the cells you want into it. A macro or custom process could automate a defined repeat task, but it is not necessary for a simple split.

Can I split one cell into two cells?
Excel does not have a general-purpose Split Cell command like some word-processing or presentation apps. You can use Data > Text to Columns to divide text using a delimiter or fixed positions, or insert a column and distribute the content yourself. This creates separate columns, not two halves of a worksheet row.

How do I divide a row evenly?
Decide what “evenly” means for your data. If a row has eight relevant columns, you might move four cells to the new row, but equal numbers of cells do not always make a meaningful division. Keep each value under its original column heading and avoid splitting related fields apart.

Will formulas update when I insert the row?
Excel usually adjusts cell references when rows are inserted or cells are moved, but the outcome depends on how a formula is written and what it references. Check important totals, lookups, charts, and linked sheets after the change. In particular, verify that fixed ranges include the new row when they should.

Can I split a row in Excel for the web or on a Mac?
Yes. You can insert a row and move selected cells in both versions. On Mac, the common cut, paste, and undo shortcuts use Command rather than Ctrl. Excel for the web may show slightly different menus, so use the ribbon’s Insert and Cut commands if the described context-menu wording is not available.

How do I undo a row split?
Use Ctrl+Z on Windows or Command+Z on Mac immediately after the change. If you have made several edits since then, undo may also reverse those later actions. For a more reliable recovery, close without saving if appropriate or restore the backup copy you made before editing.

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.