techsupportoffice

Insert PDFs into Word as editable converted text or fixed embedded objects, understand Windows and Mac limitations, insert PDF pages as images, display as icon, handle scanned PDFs and OCR, and choose the right method.

Insert Word section breaks, choose Next Page Continuous Even Page and Odd Page breaks, use sections for margins orientation columns headers and footers, show and delete section breaks, unlink headers, and restart page numbering.

Insert signatures in Word as handwritten signature images, crop and make backgrounds transparent, save signatures to Quick Parts, add formal signature lines, use digital signatures with certificates, sign PDFs, and understand Mac limitations.

Insert a built-in Word cover page, replace placeholders, remove or swap cover pages, make a manual title page with section breaks, use themes, save custom cover pages to Quick Parts, and add automatically updating dates.

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.