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.
0 Comments
Leave a Reply. |