Office Compatibility Issues

How to Split Tables in Current Versions of Microsoft Excel

Steven ParkerSteven Parker Nov 3, 2026 870 views

Question details

The user wants to know if the table-splitting feature shown in older tutorial videos is still available in Microsoft 365 Excel and how to access it.

How to Split Tables in the Current Version of Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Trying to divide a single data table into two separate tables based on instructions from an older tutorial video.
Observed behavior
The user is unable to locate the native "split table" command in the current version of Microsoft 365 Excel, as the feature appears to be missing or was misinterpreted.
Before you start

Take a moment to identify exactly where you want your table to be divided, and consider creating a copy of your worksheet to prevent any accidental data loss while restructuring your tables.

Solution 1Recommended

Divide the Table Manually by Copying and Pasting

Since Excel does not have a native 'Split Table' button for worksheets, manually copying the desired rows to a new location is the most reliable workaround.

Often, tutorials demonstrating a 'Split Table' feature in Excel are actually showing an Excel table that has been embedded into a Microsoft Word document, where the split feature does natively exist. For standard Excel worksheets, you must manually separate the data ranges.

1
Select the rows to split

Click and drag to highlight the specific rows in your current table that you want to move into a new, separate table.

2
Cut or Copy the data

Right-click the highlighted area and select 'Cut' (or press Ctrl + X). If you want to keep the original data intact for now, select 'Copy' (Ctrl + C) instead.

3
Paste into a new location

Click on an empty cell below your current table or in a completely new worksheet. Right-click and choose 'Paste' (Ctrl + V) to drop the data.

4
Format as a new table

Highlight your newly pasted data, navigate to the 'Home' tab, and click 'Format as Table' to turn this new data range into an independent, fully functional Excel table.

5
Delete original rows

If you used 'Copy' instead of 'Cut', return to your original table, highlight the duplicated rows, right-click, and select 'Delete' > 'Table Rows' to finish the split.

Divide the Table Manually by Copying and Pasting
Embedded Tables: If you are working with an Excel table pasted into Microsoft Word, you can simply click inside the table, go to the Table Tools 'Layout' tab, and click 'Split Table'.
WPS Spreadsheet

Manage and Restructure Tables Seamlessly in WPS Office

While spreadsheet software inherently lacks a one-click 'Split Table' function, WPS Spreadsheet makes data restructuring incredibly fast. Its lightweight design and intuitive interface allow you to effortlessly divide, copy, and reformat large datasets without lag.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) file containing the table you want to modify.
  2. 2. Separate your data: Highlight the rows you need to split. Right-click to Cut, then Paste them into an empty area or a new sheet.
  3. 3. Apply table formatting: Select the newly separated data block, go to the Home tab, and choose 'Format as Table' to instantly create a new, independent table.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Intuitive drag-and-drop cell manipulation for quick data splittingFree and lightweight alternative to heavy office suitesAdvanced 'Format as Table' presets to quickly style separated data
microsoft office alternative - wps office

Frequently Asked Questions

Why did an old tutorial show a 'Split Table' feature in Excel?

The tutorial most likely demonstrated an Excel table that was embedded within a Microsoft Word document. Microsoft Word has a native 'Split Table' command under its Table Tools Layout tab, but Excel worksheets have never had this specific one-click button.

Can I split a single cell diagonally in Excel?

Yes, you can split a cell visually by adding a diagonal border. Right-click the target cell, select 'Format Cells', navigate to the 'Border' tab, and click the diagonal line icon.

How do I separate text from one column into multiple columns?

If you need to split combined text data (like full names) into separate columns, highlight the data, go to the 'Data' tab, and click 'Text to Columns'. You can then separate the text based on delimiters such as spaces or commas.