web analytics

USE TEXT TO SPEECH TO FIND ERRORS IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to use text to speech in order to find errors in a Microsoft Excel 2013 worksheet. The text-to-speech feature lets your computer read aloud any series of cell entries in the worksheet. It’s great for checking your printed source while the computer reads.

To start click the customize quick access toolbar button at the end of the toolbar, followed by more commands on the drop down menu.

1

The options dialog box opens with a quick access to a large tab selected click commands not in the rhythm on the choose commands from drop-down menu.

2

Then scroll down the list until you see the speak sells command, click the speak sells entry and then click the add button to add it to the quick access tool bar, following the redo button.

3

Click the add button repeatedly until you’ve added the remaining text-to-speech buttons to the custom group. That includes: Speak Cells, Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows and Speak Cells on Enter. Click ok to close the dialog box.

To use the Speak Cells button, to check your spreadsheet and catch those hard to spot errors, select the cells in the worksheet you want to hear, then click the Speak Cells button on the quick access tool bar.

4

If you want text-to-speech to read across the rows and then down, click the Speak Cells by Rows button on the quick access tool bar.

5

To have the text-to-speech feature reading each cell entry while you press the enter key, click Speak Cells on Enter. Cells will now be spoken on enter.

7

To pause this feature when you find a discrepancy click the Stop Speaking button.

Leave a Reply