• ARTICLES
SEARCH

How-To Geek

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)

image

You should see those items in your quick access toolbar now…

image 

Now select the cells you need to compare in your spreadsheet.

1

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.

1

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.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 09/26/07

Comments (5)

  1. AL

    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.

  2. Excel.Professional@gmail.com

    It has been in existence for awhile and not new to 2007.

  3. Rishi

    Great!
    You guys are genius!
    Thanks for making our office lives really easy!

  4. gurudhyan

    i got the help from you. thanks

  5. Cheryl

    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!!!!

Enter Your Email Here to Get Access for Free:

Go check your email!