The same will happen if you try to use Excel's Sort button in the Sort And Filter group of the Data tab on the ribbon. Similarly, you'll hit a wall if you try to paste data from an unmerged row to ...