Forum Discussion
Excel
Unable to Split Table in Excel "Table Tools Layout" option is missing on Excel application. As per this link option is available but not on the application.
https://support.microsoft.com/en-us/office/video-split-tables-5b72f010-6121-4b91-9011-120d66b000fb#:~:text=1%20Try%20it%21%202%20In%20the%20row%20that,Design%20and%20then%20select%20the%20style%20you%20want.
Please help.
9 Replies
That article is very misleading. Although Excel is mentioned, it does not apply to Excel, but to Word (as you can see in the video)
- Is there any way to split an Excel 365 table? It seems very strange to me that Microsoft would think that is important for tables in Word, but not for tables in Excel.
The cited video specifically says it applies to Excel 365 although, as you point out, their example in the video is using Word.Microsoft's documentation is only a pale shade of what it used to be.
Moving ranges of cells is much easier in Excel than in Word, so the developers probably didn't think it necessary to provide a dedicated command for splitting a range or table.
You can submit a suggestion from within Excel, through File > Feedback > Send a suggestion.
