Merging into one cell will keep the upper-left most data only.”Īnd if you click OK, merged cells would contain just the value of the top-left cell and as a result, entire other data will be removed. “The selection contains multiple data values. This is quite complicated as merging rows and columns in some cases causes data loss.Īs while trying to combine two or more rows in the worksheet by making use of the Merge & Center button ( Home tab > Alignment group), you will start getting the error message: One of the most common tasks that everyone needs performing now and then is merging rows and columns.īut the problem is that performing this is not an easy task and Excel does not provide any tool to do this. This is the reason Excel provides various useful functions to make the task easy for the users. Microsoft Excel is a very useful application and can be used for performing various tasks.
Does merging rows and columns in Excel seems a tough task for you to perform? Read this tutorial to learn different ways to merge rows and columns in Excel.
0 kommentar(er)
