Subscribe to How-To Geek

Recommended: Click Here to Run a Free Scan for Common PC Errors   [Sponsored Link]

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.

Mysticgeek is the resident IT expert at How-To Geek and a huge rock music fan. When he's not writing about Microsoft Office, he's probably writing at his personal blog. This article was written on 09/26/07 and tagged with: Microsoft Office

Comments (3)

  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!


Leave a Comment




Leave your friendly comment here. If you have a computer help question, leave it on the forums instead.

Note: Your comment may not show up immediately on the site.

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.