Last update: January 2020
Here’s a question that we have received from a reader who wanted to divide a column vertically:
I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value file into the A column and now need to split a column cell vertically into two “halfs”. Any simple way to get that accomplished? If it helps i am using Windows 10.
Thanks for the good question. For these scenarios i typically use the Text to Column feature, which serves my purpose pretty well. See below the full details.
Here’s how to vertically split cells in Excel (we have also a post covering dividing text into columns on Excel 2016 and 2019):
Once you are done, click on OK and now you get the cells split as you specified.
Unlike when working with tables in Microsoft Word, PowerPoint and Outlook; there is no straightforward Split command for achieving horizontal splits in Excel cells. Readers having use cases about horizontal splitting could use specific formulas to divide their table data across two or more table cells in their worksheet.