Microsoft Office Productivity Tips: 25 Hidden Features

The quickest MS Office productivity gains come from small built-in features most people never find: shortcuts that paste plain text, fill a column for you or blank the screen mid-presentation. Below are 25 genuine hidden features across Word, Excel, Outlook and PowerPoint, each checked against Microsoft's own documentation. Most work in every recent version of Office. A few need Microsoft 365, and we flag those clearly.

Which MS Office Productivity Features Need Microsoft 365?

Most of the tips below work in any recent version of Office, including one-time-purchase Office 2024 and Office 2021. A few rely on Microsoft's cloud services or arrived only in newer releases:

If you're deciding between the two models, our guide to Microsoft Office vs Microsoft 365 explains what each gives you.

What Are the Best Hidden Features in Word?

Word's most useful hidden features handle formatting you would otherwise fix by hand. All the shortcuts below appear in Microsoft's Word keyboard shortcuts list.

1. Paste as plain text: Ctrl+Shift+V. Text copied from a website or email arrives without its fonts and colours and takes on your document's formatting instead.
2. Change case: Shift+F3. Select text and press it repeatedly to cycle between UPPER CASE, lower case and Title Case. It's ideal for headings typed with Caps Lock on.
3. Copy formatting only: Ctrl+Alt+C, then Ctrl+Alt+V. This copies the look of the selected text, not the words, and applies it elsewhere. Double-clicking the Format Painter button does the same thing for several places in a row.
4. The Spike: Ctrl+F3. Each press cuts the selected text and adds it to a special collection. Press Ctrl+Shift+F3 to paste everything you collected, in order. It's a quick way to pull scattered paragraphs into one place.
5. Reorder a document from the Navigation pane. Open View → Navigation Pane and drag a heading up or down. The whole section moves with it. This works only if your headings use Word's Heading styles, which our guide to adding a table of contents in Word also relies on.
6. Instant sample text: type =rand() and press Enter. Word inserts several paragraphs of placeholder text, which is useful for testing a template's layout before the real content is ready.
7. Dictate. Select Home → Dictate, then speak. Word types as you talk and handles punctuation commands such as "comma" and "new line". It needs a microphone and an internet connection.

Which Excel Shortcuts Save the Most Time?

Excel's best shortcuts take care of repetitive data entry and checking. They're all listed in Microsoft's Excel shortcuts reference.

