In the small example spreadsheet, that's exactly what we have. Splitting a cell into multiple rows can be helpful if you need to break out data such as names and titles. In this guide, we'll show you how to split cells in Microsoft Excel in a few easy steps. Splitting a cell into multiple cells is one such task, and it can be helpful when you need to clean up a spreadsheet full of data. Sometimes, you have something very simple that you need to accomplish.