Thirdly, from the drop-down select the option “Unmerge Cells”.Secondly, go to the Home Click the option “Merge & Center” from the ribbon.To select multiple merged cells just hold the Ctrl key and select the cells with the “left-click” of the mouse. So, let’s see how we can unmerge these cells by following some simple steps. If we take a look at the dataset we will see merged cells in the columns named “Country” and “Position”. To demonstrate this method to you we have the following dataset of football players, their countries, and playing positions. This will help you to differentiate one method from another which will give you a better insight.įirst and foremost, we will see how to unmerge cells in excel with the use of an excel ribbon. While describing the methods of this article we will use the same dataset for all the methods.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |