September 2026

Freeze Excel top rows, first columns, or custom panes, choose the correct cell below and right of the locked area, unfreeze panes, use Split for independent scrolling, set freezes per worksheet, and use Print Titles for printed headers.

Group Excel rows manually or with Auto Outline, collapse and expand detail rows, create nested groups, use outline level buttons, group columns, ungroup selected levels, and clear outlines.

Fix duplicate emails in Outlook by removing duplicate account entries, checking POP leave-copy settings, reviewing rules that copy messages, restarting Outlook, using Clean Up Folder, resyncing mobile accounts, understanding forwarding, and avoiding risky cleanup add-ins.

Filter Excel data by text, numbers, dates, colors, and multiple columns, turn filters on and off, clear filters, use advanced OR criteria, convert data to Tables, add slicers, and read visible record counts.

Fix Excel #NUM errors caused by impossible calculations, negative square roots, oversized results, whole-column mistakes, IRR RATE and XIRR convergence failures, optional guesses, #VALUE differences, circular references, and Evaluate Formula.

Delay or schedule Outlook email delivery for one message, create a rule that delays every sent message, use Schedule Send in new Outlook and Outlook.com, understand classic Outlook needing to stay open, edit or cancel delayed mail, and add rule conditions.

Delete blank rows and remove duplicate rows in Excel using Go To Special, Delete Entire Row, Remove Duplicates, selected columns, duplicate highlighting, Excel Tables, undo precautions, and Google Sheets alternatives.

Use Dictate in Word to voice type documents, grant microphone permission, speak punctuation and commands, fix Dictate not starting, update Microsoft 365, select the right microphone, check internet access, use language settings, and control auto punctuation.

Create hanging indents in Word using keyboard shortcuts, the Paragraph dialog, exact 0.5 inch settings for MLA and APA references, default styles, the ruler markers, hidden tabs and spaces, and applying indentation to a full citation list.

Run Word mail merge for letters, labels, envelopes, and email using Excel or Outlook contacts, prepare source data, use the wizard, insert merge fields, preview records, fix wrong or blank fields, format merged dates and numbers, filter recipients, and use Mac Mailings tools.