Monday, August 29, 2011

Make Excel 2007 Read Spreadsheets To You

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.

    No comments:

    Post a Comment