techsupportoffice

Use HLOOKUP for horizontally arranged lookup tables, understand lookup value table array row index and exact match, fix #N/A and #REF errors, rank numbers with RANK or RANK.EQ, handle ties, and compare INDEX MATCH and XLOOKUP alternatives.

Unsubscribe from newsletters in Outlook with the built-in unsubscribe button or sender links, block suspicious senders, use Sweep or Clean Up, understand CAN-SPAM expectations, and know when not to click unsubscribe links.

Update Word tables of contents after editing, refresh the full TOC or page numbers only, fix missing headings, use F9 shortcuts, update fields before printing, and recognize TOCs converted to plain text.

Use dollar signs in Excel formulas to lock cell references, switch between relative absolute and mixed references with F4, use named ranges, lock lookup tables, repair copied formulas, and know when absolute references matter.

Unmerge one or all merged cells in Excel, understand where merged-cell content goes, fill blank cells after unmerging, find merged cells, fix sorting errors, and use Center Across Selection instead of merging.

Turn off Outlook Automatic Replies in desktop web Mac and mobile Outlook, understand sync between web and desktop, schedule end dates, find rule-based auto-replies, and troubleshoot replies that do not stop or do not send.

Unhide specific hidden Excel rows, unhide all rows at once, restore hidden row 1 with the Name Box, distinguish hidden rows from filters or grouped rows, and fix rows with near-zero height.

Translate an entire Word document or selected text with Word Translator, create a separate translated copy, insert or copy translated selections, set default translation languages, understand online-service requirements, and review machine translation for important documents.

Transpose Excel rows to columns or columns to rows using Paste Special or the TRANSPOSE function, preserve formatting, use dynamic arrays, fix array-size and #SPILL errors, and avoid pasting over the original data.

Sort Excel data by text numbers dates and multiple columns, avoid scrambling rows, use Expand the selection, fix text-formatted dates, sort by color or icons, create custom sort lists, and use Tables for safer repeated sorting.