Office & Email

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.

Save a PowerPoint deck as a reusable .potx template, clean slide content first, make templates appear in File New, use Slide Master, share template files with a team, update existing templates, and keep backups.

Remove blank cells from an Excel column by shifting values up, sort blanks to the bottom while preserving rows, use FILTER to make a clean non-blank list, handle formulas returning blanks, and avoid misaligning neighboring columns.

Use TRIM in Excel to remove leading trailing and repeated spaces, use SUBSTITUTE to remove all spaces, handle non-breaking spaces with CHAR(160), use Flash Fill for short cleanups, and compare text lengths to find hidden characters.

Remove one hyperlink or all hyperlinks in Word, keep the visible text, clear leftover blue underline formatting, disable automatic hyperlink creation, paste without links, and remove links inside tables or lists.