
How to Remove Duplicate Rows in Excel
Use the Data tab's Remove Duplicates tool to delete repeat rows, and see why highlighting them with Conditional Formatting first is the safer move.
Everything tagged Microsoft Office.
5 articles

Use the Data tab's Remove Duplicates tool to delete repeat rows, and see why highlighting them with Conditional Formatting first is the safer move.

How to switch Word's built-in margin presets, set exact custom margins in inches, and apply the change to a whole document, one section, or just the pages ahead.

Step-by-step guide to building a PivotTable in Excel: insert it, drag fields into Rows, Columns, and Values, switch Sum to Count, and refresh after edits.

How to turn on Track Changes in Word, switch between All Markup, Simple Markup, and No Markup, accept or reject edits, and lock tracking with a password.

Learn the exact VLOOKUP syntax, see a real example, and fix the #N/A errors that trip up almost everyone the first time they use it.