Office & Email

Hide Excel formulas with hidden and locked cell protection, protect sheets with passwords, unlock input cells, show all formulas with the formula-view shortcut, print formulas, understand protection limits, and compare Google Sheets protected ranges.

Highlight top or bottom values in Excel with Conditional Formatting, change top 10 to any number or percent, highlight whole rows with LARGE formulas, extract top values with LARGE, expand Applies To ranges, combine with color scales, and use Google Sheets custom formulas.

Insert checkboxes in Excel using the new Microsoft 365 cell checkbox or the Developer tab Form Control method, link checkboxes to TRUE/FALSE cells, count checked boxes, edit labels, copy controls, and handle older Excel versions.

Fix Excel #REF errors by undoing deleted references, manually rebuilding broken formulas, using version history and backups, finding #REF in formulas, avoiding fragile OFFSET formulas, using Trace Dependents, fixing chart ranges, and saving values before major restructuring.

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.