Every now and then I have to reverse the order of a long list in Excel that is not in alphabetical or numerical order—a tedious job. Do you know of a shortcut? Yes, you can adapt Custom Lists, a tool ...

Click on Data in the toolbar and then on Sort , producing the screenshot at left. To reverse the order, click on Descending and then on OK . The process is different if each number is adjacent to, say ...