Academic journal article Journal of Accountancy

Make Excel Speak Faster

Academic journal article Journal of Accountancy

Make Excel Speak Faster

Article excerpt

Q. A couple of years ago you described how to program Excel to read aloud the numbers in worksheets (JofA, Dec.03, page 89). That tip has saved me many hours of work. Can you help me get Excel's voice to speak faster so I can save even more time?

A. Sure, but before I do, let me repeat how to evoke Excel's voice for those who missed the column. You must have computer speakers and Excel 2002 or later.

Click on Tools, Speech and Show Text to Speech Toolbar, bringing up this toolbar:

[ILLUSTRATION OMITTED]

Notice there are five icons; each controls a different read-back function. Pass your cursor over each icon and an explanation of what it does will appear. Starting at the left, the first (see screenshot top right) orders Excel to read the numbers in the cell--hesitating a second or so between cells. If the cell contains a formula, it will not read the formula, just the resultant number, unless you press Ctrl+' (grave accent).

The second icon halts the process. The third and fourth control whether the automatic reading moves across a row or down a column. …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.