Office & Email

Create Excel drop-down lists that grow automatically using Tables or dynamic named ranges, use Data Validation, sort or filter source lists, remove blank choices, and troubleshoot list sources that do not update.

Insert Word page numbers, skip numbering on the cover page, start page 2 as page 1, restart numbering by section, use roman numerals for front matter, refresh page-number fields, and fix Link to Previous problems.

Link cells between Excel workbooks with external references, create links by clicking open workbooks, update values, change source paths, break links into static values, respond to update prompts, avoid moved-file errors, use stable shared locations, and paste values for snapshots.

Insert Excel data into Word as editable tables, linked Excel objects, or embedded spreadsheets, choose paste options, update links, avoid broken source paths, manage wide tables, compress workflow, and understand Mac object limits.

Insert automatic Word tables of contents from Heading styles, create custom TOCs, control heading levels and page numbers, fix missing headings, update tables with F9, remove TOCs, and modify TOC styles.

Create a Word table of figures by adding captions first, choosing Figure Table or Equation labels, inserting the table with page numbers, updating fields, making separate lists, modifying styles, renumbering captions, and refreshing before PDF export.

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.