Next, Right-click on the cell and choose the Format Cells option.Click on the cell name designation called “ SO”, which is shown in the below screenshot.
#How do you merge cells in excel on ipad how to
In this, there are four designations like SO, SR, ASM, RSM we will see how to unmerge it using the format menu as shown below. In this example, we are going to see how to unmerge the cells using the format menu.Ĭonsider the below example, which shows sales person monthly call and the names are aligned as per the designation.
Once we click on the merged cells, go to Home menu Tab there, we can notice that the “Merge & Center” Option is enabled.First, click on the cell named Sales which is shown in the below screenshot.In order to unmerge the cells, follow the below steps.
In the above screenshot, we can see that the Sales and Sales Efficiency rows are merged. In this example, we will see a step-by-step procedure of unmerging all the merged cells data. Once we click on unmerge cells, the word “Grand Total” will be in the left alignment. So as we can notice, the merged cell named grand total is in the center.
In Microsoft Excel, we have several shortcut keys for all functions. In Microsoft Excel, we can find the unmerge option under the Home menu Alignment group section “Merge & center” drop-down box, which is shown in the below screenshot. Excel functions, formula, charts, formatting creating excel dashboard & others