Text to Speech can be a very useful feature when you are working with worksheets. Just think – wouldn’t it be helpful to have Excel speak what you just keyed in? Then you know without even looking up whether you made a mistake or not.
Follow the steps below to learn how:
- Click the drop-down arrow on the right of you QAT (Quick Access Toolbar) and click Customize Quick Access Toolbar.
- Click More Commands.
- In the Choose commands from list, select All Commands.
- Scroll down and for each text-to-speech command that you would like to use, click the Speak Cells command.
- Click Add.
- Click OK.
Now, when you want to use a text-to speech command, you can simply click it on your QAT!
To have Excel speak your worksheet data, follow these steps:
You must have speakers for this feature!
- Select a group of cells that you want read back to you.
- Choose how your computer will read back your data by clicking By Rows or By Columns.
- Click Speak Cells.
- To correct an error, click Stop Speaking and use your mouse and keyboard to make your corrections.
- Click Speak Cells to make your computer continue to read back your selection.
Follow these steps to have every entry in your worksheet spoken:
- Click Speak on Enter.
- Enter data in a cell. Once you click Enter, your computer will read your cell back to you.
- If you hide the Text to Speech toolbar and did not turn off Speak on Enter, your computer will continue to reach back each cell entry that you make.
- Click Speak On Enter to disable it.