Isolating each piece of data and then inserting it into Excel in alphabetical order can make the task take many times as long. Fortunately, there's a handy feature that helps you avoid this headache.

Right-click the column letter of the column you want to sort, and select "Insert" to create a new column. Enter "1" in the first cell of the new column and "2" in the second cell.

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 ...