Click on Insert and then go ahead and select Shift Cells Right.
![excel split cells under one cell excel split cells under one cell](https://helpdeskgeek.com/wp-content/pictures/2020/08/cell-split-in-excel.jpg)
Enter the number of columns or rows that you want to split the selected cells. Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.
![excel split cells under one cell excel split cells under one cell](https://www.spreadsheetsmadeeasy.com/static/153f99ff6840cbcbe17a9a529c852220/df498/split-cells-in-excel-featured-image.png)
Click in a cell, or select multiple cells that you want to split. How do I separate data in one cell into multiple rows Split cells. If you have data in the next cell, select the cell and right click on it. Under Cells, click Distribute Rows or Distribute Columns. The cell that contains the insertion point will become the top row of the second table. Open your Excel and open the database in which the Columns has to be separated. This can be useful for splitting long tables into two separate tables-mostly in hopes of dealing with formatting issues that multi-page tables can sometimes cause.įirst, click to place your insertion point in the cell where you would like your table split to begin. You can get just about as complicated with your table layout as you’d want. When we hit “OK” the table turns out just like you’d expect.Īnd obviously, this is just a quick look. We also want those cells merged before being split, so make sure that option is selected. In the Split Cells window, we’d select three columns and two rows. We’d head to Table Tools > Layout > Split Cells (a lot of times the Split Cells command doesn’t show up on the context menu when you have multiple cells selected, so it’s easier to use the Ribbon button). And we want to take those selected cells (the ones in gray under the second column header) and turn them into two big rows of three columns each. Let’s say we had a table like the one shown below. Input the number of rows and columns you would like to split your cell into.Īnd that cell we selected is now two cells.Īs you probably guessed from the options in that Split Cells window, you can also get a little more complex with cell splitting. You can just go ahead and click the “OK” button to make the split. By default, it’s set up to split the selected cell(s) into two columns, which is exactly what we want.
![excel split cells under one cell excel split cells under one cell](https://support.content.office.net/en-us/media/7fe4448d-f121-4850-a9de-b5198ee7affc.png)
(You can also head to Table Tools > Layout > Split Cells on the Word Ribbon if you prefer.) Then, right-click the selected cell and choose the “Split Cells” command from the context menu. Let’s first say that we just one to split a single cell into two cells. You can use the split command to one or more cells into a set number of rows and columns. Splitting table cells in Word is only slightly more complicated than merging them. If you prefer using Word’s menus, you can also head to the Table Tools “Layout” tab, and then click the “Merge Cells” button there. When you have your cells selected, right-click any of the selected cells, and then choose the “Merge Cells” command on the context menu.