You can miss visual typos when reviewing large data sets in Excel. The Text-to-Speech feature reads your cell contents aloud, letting you hear discrepancies. This article explains how to add the feature to your ribbon and use it to verify data.
Key Takeaways: Using Excel’s Text-to-Speech Feature
- Quick Access Toolbar > Speak Cells: Adds a permanent button to read selected cells aloud from left to right.
- Speak Cells on Enter: Reads the contents of a cell automatically after you press Enter, ideal for row-by-row data entry.
- Stop Speaking button: Halts the speech playback immediately, which is useful for correcting an error as soon as you hear it.
What Excel’s Text-to-Speech Feature Does
Excel’s Text-to-Speech tool converts the text and numbers in your worksheet into spoken audio. It uses the default voice installed on your Windows system. The feature is designed for proofreading, not for creating audio files. You must add its commands to your interface before you can use it.
The tool reads data in the order you specify. You can have it read cells by rows or by columns. It will read dates, times, and formulas as they are displayed in the cell. The speech continues until it reaches the end of the selected range or until you stop it manually.
Prerequisites for Using Text-to-Speech
Your computer must have speakers or headphones connected and turned on. The feature is available in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016. It is not available in Excel for the web or Excel for Mac. You also need a compatible text-to-speech voice installed via Windows Settings.
Steps to Add and Use Text-to-Speech Commands
The Text-to-Speech commands are not on the standard ribbon. You must first add them to the Quick Access Toolbar or a custom ribbon tab.
Adding the Commands to the Quick Access Toolbar
- Open the Customize Quick Access Toolbar menu
Click the small down arrow at the far right end of the Quick Access Toolbar, located above the ribbon. - Select More Commands
This opens the Excel Options dialog box focused on customizing the Quick Access Toolbar. - Choose commands from the All Commands list
In the left dropdown menu, select “All Commands.” Scroll down the list to find the speech commands. - Add the key commands
Select “Speak Cells” and click the “Add >>” button. Repeat for “Speak Cells – Stop Speaking,” “Speak Cells by Columns,” and “Speak Cells by Rows.” Click OK to save.
Using the Feature to Proofread Data
- Select the data range to check
Click and drag to highlight the cells you want Excel to read aloud. - Choose the reading direction
Click the “Speak Cells by Rows” or “Speak Cells by Columns” button on your Quick Access Toolbar. This sets the order. - Start the speech playback
Click the “Speak Cells” button. Listen carefully as Excel reads each cell’s content. - Stop the playback when needed
Click the “Speak Cells – Stop Speaking” button to halt the audio at any time.
Enabling Speak on Enter for Data Entry
- Add the Speak on Enter command
Follow the steps above to add “Speak On Enter” from the All Commands list to your Quick Access Toolbar. - Activate the feature
Click the “Speak On Enter” button once to turn it on. The button will appear highlighted. - Enter data as normal
Type a value into a cell and press Enter. Excel will immediately read the entered value back to you. - Deactivate the feature
Click the “Speak On Enter” button again to turn it off when you finish your data entry session.
Common Mistakes and Limitations to Avoid
Excel Does Not Read Any Cells Aloud
First, check your system volume and ensure speakers are working. Verify you have selected a range of cells before clicking the Speak Cells button. The feature will not read from charts, images, or objects. Ensure you added the correct commands to your toolbar and are clicking the “Speak Cells” button, not just the direction button.
Speech Reads in the Wrong Order
The reading order is determined by the last direction button you clicked. If you want to read by columns, click “Speak Cells by Columns” before clicking “Speak Cells.” The feature remembers this setting until you change it. The selection direction also matters; it reads from the top-left cell of your selection to the bottom-right.
Feature is Grayed Out or Missing
The Text-to-Speech feature is not available in all versions of Excel. Confirm you are using a supported desktop version for Windows. If the commands are added but grayed out, check if your workbook is in Protected View or if cell editing is locked on a protected sheet. The feature requires the sheet to be in an editable state.
Text-to-Speech Reading Modes Compared
| Item | Speak Cells | Speak On Enter |
|---|---|---|
| Primary use case | Proofreading an existing block of data | Real-time verification during manual data entry |
| Activation method | Manual button click after selecting a range | Automatically triggers after each Enter key press |
| Control over playback | Requires manual stop; reads entire selection | Reads only the last entered cell; stops automatically |
| Best for data structure | Tables, lists, and imported data sets | Single rows or columns where data is being typed |
You can now use Excel’s Text-to-Speech to audit spreadsheets by listening for numbers that sound wrong. Try the Speak On Enter mode during your next data entry task to catch typos immediately. For advanced use, combine this with conditional formatting to highlight cells before you have them read aloud.