![how to quickly merge cells in excel how to quickly merge cells in excel](https://i.ytimg.com/vi/XkmIhBy8qKU/maxresdefault.jpg)
This is also another method by which we can easily merge cells and keep all data in excel.
#How to quickly merge cells in excel how to
How to merge cells and keep all data by another method.
![how to quickly merge cells in excel how to quickly merge cells in excel](https://i0.wp.com/static.makeuseof.com/wp-content/uploads/2020/07/excel-combined-cell-paste-670x475.png)
In the below image you find that there is a database in an excel sheet of first names and last name which will use to merge cells and keep all data in excel.įirstly, we will use merge and centre method to find merge cells and keep all data in excel.ġ) The first step is to make specified data in excel where we perfume further.Ģ) After that on the top of spreadsheet the HOME ribbon is showing click on it several more options will appear then click merge and centre, when you click on it more option will pop up click on merge cells but before clicking on merge select the cells which you want to merge.ģ) The third step is that when you click on merge cells the selected data will merge automatically like this. You cannot merge two cells in Excel using the Merge & Center command without erasing data. I'll outline many methods in this article for merging two cells in Excel without erasing any data.