Using Speak Cells in Excel
Tutorials Shared by the Internet Community
Total Hits - 27810
Total Votes - 125 votes
Vote Up - 61 votes
Vote Down - 64 votes
Domain - www.versitas.com
Category - MS Excel/MS Excel Misc
Submitted By - Donna Johnson
Submitted on - 2013-03-20 22:03:42
In Excel 2010 version, there is a built-in “Speak Cells” audio feature. It can help you proofread numbers and other data by actually sounding out the numbers for you. You can choose to have the information repeated by column or by row.
In order to enable the feature, you can add the “Speak Cells” icons to your Quick Access Toolbar. The Quick Access Toolbar is at the top left of your Excel window. If you click the down arrow to the right of the Quick Access Toolbar, you can then select More Commands. When the dialog box opens, look for the Choose Commands area and click the drop down arrow next to Popular Commands. Choose All Commands. Make sure and take a look at all of the great items in the All Commands list. You might find a few more things to add to your Quick Access Toolbar.
Next, scroll down the list on the left side until you see the commands for Speak Cells. You will want to add several icons within the Speak Cells group including: Speak Cells, Speak Cells - Stop Speaking Cells, Speak Cells by Column, Speak Cells by Row, and Speak Cells on Enter. Adding all of these icons will increase your flexibility in using the Speak Cells feature. To select the desired icon(s), double-click each of the icons to move them over to the right list that shows the items on your Quick Access Toolbar. When you have added them all, click OK.
The Speak Cells on Enter, can be used to proofread. To use that feature, just click on the Speak Cells on Enter icon in the Quick Access Toolbar. When you click on a cell and hit the enter key, it will speak the contents of that cell to you. Just make sure you have your speakers turned on or your headphones on! Enjoy using your new “Speak Cells” feature! ...