Page 247 - Excel 2013 All-in-One For Dummies

Eliminating Errors with Text to Speech 229
Figure 3-20:
Quick Access toolbar with three Text to Speech custom buttons added.
To add the Speak Cells, Speak Cells - Stop Speaking Cells, and Speak Cells on Enter command buttons to the Quick Access Toolbar, follow these steps:
1. Click the Customize Quick Access Toolbar drop-down button and then choose the More Commands option from its drop-down menu.
Doing this opens the Quick Access Toolbar tab of the Excel Options dialog box.
2. Choose Commands Not in the Ribbon from the Choose Commands From drop-down menu.
The Text to Speech command buttons include Speak Cells, Speak Cells - Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speaks Cells on Enter.
3. Click the Speak Cells button in the Choose Commands From list box on the left and then click the Add button to add it to the bottom of the Customize Quick Access Toolbar list box on the right.
4. Repeat the process outlined in Step 3, this time adding the Speak Cells - Stop Speaking Cells and Speak Cells on Enter buttons.
If you want to reposition the Text to Speech buttons on the Quick Access toolbar, select each button in the Customize Quick Access Toolbar list box and then move it left on the bar by clicking the Move Up button or right by clicking Move Down. If you want to set off the Text to Speech buttons as a separate group on the Quick Access toolbar, add a <Separator> icon ahead of the Speak Cells command button (and follow- ing the Speak Cells on Enter button if you have buttons not related to the Text to Speech function that follow on the Quick Access toolbar).
5. Click the OK button to close the Excel Options dialog box.
After adding the Text to Speech buttons to the Quick Access toolbar, you can use them to corroborate spreadsheet entries and catch those hard-to- spot errors as follows:
Book II Chapter 3
Editing and Proofing Worksheets