September 2026

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.

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.

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 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.

Set and clear Excel print areas, add extra ranges, replace or extend a print area, fit a worksheet to one page, repeat header rows, use Page Break Preview, adjust margins, and understand sheet-specific print settings.

Set Outlook Automatic Replies in desktop and web Outlook, create internal and external messages, schedule start and end times, use a rule workaround for IMAP or POP accounts, configure mobile replies, and troubleshoot missing or repeated replies.

Share PowerPoint presentations as live OneDrive or SharePoint links, set view or edit permissions, send file copies as PPTX or PDF, use expiration and passwords, coauthor live, and record or export presentations as video.

Snooze emails in new Outlook Outlook.com and Outlook mobile, choose preset or custom return times, use flags and reminders in classic Outlook, snooze multiple messages, find snoozed mail, cancel snooze early, and compare Snooze with Focused Inbox.