Let’s say you have a student gradebook file open in Excel and it contains information for the students in your class. As you look through the students’ grades, you highlight the names of students to ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...

Whether you are generating lottery numbers or sample data for a survey, random numbers are easy to create in Excel. While true randomness is difficult to simulate with software, Excelâ s random ...

It's easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the "Sort" feature. You can also alphabetize in Excel using shortcuts found in the "Data" or "Home" tabs. One of ...