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