How to sort data with merged cells in Excel

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. Actually, there is no method for you to sort data with merged cells directly. You need to unmerge all merged cells at first and then sort the list. This vedio will introduce several tricks for you. You can follow the step-by-step guide via the following hyperlink: https://www.extendoffice.com/document...