September 2026

Continue numbered lists in Word after paragraphs, images, tables, pasted text, or split sections, use Continue Numbering, Set Numbering Value, Restart at 1, and fix pasted list numbering.

Count colored cells in Excel with Find and Replace for one-time counts, use GET.CELL named formulas for live color codes, count with COUNTIF, save as .xlsm, and understand color as formatting rather than data.

Change Excel date formats with built-in and custom formats, use locale for non-US dates, create custom date codes, fix serial numbers and ##### dates, change regional defaults, and avoid date entry confusion.

Check Word word count in the status bar, count selected text, enable missing status bar word count, open the full Word Count dialog, include text boxes, footnotes, and endnotes, understand hyphen and punctuation counting, and track counts while writing.

Combine text in Excel with CONCATENATE, CONCAT, TEXTJOIN, and ampersand formulas, add spaces and punctuation, skip blanks, preserve date formatting with TEXT, fix #NAME errors, formulas showing as text, and use Flash Fill.

Change Word margins for a whole document or one section, use custom margin values, insert section breaks, add gutters and mirror margins for binding, switch inches and centimeters, set defaults, and handle printer margin warnings.

Change Word orientation for a whole document or one page, use section breaks before and after landscape pages, manage headers and footers with Link to Previous, keep page numbering continuous, and reveal section breaks.

Use Outlook color categories, rename and recolor category labels, apply categories to messages, create rules that auto-assign categories, search by category, sync categories across accounts, set Quick Click, and understand categories versus flags.

Change Word line spacing to single, 1.15, 1.5, double, or custom exact and multiple values, set paragraph before and after spacing, set defaults, meet MLA or APA spacing, fix pasted-text overrides, and use Show Hide paragraph marks.

Calculate Excel running totals with expanding SUM ranges, absolute references, Excel Tables and structured references, category-reset totals with SUMIFS, visible-row totals with SUBTOTAL, fixed references, and sorting precautions.