This will open the ‘Find and Replace’ dialog box
With the cells selected, hold the Control key and press the F key (or Command + F if you’re using Mac). Select the range that has the cells that you want to unmerge. You can use the ‘Find and Replace’ feature in Excel to quickly find out all the merged cells, select only the ones that you want to unmerge and then quickly unmerge these. 
Find All the Merged Cells in the WorkbookĪll the methods covered so far would unmerge all the merged cells in the selection.īut what if you want to go through these merged cells and manually unmerge some of those (and not all). Now, if you want to use this I can with a keyboard shortcut, simply hold the Alt key and press that number key. Hold the ALT key and you would see a number below that icon.
#How to merge cells in numbers for mac pro
Pro tip: When you add an icon to the Quick Access Toolbar, you can also access it using a keyboard shortcut.
Now when you have to unmerge cells in Excel, just make the selection and click on this icon in the QAT. The above steps would add the ‘Merge & Center’ icon to the quick access toolbar. Click on the ‘Add to Quick Access Toolbar’ option.In the Alignment group, right-click on the ‘Merge and Center’ icon.This way you can get the work done with a single click (as the quick access toolbar is always visible).īelow are the steps to add the Merge & Center button to the quick access toolbar: Adding the UnMerge Option in the QAT (One-click Unmerge)Īnother way to quickly unmerge sales in your worksheet is to add the Merge & Center button to the Quick Access Toolbar (QAT). This is a toggle button that is also used to merge cells (where you can simply select the cells that you want to merge and then click on this icon).
Note that the original value that was there in the merged cells goes to the top cell and the rest of the cells are empty. The above steps would instantly unmerge all the merged cells from the selection.
In the Alignment group, click on the ‘Merge & Center’ icon. Select the cells/range from which you want to unmerge cells. Suppose you have the dataset as shown below and you want to unmerge the merged cells in Column B.īelow are the steps to quickly unmerge these cells in Excel: You can undo this by using Control Z, or simply using the keyboard shortcut again.Īnother equally fast way to unmerge cells in Excel is to use the Merge & Center option in the ribbon. In case there are no merged cells in the selection, Excel will merge all the cells. If you have any text in the merged cells, when you unmerge these cells, all the text would go to the top-left cell in that group of merged cells that have now been unmerged. The above shortcut would instantly unmerge all the merged cells in the selected range.Ī few things you need to know when unmerging cells in Excel: Press each of these keys in succession (one after the other). You can choose a specific range of all cells (from which you want to unmerge cells), or you can select the entire worksheet and then unmerge all the merged cells from the entire sheet.īelow is the keyboard shortcut to unmerge cells in Excel: ALT + H + M + C The fastest way (at least for me) to unmerge cells in a worksheet is to use a keyboard shortcut. Unmerge Cells and Fill the Blank Cells with the Original Value. Find All the Merged Cells in the Workbook. Adding the UnMerge Option in the QAT (One-click Unmerge). Unmerge Cells using Option in the Ribbon.
0 kommentar(er)
