If you don't want to leave the column of random numbers in your spreadsheet once it's sorted, you can delete or hide it. Add a new column of random data if you want to randomize the order of the ...

How to Reverse a Column Order in Microsoft Excel. Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Q. I often recruit Excel to do double duty as a database, and there are times I’d like to reverse the order of numbers or names in a table. How can I do that? A. In other words, you want to take a ...

SEE: How to use Find All to manipulate specific matching values in Excel (TechRepublic) Listing A shows a macro that automates the simple two-column sort that we ran in the last section.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.