The guidebook / 61 guides
Documents & desktop
Everyday files and computer tasks. Source-linked checks to help you move forward.
Excel SUM returns zero: check numeric text before converting the range
Inspect the exact SUM range, test numeric versus text values and compare a helper-column conversion before replacing original Excel data.
Change a Word table of contents font without changing body headings
Use Word’s TOC level styles and From template control, distinguish layout settings and check formatting after updating and reopening the document.
Remove Extra Space Before or After Paragraphs in Google Docs
Check paragraph Before and After values, distinguish line spacing and page gaps, and choose whether to update Normal text defaults.
Bring Text in Front of a Picture in Google Slides
Select the intended object, distinguish one-step movement from front or back, and verify that no other content was covered.
Link Text to a Specific Paragraph in Google Docs with a Bookmark
Place a bookmark at the intended target, link the source text, and verify the destination rather than linking only to the document.
Allow Unlisted Values in a Sheets Dropdown Without Removing the List
Change the intended validation rule, check its range, and distinguish accepting an exception from adding it to the allowed options.
Remove a Google Drive Shortcut While Keeping the Original File
Identify the shortcut, check its target and permissions, remove only that item, and verify the original still opens.
Make Google Slides Letter Portrait: Check Width, Height and Units
Enter the intended dimensions instead of swapping a widescreen ratio, then inspect every slide and the print preview.
Change Where Mac Screenshots Save and Check the Actual File
Use Screenshot Options for future captures, distinguish clipboard-only shortcuts, and verify a saved file instead of assuming a backup.
Filter Google Sheets Without Changing What Other Editors See
Choose the right filter scope, verify the data range, and distinguish a saved view from a temporary view or access restriction.
Rename Multiple Files on Mac: Replace Text, Add Text or Number Them
Select the intended files, choose a clear naming rule, preserve extensions, and verify the renamed items before assuming sync is fixed.
Gmail Undo Send: Set the Cancellation Window and Know Its Limit
Understand the documented 5–30 second cancellation choices, verify the saved setting, and avoid treating it as later recall.
Split Comma-and-Space Lists in Sheets Without Splitting Every Space
Use the full delimiter, preserve empty fields when needed, and check the output without changing the source list.
Replace One Whole Word in Word and Review the Actual Matches
Read the exact fields, case and word scope, replace a verified match first, and reopen the saved copy.
Google Docs Word Count Different? Check Selection and Excluded Text
Read the counting scope and unit, account for footnotes separately when required, and preserve the original document.
Excel Shows a Formula as Text? Separate Display Mode from Cell Format
Check Show Formulas, then General format and re-entry for an intended formula; verify the saved result before changing a range.
Correct Words Underlined in Word? Check the Passage’s Proofing Language
Inspect the selected text’s dictionary, regional language and checking exclusions without changing unrelated multilingual text.
Google Slides Opens but Audio Requests Access? Check the Source File Too
Separate presentation permission from media access, review the access checker and verify playback for the intended recipient.