![]() ![]() ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |