We're all familiar with Excel's fill handle: type "Monday," drag the corner, and the rest of the week appears. But there's a hidden gem many people overlook: Custom Lists. Show Excel a pattern once, ...

The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...

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. Sorts are a ...

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula. Lists are a fundamental part in almost any Microsoft Excel ...

In this article, we will show you how to create, delete, and use a Custom List in Microsoft Excel. The Custom List feature is useful for users who have to type a specific list in every Excel ...

For data nerds, Excel's drop-down lists are a lovely gift. They keep entries consistent across multiple rows — no misspelled words or names written without capitalization. Drop-down lists are ...

One of the most common functions in an Excel spreadsheet is sorting data alphabetically. This feature is extremely helpful for organizing lists of names, cities, and more. While there are several ways ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...