8. Flash Fill: Ctrl+E. Type one example next to your data, such as a first name pulled from a full name, then press Ctrl+E. Excel spots the pattern and fills the rest of the column, with no formula needed.
9. Quick Analysis: Ctrl+Q. Select a range to open ready-made charts, totals, conditional formatting and tables you can preview before applying.
10. Today's date or time: Ctrl+; and Ctrl+Shift+:. These enter a fixed date or time that won't change the next time you open the file, unlike the TODAY() function.
11. Fill a whole selection: Ctrl+Enter. Select several cells, type a value or formula once, then press Ctrl+Enter to put it in every selected cell.
12. Show every formula: Ctrl+` (the grave accent key, usually under Esc). The sheet switches between results and the formulas behind them. It's the fastest way to audit a spreadsheet someone else built.
13. Lock a reference: F4. While editing a formula, press F4 on a cell reference to cycle through absolute ($A$1), mixed and relative versions. Outside a formula, F4 repeats your last action.
14. Workbook Statistics: Ctrl+Shift+G. You can also go to Review → Workbook Statistics. It counts the formulas, tables, charts and cells with data in the file, which helps you see why a workbook has grown so large.

For other Excel fixes, see our guides to freezing the top rows and repairing damaged workbooks.

What Hidden Features Does Outlook Have?

Outlook's hidden features cut down on repetitive email work. Several are easy to miss because they sit in menus rather than on the ribbon.

15. Out of office replies. In classic Outlook, go to File → Automatic Replies. In new Outlook, go to View → View settings → Accounts → Automatic replies. Set a date range so the reply switches itself off when you're back. Microsoft notes this isn't supported for Gmail, Yahoo or other POP/IMAP accounts.
16. Quick Steps. One click can run several actions together, such as marking a message as read, flagging it and moving it to a folder. In new Outlook, open the menu next to Quick steps on the Home tab and select Manage quick steps. You can also assign Ctrl+Shift+5 to 9 as shortcuts. Quick Steps can't be undone with Ctrl+Z.
17. Ignore a conversation. In classic Outlook, select a thread and choose Home → Ignore (Alt+H, X). The current messages and any future replies in that thread go straight to Deleted Items.
18. Schedule a message. Write an email now and have it sent tomorrow morning. Our step-by-step guide to delaying or scheduling an email in Outlook covers both classic and new Outlook.

Which PowerPoint Features Make Presenting Easier?

PowerPoint's best hidden features work during the slide show itself, when you can't stop to hunt through menus.

19. Black or white screen: B or W. Press B to blank the screen to black, or W for white, and press it again to come back. It pulls the audience's attention back to you during a discussion.
20. Jump to any slide: type its number and press Enter. Typing 12 and pressing Enter goes straight to slide 12, with no clicking through the slides in between.
21. Laser pointer and pen: Ctrl+L and Ctrl+P. Turn the mouse into an on-screen laser pointer or a pen for drawing on slides. Ctrl+A switches back to the normal arrow.
22. Morph transition. Duplicate a slide, then move or resize objects on the copy. Choose Transitions → Morph on the second slide, and PowerPoint animates the change smoothly.
23. Speaker Coach. Choose Slide Show → Rehearse with Coach to practise privately. You get feedback on your pace, filler words and whether you're just reading the slides aloud.

What Features Work Across Every Office App?

Two features work the same way in Word, Excel, PowerPoint and Outlook, which makes them worth learning first.

24. The Search box: Alt+Q. Press Alt+Q, type what you want to do ("insert page number" or "wrap text", for example) and run the command straight from the results. You don't need to know which tab it lives on.
25. Built-in photo editing. Office has no separate "MS Office photo editor", but its picture tools cover the basics. Select an image and choose Picture Format → Remove Background to cut out the subject, then use crop, corrections and artistic effects from the same tab. Vector images such as SVGs can't have their background removed.

A Common Mistake We See

People often look for these features in a version of Office that no longer gets updates. MS Office 2016 and 2019 reached end of support on 14 October 2025, and Office 2021 followed on 13 October 2026. They still open files, but they get no security fixes, and newer features such as Workbook Statistics or the latest Search box simply aren't there. Our Office end of support dates table shows where your version stands.

The other common blocker is an unactivated copy. When Office isn't activated, editing features become unavailable, so a shortcut that "doesn't work" may really be an MS Office activation problem. Check File → Account first. Our Office 2024 installation and activation guide walks you through fixing it, and our support team can help with activation.

Frequently Asked Questions

What is the most useful MS Office productivity shortcut?

For most people, it's Ctrl+Shift+V in Word, which pastes plain text without the source formatting, and Ctrl+E in Excel for Flash Fill. Alt+Q comes a close third because it works in every Office app and finds any command by name. Together they solve the most frequent everyday formatting chores.

How do I set an out of office message in MS Outlook?

In classic Outlook, select File, then Automatic Replies, turn on Send automatic replies, set the dates and type your message. In new Outlook, go to View, View settings, Accounts, then Automatic replies. This works with Microsoft 365, Exchange and Outlook.com accounts. It doesn't work with POP or IMAP accounts.

Does Microsoft Office have a photo editor?

Not a standalone one. Word, PowerPoint, Excel and Outlook all share the Picture Format tab, which can remove backgrounds, crop to a shape, adjust brightness and contrast, and apply artistic effects. It handles quick edits for documents and slides. Use a dedicated photo editor for detailed retouching or RAW photos.

Do these tips work in Office 2016 and Office 2019?

Most keyboard shortcuts do, and Office 2019 includes Morph. Workbook Statistics needs Excel 2021 or later, though, and Speaker Coach needs Microsoft 365 or PowerPoint for the web. Both Office 2016 and Office 2019 reached end of support in October 2025, so upgrading also restores security updates.

Why do some Office features not appear for me?

The three usual causes are an older Office version, Office not being activated, and features that need a Microsoft 365 subscription or an internet connection, such as Speaker Coach and Dictate. Check File, then Account, to confirm your version and activation status before troubleshooting anything else.

Conclusion

The best MS Office productivity gains come from a handful of shortcuts you'll use every day: plain-text paste, Flash Fill, the Search box and the slide-show keys. Learn five this week and add more as they become habits. If your current copy is out of support, browse our Microsoft Office licences for a current, genuine version.

Useful Links