Have a Talk with Excel
Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada. As mentioned on the show, you can get a free chapter a week from the new book by signing up here.
I hate proofreading! I’ve just finished keying this list of 150 numbers from a printed piece of paper. My eyes have glazed over and the odds of me being able to accurately proofread are slim. It would help if I had someone to read me the numbers and I could cross-check them against the piece of paper. It turns out that Excel has a cool feature where you can highlight a range of cells and have Excel speak the values in those cells. This will allow you to listen to the numbers while you compare them to the printed paper. When you involve two senses (hearing and sight), you will engage more of your brain and the process will be less tedious. To turn this feature on, visit Control Panel – Speech – and select the least annoying of the three voices available on the Text to Speech tab.
Then, in Excel, go to Tools – Speech – Show Text to Speech Toolbar.
The toolbar has five icons. Select a range of cells and choose the first icon to have Excel read the selection to you.
If you discover an error and you need to stop, use the 2nd icon. There are many uses for this. With a laptop in a car, you can have Excel read a file to you so that you can keep your eyes on the road. If you want to check entries as you type them, use the “Speak on Enter” button on the toolbar. For the BEST TV show on technology, check out Call for Help. This tip was originally published on June 12, 2005 and aired on TechTV on July xx, 2005. The permanent URL for this page is http://www.mrexcel.com/tip097.shtml. If you are looking for show notes from another episode, visit my complete list of TechTV appearances.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Excel is a registered trademark
of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
All contents Copyright 1998-2008 by MrExcel Consulting.