Skip to Main Content

Indiana University Indiana University


Using Excel’s Text to Speech Feature

Everyone who has used a computer for analytical purposes has at one time heard the expression “Garbage In – Garbage Out”.  It might have been stated, “The analysis is only as accurate as the data.”  In either case it emphasizes that the calculations in Excel are only as reliable as the data that was entered in the first place. The data entry process is vulnerable to errors caused by tedium, repetition and perhaps similarity of entries. 

When it is necessary to enter large amounts of data, it is good practice to have the data checked for accuracy.  This can be done immediately by the person entering the data, or entries can be verified by a different person.  Wouldn’t it be convenient to have a tool that could provide immediate feedback of the data entered? 

Excel provides just such a tool that enables a quick and easy double-check of entries before you continue working with the data. It is the Text to Speech feature. Through this tool, Excel can read back to you what you have typed while you check that audio against your original data.
In Excel 2007, you can add a Text to Speech button to the Quick Access Toolbar. (This is a feature that was new in Excel 2002, so it is available in versions back to that point.)
To the right of the Quick Access Tool Bar click the drop down arrow to see the commands that can be added to that bar. The Text to Speech command isn’t available in this list so you have to choose More Commands… from the menu.

 Add To Quick Access Toolbar 
 
The Excel Options window opens to the Customize category of options. By default the Popular group of commands is showing, but since Text to Speech isn’t in that group, you have to search a bit further. Click the drop down arrow next to Popular Commands and choose All Commands.

All Commands Menu Choice
 
The lower window changes to show a very long list of commands available in Excel. Scroll down the list looking for the word Speak and you will find several commands associated with spoken content. You could add any or all of these icons to the Quick Access Toolbar.

 Speak Cells Commands

Here is a summary of what each command does:

  • Speak Cells: Starts reading cell content with the selected cell and continues through all contiguous cells with content
  • Speak Cells – Stop Speaking Cells: Allows you to stop the reader to correct an error. Clicking speak cells icon continues from cell where reading was stopped
  • Speak Cells by Columns: Chooses the direction of the reading to be from top to bottom of a column and then on to the next column etc.
  • Speak Cells by Rows: Chooses the direction of the reading to be across a row from left to right and then down to the far left side of the next row
  • Speak Cells on Enter: Reads the cell content back to you as you press Enter

To add any of these commands to the Quick Access Toolbar, select the command and click the Add button in the middle of the window to move the command over to the Customize Quick Access Toolbar window.

If you select a range of cells before clicking the Speak Cells button, the tool will read the contents of the selected range. Otherwise, the tool will start in the active cell, read all of the contiguous cells with content, and stop when it reaches an empty cell. 

If  you are looking for a way to have your spreadsheet “come alive” and provide you with an easy way to verify your data entry, the Text To Speech tool may be the tool for you!


  


8 Responses to "Using Excel’s Text to Speech Feature" to “Using Excel’s Text to Speech Feature”

  1. Collin Ching Says:

    Hi Veronica,

    I am using Excel 2003 SP3. For some reason, when I try to use the Text to Speech function in my Excel, I can’t hear anything, whether I’m looking for “Play back a group of cells” or “Play back after Enter”. I tested out in my Control Panel the ability to hear speech and it is able to do that under the Speech icon within the Control Panel, however, I am unable to hear anything in Excel, even though for “Play back a group of cells”, I can see the application cycle through the selected cells.

    Thanks for your help,
    Collin

  2. Veronica Mount Says:

    Collin,
    Some things you might try:
    If you are using Vista, perhaps Excel alone is muted. You might need to re-install Excel and make sure the TTS components are included in the list of things to install.
    If you are not using Vista, you can check to see if .wav files might be muted on your machine. Right click on the sound icon in the sys tray and open the volume control. Check the setting for .wav files in that window to be sure the mute is not on.
    Veronica

  3. Donna Says:

    I have tried everything on 3 different computers and can not get it to speak. It goes thru the motions but nothing. I have physical speakers on each computer. When I hit speak, I hear the “microsoft sam” repeat his line but nothing in excel. I do not have the capability to reinstall excel and I am using Vista and XP.

    Any other ideas?
    Thanks
    DOnna

  4. Donna Says:

    When I hit speak in the control panel, sorry

  5. Veronica Says:

    Donna,
    Have you tried checking the setting for .wav files on your machines? If not, right click on the sound icon in the sys tray and open the volume control. Make sure the setting for .wav files is not mute.

    Veronica

  6. Alex Says:

    Thanks for the tip.

    I have some experiences with text to speech software programs, I recommend Panopreter Plus ( http://www.panopreter.com ) to Windows 7 or vista users, for it’s simple to use but very powerful, a toolbar for IE and mp3 conversion are available too, and the voice of Microsoft Anna is natural sounding. However, it doesn’t support Excel.

  7. Hoosier Girl Says:

    This is awsome and fun. Thanks for a great tip.

  8. Nelson134 Says:

    Hii
    Useful tips have been provided it really saves a lot of time Excel provides just such a tool that enables a quick and easy double-check of entries before you continue working with the data. It is the Text to Speech feature. Through this tool, Excel can read back to you what you have typed while you check that audio against your original data.

Leave a Reply

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.