Guides

Word & Excel fixes, explained step by step

Short, practical guides for the specific problems people search for โ€” each one links straight to the fix.

Word

How to remove a blank page at the end of a Word document

Why Word won't let you delete it from the ribbon, and what's actually causing it.

Excel

Excel scrollbar goes on forever? Here's how to fix the used range

The phantom "used range" problem that inflates file size and breaks navigation.

Word

How to remove tracked changes from a Word document

Accept every insertion and delete every removal in one pass, without opening Word.

Excel

How to unhide all sheets in Excel at once

Skip the right-click-per-sheet routine, including "very hidden" sheets.

Excel

How to fix "too many different cell formats" in Excel

Why the error keeps coming back, and how to deduplicate cell styles for good.

Excel

Why is my Excel file so large? (Pivot tables are usually why)

Pivot table caches are hidden duplicate copies of your source data.

Excel

Excel conditional formatting rules duplicated? Here's the fix

Why duplicates accumulate, and how to clear them out safely.

Word

How to reduce a Word document's file size

Unused style definitions and embedded fonts are the usual culprits.

Word

How to force Word's table of contents to update automatically

Make it refresh itself on open, instead of relying on F9.