Make Excel 2007 Read Spreadsheets To You
This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.
Instead of looking between a hard copy of data and comparing it to the data entered on the spreadsheet you can make Excel read your spreadsheet to you while you are looking at the hard copy version.
Now for this to work we need to add some commands to the quick access toolbar. In the customize dialog, you’ll have to choose All Commands, and then add all the commands that start with “Speak”. (More on customizing the toolbar)
You should see those items in your quick access toolbar now…
Now select the cells you need to compare in your spreadsheet.
Finally we just need to choose to have Excel speak by rows or speak by columns. Press the Speak Cells button, and Excel starts reading the rows or columns. To stop it just hit the Stop Speaking Cells button.
Of course you will need to have speakers connected to your PC for this to work. You can also change the sound and speed of the voice by going into Speech Properties.
Daily Email Updates
You can get our how-to articles in your inbox each day for free. Just enter your name and email below:
One huge flaw in Excel’s cell speaking system is if you attempt to switch to another window while Excel is speaking the cells, it will stop! That virtually renders it useless if you attempt to cross reference data in the Excel sheet with some other data in another application.
It has been in existence for awhile and not new to 2007.
Great!
You guys are genius!
Thanks for making our office lives really easy!
i got the help from you. thanks
Great turning it off. Now I have to hit the freakin’ stop button everytime I enter data. How you permanently stop this thing from talking to you!!!!