Word Table of Contents: The Real Reason Your PDF Shows Old Numbers
Word’s table of contents can look right on screen and still print wrong, because one printing setting most people never touch decides which version ships.
Excel REF Error: The Real Fix When Ctrl+Z Stops Working
Excel’s REF error looks fixable with Ctrl+Z, but that window closes the moment AutoSave commits the change, and most guides never explain what still works.
Why Data Validation Never Stops a Paste in Excel
A dropdown list looks locked down until someone pastes into it. Excel only checks typed entries, and a paste can even delete the rule itself, not just skip it once.
Why Typing 40 Shows Up as 4000% in Excel
Percentage formatting multiplies whatever’s stored by 100 for display. Type a plain number instead of the percent sign, and the math still runs, just on the wrong starting value.
Excel’s FILTER Function: The #CALC! Mistake Nobody Explains
FILTER’s #CALC! and #SPILL! errors look similar but mean opposite things: one is about nothing matching, the other is about matches with nowhere to land.
How to Unhide Rows in Excel (Row 1 Never Works the Normal Way)
The normal right-click method needs a visible row on both sides of the hidden one. Row 1 has no row above it, which is exactly why it needs a different fix.
Index Match Excel: The Real Reason It Survives a Column Insert
VLOOKUP trusts a number typed once and never rechecked. INDEX/MATCH searches for the column by name every time, which is the specific reason it survives an inserted column and VLOOKUP doesn’t.
XLOOKUP vs VLOOKUP: The Real Difference Nobody Mentions
XLOOKUP searches any direction and defaults to exact match. It’s also completely absent from Excel 2016 and Excel 2019, a compatibility gate most comparisons skip entirely.
The VLOOKUP Mistake That Breaks a Column With No Error
VLOOKUP’s col_index_num is a number typed once and never rechecked. Insert a column anywhere inside the range, and it silently returns the wrong value with no error at all.
Reading the Real Limit Behind Any AI Tool’s Free Plan
A monthly total is rarely the whole story. Two independently verified AI tools both show the same pattern: the real limit is a second detail the headline figure doesn’t mention.