How to Compare Two Columns in Excel to Find Matches
Compare two Excel columns for matches or differences using Conditional Formatting, a simple formula flag, COUNTIF or MATCH, and Go To Special row differences.
6 min read
#Microsoft Office
Everything tagged Microsoft Office.
7 articles
How to remove a blank page in Word
Turn on formatting marks with Ctrl+Shift+8, then delete the stray paragraph mark, page break, or section break, plus the 1-point trick for a table's blank page.
6 min read
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.
5 min read
How to Change Margins in Microsoft Word
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.
5 min read
How to Create a Pivot Table in Excel
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.
4 min read
How to Track Changes in Microsoft Word
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.
5 min read
How to Use VLOOKUP in Excel (With a Working Example)
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.
6 min read