Office & Email

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.

Set matching Outlook signatures in Outlook.com new Outlook classic Outlook and mobile, understand which signatures sync and which are local, copy a master signature, handle admin-managed signatures, fix logo images, and use different signatures for replies.

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.

Split Excel columns into first name last name address parts or other fields using Text to Columns, Flash Fill, TEXTBEFORE and TEXTAFTER formulas, handle middle initials and multiple delimiters, fix non-breaking spaces, and convert formulas to values.

Sort Excel rows by cell fill color font color or conditional-formatting icons, put one color on top, build multi-color sort orders, add normal sort levels inside color groups, and understand blank or uncolored cells.

View and restore previous OneDrive file versions, restore an entire OneDrive after widespread changes, check versions from Word Excel and PowerPoint, distinguish version history from Recycle Bin, understand retention differences, and know what restore affects.