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/of...
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.
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.
- Thanks. I have a semi-off-topic question for you. Is there a way for an Excel table column to span more than one Excel spreadsheet column? I have a couple of table columns that need to be wide in the table, but I do not want to have to make those columns wide for the whole spreadsheet.
No, it is not possible to merge cells inside a table.