Split Cells in Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1291404%22%20slang%3D%22en-US%22%3ESplit%20Cells%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291404%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20work%20with%20Office%20365%20ProPlus.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20split%20some%20cells%20in%20an%20excel%20spreadsheet.%20I%20checked%20Help%20and%20online%20and%20the%20recommendation%20in%20here%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fmerge-or-split-cells-in-a-table-8b458deb-0fc5-4c8d-8d94-2d4da98193f8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fmerge-or-split-cells-in-a-table-8b458deb-0fc5-4c8d-8d94-2d4da98193f8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20in%20my%26nbsp%3B%20speadsheet%20I%20cannot%20see%20%3CSTRONG%3ETable%20Tools%3C%2FSTRONG%3E%2C%20the%20%3CSTRONG%3ELayout%26nbsp%3Btab%3C%2FSTRONG%3E%2C%26nbsp%3B%20and%20the%26nbsp%3B%3CSTRONG%3EMerge%20group%20%3C%2FSTRONG%3Eto%26nbsp%3Bclick%26nbsp%3B%3CSTRONG%3ESplit%20Cells%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%2C%20I%20checked%20here%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhere-are-the-table-tools-2afc4727-7bba-4d4e-b9bf-43ab5f995745%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhere-are-the-table-tools-2afc4727-7bba-4d4e-b9bf-43ab5f995745%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20now%20think%20there%20is%20a%20definition%20issue%2C%20because%20I%20do%20not%20understand%20the%20advice%20there%2C%20either.%20When%20I%20open%20excel%20I%20see%20a%20spreadsheet.%20Is%20the%20spreadsheet%20the%20same%20as%20the%26nbsp%3B%3CSPAN%3Etable%20or%20PivotTable%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegardless%2C%20I%20would%20appreciate%20if%20someone%20can%20guide%20me%20through%20on%20how%20to%20split%20a%20cell%20in%20my%20Excel%20spreadsheet.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%2C%20CT%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1291404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1291450%22%20slang%3D%22en-US%22%3ERe%3A%20Split%20Cells%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291450%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614080%22%20target%3D%22_blank%22%3E%40CTheodlos%3C%2FA%3E%26nbsp%3BThat%20guidance%20is%20for%20tables%20in%20Word.%26nbsp%3B%20Excel%20cells%20can't%20be%20split.%26nbsp%3B%20You%20can%20merge%20them%2C%20but%20not%20split%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301541%22%20slang%3D%22en-US%22%3ERe%3A%20Split%20Cells%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301541%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2183102%22%20slang%3D%22en-US%22%3ERe%3A%20Split%20Cells%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2183102%22%20slang%3D%22en-US%22%3E%3CP%3ESplit%20cell%3C%2FP%3E%3CP%3Eis%20same%20as%3C%2FP%3E%3CP%3EUnmerge%20cell%3C%2FP%3E%3CP%3Eunmerge%20is%20there%20in%20the%20merge%20group%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I work with Office 365 ProPlus.

I would like to split some cells in an excel spreadsheet. I checked Help and online and the recommendation in here : https://support.office.com/en-gb/article/merge-or-split-cells-in-a-table-8b458deb-0fc5-4c8d-8d94-2d4...

 

However in my  speadsheet I cannot see Table Tools, the Layout tab,  and the Merge group to click Split Cells

 

Then, I checked here : https://support.office.com/en-us/article/where-are-the-table-tools-2afc4727-7bba-4d4e-b9bf-43ab5f995...

 

I now think there is a definition issue, because I do not understand the advice there, either. When I open excel I see a spreadsheet. Is the spreadsheet the same as the table or PivotTable?

 

Regardless, I would appreciate if someone can guide me through on how to split a cell in my Excel spreadsheet.

Thanks, CT

4 Replies

@CTheodlos That guidance is for tables in Word.  Excel cells can't be split.  You can merge them, but not split them.

Thanks @Savia 

Split cell

is same as

Unmerge cell

unmerge is there in the merge group

I have the exact same problem in trying to split cells. I would swear there was a tab on my IBM based computer. But, I am working on a MAC now and there is no layout tab for the cells nor an offer to split them. How can this be?