Most people don’t know Excel has a voice, but it’s the best hidden auditing tool in the software. Instead of the error-prone back-and-forth between a paper invoice and my monitor, the Speak Cells feature narrates the data, helping me catch errors by ear that my eyes missed.
The science: Why your eyes lie to you
When you audit your own Excel work, you’re fighting a psychological glitch called the proofreader’s illusion. Because you already know what the data should say, your brain takes a shortcut—instead of seeing the 54 you actually typed, your mind sees the 45 you intended to type.
According to 2022 research, moving beyond silent reading significantly improves error detection. So, by using Excel’s voice to narrate the data, you create auditory feedback, which helps your brain bypass the visual autocorrect and process the information as a fresh stimulus. This makes it harder to ignore the mistakes your eyes have already decided to skip.
I use these 7 Excel shortcuts to find and fix spreadsheet errors in seconds
Don’t waste time browsing through Excel’s many menus to fix your spreadsheet.
Excel’s voice tools aren’t on the ribbon by default—you have to add them to your Quick Access Toolbar (QAT) manually. Right-click anywhere on the Excel ribbon, and if you see “Show Quick Access Toolbar,” click it. If you don’t see this option, it’s already activated.
Next, click the down arrow on the right of the QAT, and click “More Commands.”
Now, in the Choose Commands From menu, select “Commands Not in the Ribbon,” and scroll down to the following five commands, select them, and click “Add”:
- Speak Cells
- Stop Speaking
- By Rows (Speak Cells by Rows)
- Speak by Columns (Speak cells by Columns)
- On Enter (Speak Cells on Enter)
Single-click any command in the list, and type the first few letters of the above commands to jump to them quickly.
When you click “OK,” these icons appear at the top of your Excel window. Hover over them to see which is which.
Tuning the voice: The Control Panel secret
Before you get Excel to read your data for you, take a moment to adjust the voice. Crucially, you can’t do this inside Excel’s menus, as the tool relies on your computer’s speech properties. If you’re using Windows 10 or 11, type Text to speech in the task bar search field and look for the result that mentions the Control Panel to open the legacy Speech Properties dialog.
Mac users can find similar settings in the Spoken Content section of the Accessibility sidebar in the System Settings dialog.
Then, in the Speech Properties window, click the “Voice selection” down arrow to select your preferred voice, and click and drag the “Voice speed” slider to change the pace. For auditing, I usually bump up the speed slightly—a brisk pace keeps my brain from wandering during long lists. Click “Apply” to save your changes, but don’t close the dialog box yet.
Now, head back to Excel, type some numbers into cells A1 to A5, select cell A1, and click the “Speak Cells” icon on your QAT to test your new properties.
Adjust the settings in the Speech Properties dialog as needed, clicking “Apply” after each change, and only close it once you’ve settled on the perfect setup.
This Windows 11 Feature Reads to Me So I Can Relax (or Multitask)
Give your eyes a rest.
Scenario A: The instant confirmation
The most instant win with the Speak Cells tool is using Speak on Enter for live data entry. This is a game-changer if you’re working from a stack of paper receipts or a physical ledger and don’t want to keep glancing up at your monitor.
To start, click the “Speak on Enter” icon you added to your QAT. You’ll hear a confirmation that says, “Cells will now be spoken on Enter.”
Now, you can keep your eyes locked on your source document and keyboard as you type your data in columns. Every time you press Enter, Excel reads the value back to you, creating an instant audio safety net. If your fingers slip and type 54 while your eyes see 45 on the paper, your ears will catch the discrepancy immediately.
Click “Speak on Enter” again once you’ve finished, and Excel will audibly tell you that the feature is turned off.
Scenario B: The hands-free audit
Suppose you’ve already finished typing a long list into your Excel spreadsheet and need to verify it against a paper printout. In this scenario, the batch-audit mode is your best friend. Instead of playing visual ping-pong, you can lean back and let Excel do the reading while you follow along on your source page.
First, select the top-left cell of the data range if it’s contiguous or in a table, or select the range manually.
Next, click “Speak by Rows” or “Speak by Columns,” depending on how you want the data read to you. In the example below, I want Excel to read the month and profit for the first row, then the month and profit for the second row, and so on, so I’ll select “Speak by Rows.” Then, click “Speak Cells” to start the narration.
Ensure your cells have the correct number formatting. For example, if you format monetary values as Accounting, Excel will say, “One hundred twenty-three dollars and fifty cents,” making the audio more natural and easier for your brain to process.
Click the “Stop” icon or press Esc to cancel the process.
How to Turn a Screenshot Into Excel Data
You don’t have to copy the data manually!
Pro tips for using Speak Cells in Excel
Once you’ve mastered the basics of the Speak Cells tools, a few subtle workflow tweaks can transform Speak Cells from a neat trick into a professional-grade auditing system:
- Audit non-contiguous data: If you only want to audit specific, non-adjacent columns (rather than the whole sheet), hold Ctrl and select them individually. However, you need to select them in reverse order because Excel begins reading from the active cell (the last one you selected).
- The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them entirely. This is perfect for auditing subtotal rows only without having to hear every single line item in a 500-row list.
- The headphone rule: This isn’t a technical tip, but a social one. Excel’s voice can be jarring in an open office environment, so use headphones. Not only does this keep your coworkers happy, but it also helps you to block out the background noise and focus on the audio feedback.
Now that you’ve mastered Excel’s voice, keep your momentum going by sharpening your other auditing skills. For example, you can find hidden errors with the Go To Special tool or make your logic easier to follow by improving your formula readability.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.
