However, data may not be in alphabetical or numerical order, so applying the sort function directly to the data will rearrange the records, rather than simply reverse them. As an example ...

Excel can sort data in a spreadsheet in alphabetical or numerical order. Often, you'll just want to sort all of the data in a spreadsheet except for the header by the values in a certain column.

Click on Data in the toolbar and then on Sort , producing the screenshot at left. To reverse the order ... numbers 1 to 5 resorted—not the names—click on Continue with the current selection . Notice ...