• Excel Book Excerpt

Excel Have Excel Talk to You

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Have Excel Talk to You

Problem: I have many numbers to enter, but I am notoriously bad at keying data. How can I get my numbers into Excel accurately?

Strategy: You can verify your typing by having Excel’s speech utility speak each number as you complete an entry.

In my Power Excel seminars, I frequently show this trick as both a useful tool for proofreading and a great April Fool’s Day prank: You can turn on the Speech option on a co-worker’s computer and then hide the icons. Despite my efforts at popularizing it, either this feature wasn’t used by enough people or it was too annoying. In Excel 2007, the feature was banished to the Commands Not on the Ribbon category in the Quick Access toolbar customization dialog. To use the Text to Speech option, you have to add the icons to the Quick Access toolbar. To do so, follow these steps:

1. Right-click the ribbon and choose Customize the Quick Access Toolbar.

2. In the left dropdown, choose Commands Not in the Ribbon.

3. Scroll down to the icons that start with S. Locate and click on Speak Cells.

4. Click the Add>> button five times to move the Speak Cells icons to the QAT.

You can now select a range of cells and click the Speak Cells icon. Excel will read you the cells, so you can focus on the original paper from which you’re keying the data.

LE10000119.jpg

Figure 147 Add these icons to the QAT.

Gotcha: If you accidentally select a million cells and ask Excel to speak the cells, you can click the Stop Speaking Cells icon to stop Excel from reading the cells. (I’ve worked for a couple managers who should have had this button on their forehead.)

Additional Details: You can choose whether Excel should read a rectangular range column by column or row by row by using the Speak Cells by Columns or Speak Cells by Rows icons.

The Speak on Enter icon is a fun icon. Imagine that your co-worker heads out to lunch on April Fool’s Day. You could add the Speak on Enter icon to the Quick Access toolbar, turn on this feature, and then remove the icon from the Quick Access toolbar. Your co-worker returns from lunch, starts typing, and is perplexed to find that the computer starts repeating everything he types, reminiscent of the computer on Star Trek.

Gotcha: Be careful if you have kids in middle school. I showed some this feature, and they very quickly demonstrated that Excel knows how to say all words, including bad ones!

Additional Details: The voice in Vista and Windows 7 is Microsoft Anna. In earlier operating systems, you had Sam, Michael, and Michelle with Sam as the annoying default. Visit Control Panel, Speech to see what voices are available.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: