How to Make Excel Read Back Your Data in Excel 2007

Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

One relatively unknown feature of Excel is the ability to let it read values in a worksheet back to you. If you have a large amount of data to enter, especially numbers, this can be an incredibly useful feature that will help to ensure the accuracy of the data that was entered while you match it against a hard copy. To accomplish this, you will have to specify the data you want to read, click a button, and Excel will begin read it, it’s that simple. You can choose to have Excel read across the first row and then move to the next row, or down the first column and then move to the next column. You can also have Excel read the data as you enter it. Pretty neat stuff!

However, before Excel can read your data, you must add the following buttons to the Quick Access toolbar: Speak Cells, Speak Cells — Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speak Cells on Enter. To find out how to permanently add these buttons to the Quick Access toolbar, Click HERE.

How to Read a Group of Cells

Select all the cells that you want Excel to read.

Click Speak by Columns if you want Excel to read down the columns.

Click Speak by Rows if you want Excel to read across the rows.

Click the Speak Cells button. Excel will then read the selected cells.

To stop Excel from reading the cells, click the Speak Cells — Stop Speaking Cells button.

How to Read Cells upon Data Entry

Click the Speak on Enter button. Excel will say, “Cells will now be spoken on Enter.”

Enter your data as normal and Excel will read the data as it is entered.

To turn it off, click the Speak on Enter button once more and Excel should say, “Turn off Speak on Enter.”

Before you can make Excel read your worksheet, you, of course, must must have speakers attached to your computer and all the appropriate drivers must be installed properly. In Windows XP, click the Start button, Settings, and then Control Panel to check your audio device settings.

Article Information

1 Comments

Tom Hadley

1

Hi

some feed back on this Excel speak on enter. I am in Australia, one of the many places in the world that does not use the same date format ad the USA. We use dd/mm/yy. The problem is that the Speech to text feature in Excel 2007 gets mixed up .For instance if the date is 4/2/08 it says ” Second of April 2008″ however if the date is 24/2/08 it says ” 24th of February 2008″ !!! My systems are all set to use date format to suit Australia. I will be letting MSoft know
August 22nd, 2008 at 7:22 pm