To fulfill this task, you need to perform the following steps: Just don't merge the cell that needs to be split. In our examples, the cells above and below.
![split cells in excel split cells in excel](https://www.excel-easy.com/examples/images/split-cells/change-column-widths.png)
Thus, in order to split a certain cell in two, you need to merge the neighboring cells. The first, third and fourth columns in this table consist of one column each. The cells above and below the “split” one are merged in horizontal direction. The line does not separate one cells it showcases the border between two. Let us have a closer look at this table on the Excel spreadsheet. But what if we need a table that looks like this: It's not possible to split an individual cell that hasn't been merged. You will have to complete the edit first and press «Enter» to leave this mode. If one or more cells in the selected range are being edited, the merging button may be unavailable. If you only need to merge the rows in the selected range of values, use the tool «Merge Across».You can even merge a group of neighboring cells in vertical and horizontal directions simultaneously.Likewise, you can merge several cells vertically (a column of data).So, if you need to retain all the data, then move it to the top left cell in our case, it's not necessary. When the two cells are merged, only the data contained in the top left one is retained.Select the cells that need to be merged.To merge the cells, use the «Alignment» tool, which can be found on the main tab.Let's take a small table with several rows and columns.The information appears in the center of the merged cell. The result will be one cell occupying two rows or columns simultaneously. Neighboring cells can be merged in vertical or horizontal direction. You can write to us if you need support or help with any particular feature or program of office 365 or other Microsoft programs.How to merge cells in Excel without losing data? Hopefully, the article has assisted you to resolve your query. Now you can see that the text of a cell has separated into multiple columns.Once you are done click the “Finish” button from the bottom of the window. In this window, you can select the format for each column by selecting from the column data format.Click “Next” for the next setting levels for selecting the data format for each column. And to move a break line click and drag it. To delete the break line double click on the link. To create the break line click on the desired position. Another window will appear in which you can adjust the break line between the words.Then click “Next” to adjust the break line. A window to convert Text to Columns will appear, choose the file type that describes your data if it has characters like commas or tabs separating each field or its fixed width of space between each word.Click the “Text to column” button from the ribbon above the excel sheet, where all the functions are given.
![split cells in excel split cells in excel](https://cdn.extendoffice.com/images/stories/doc-excel/google-sheet-split-cell/doc-kutools-split-cells-1.png)
![split cells in excel split cells in excel](https://www.exceldemy.com/wp-content/uploads/2018/03/Unmerge-2.png)
![split cells in excel split cells in excel](https://yodalearning.com/wp-content/uploads/2017/06/Solution-Split-data-in-Excel-1024x509-768x382.jpg)
The option of “Merge & Center” under the Home tab, allows users to merge two cells together and then unmerge them on a cell that has merged with another cell. There are two different functions that enable users to split a cell.