How to Split Tables in Current Versions of Microsoft Excel
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.

- 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.
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.
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.
Click and drag to highlight the specific rows in your current table that you want to move into a new, separate table.
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.
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.
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.
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.

Convert Table to Range and Insert Blank Rows
Use this method if you want to split a table exactly where it currently sits without moving data to a new worksheet.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) file containing the table you want to modify.
- 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. 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.

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.




