If you see You can't change part of an array error while trying to use the Sort, Delete, Edit, or some other feature in Microsoft Excel, see this post.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Knowing how to alphabetize in Excel can be a real time-saver. Here, we look at how to alphabetize columns (and even rows) in an Excel spreadsheet.

Learn how to fill blank cells in Excel effortlessly with dynamic array functions like SCAN, REDUCE, and LAMBDA. Handle Excel blank cells with ...

How I made this great-looking table in Excel Excel provides some powerful formatting tools to help you produce visually compelling tables. Follow along to see how I created mine.

Microsoft Excel has hundreds of tools that you can use to make your spreadsheets tick. However, if you're looking to level up your expertise, get to know these six essential features today.