Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

By using the Highlight Cells Rules, you can highlight duplicate cells in your Excel worksheet to avoid confusion and mistakes.

Excel will then place a dotted line around the selected cell or cells to let you know that something has been copied (in this case, the formatting), and your cursor will change to a paintbrush icon.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Notice, too, that Excel also added the word [Group] to the title bar to alert you that you have a group of worksheets selected; as you’ll see, that alert is important. Now make your changes to the ...