#Excel

Excel now has a real cell checkbox that returns TRUE or FALSE. Here is how to add it in Microsoft 365, plus the classic Developer method for older versions.

INDEX MATCH is Excel's flexible lookup: MATCH finds the row, INDEX returns the value. Learn the formula, the match_type rules, and error handling.

Excel for Windows imports PDFs natively through Data > Get Data > From File > From PDF. Here is that route, plus Acrobat, Tabula, and fixes for scans.

Merge & Center sits on Excel's Home tab, but it deletes data and breaks sorting. Learn the three ways to merge, how to unmerge, and the safer way to center a title.

Highlight duplicates in Excel with Conditional Formatting, catch repeats across two columns or whole rows with a COUNTIF-based rule, and clear the color when done.

Compare two Excel columns for matches or differences using Conditional Formatting, a simple formula flag, COUNTIF or MATCH, and Go To Special row differences.

Recover an unsaved Excel workbook from the Document Recovery pane, Recover Unsaved Workbooks, the AutoRecover folder, or OneDrive version history.

Three ways to use AI in Excel: paid Copilot writes formulas and analyzes data, free Analyze Data finds trends, and ChatGPT explains any formula.

Excel keeps freezing or showing not responding on Windows? Fix it fast: Safe Mode, add-ins, hardware acceleration, Office repair, and heavy files.

Every Excel cell is locked by default, but that setting does nothing until you protect the sheet. Here's the two-step process to keep specific cells editable.