Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the information, if you want to sort it alphabetically.

Your Excel spreadsheets may contain contact information that you'd like to store in one of these applications. By configuring your spreadsheet, you can convert it into a comma-delimited contact ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

How do I automatically sort Excel by color? All you have to do is click on the AutoFilter arrow located next to the column heading you want to sort, then choose Sort by Color via the dropdown menu.