#Spreadsheets

VLOOKUP in Google Sheets, with the exact syntax and a working example. Plus how to pull from another sheet, fix #N/A, and when to use XLOOKUP instead.

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.

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.

Excel's View tab has one Freeze Panes menu that locks the top row, the first column, or any block of rows and columns you pick while the rest scrolls.

Learn how to wrap text in Excel with the Wrap Text button, add a manual line break with Alt+Enter, and fix cells where wrapped text still gets cut off.