techsupportoffice

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.

Restrict editing in Word while keeping a document readable, allow read-only tracked changes comments or form filling, set exceptions for users, remove protection, understand Mac limits, and fix unavailable restriction controls.

Reuse PowerPoint slides by copying between presentations, choose destination theme or source formatting, use the Reuse Slides panel in perpetual Office versions, import entire decks, understand copied-slide independence, and note Microsoft 365 retirement of Reuse Slides.