#MERGING CELLS IN EXCEL KEEOING DATA INSTALL#

You can see all merged cells are unmerged and filled the unmerged cells with duplicate values.Ģ. Select the list you need to sort with merged cells, then click Kutools > Merge & Split > Unmerge Cell & Fill Value.

#MERGING CELLS IN EXCEL KEEOING DATA INSTALL#

Please do as follows.īefore applying Kutools for Excel, please download and install it firstly.ġ. You can easily unmerge cells in selected range without losing any data with the Unmerge Cell & Fill Value utility of Kutools for Excel. And after sorting, you can merge the same cell again if you need. You can see all blank cells are filled with the value above.ĥ. Please type a = mark into the Formula Bar, and then reference the cell which locates above the first blank cell, and then press the Ctrl + Enter key simultaneously. In the Go To Special dialog box, select the Blanks option, and then click the OK button.Ĥ. Keep the range selected, then click Find & Select > Go To Special under Home tab.ģ. Now you can see blank cells existing in selected range. Select the list with merged cells you need to sort, then click Home > Merge & Center to unmerge the selected merged cells. You can unmerge all merged cells at first, then go ahead to sort the list. Sort data with merged cells by Kutools for Excel

Sort data with merged cells by unmerging all cells first This article will introduce several tricks for you. You need to unmerge all merged cells at first and then sort the list. If merged cells existing in a list, you will get a prompt box while sorting the data of this list as the left screenshot shown.Īctually, there is no method for you to sort data with merged cells directly.

Merging cells in excel keeoing data