• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Use Text to Speech to Check Errors in Excel

How to Use Text to Speech to Check Errors in Excel

July 19, 2016

Excel offers some handy tools to help you identify and weed out errors in your worksheet. A simple Find and Replace is one way to correct errors, while the Spell Check feature can put paid to typos. However, if you have mistyped some data or overwritten something from the original, you may have a tough task of cross-checking all the entries against the ones in the original.

That’s where the Text to speech tool comes into play. Here’s a look at how to use Text to Speech to check errors in Excel. I’m using Excel 2016 for writing this post. If you are using an earlier version of Excel, there may be some variations in the steps.

How to Use Text to Speech to Check Errors in Excel

Excel’s Text to Speech tool reads aloud each entry that is in the range of cells you selected. As the data is read out, you can cross verify it against the documents in the original worksheet. To make use of this feature, you only need a pair of speakers or headphones to be connected to your PC or laptop.

Oddly, the Text to Speech commands are not available on the Ribbon for quick access. You need to add the hidden commands to the Quick Access toolbar or to a custom tab on the Ribbon.

Since there are quite a few commands available on this tool, I’ll create a custom group and add these commands first to my Ribbon.

1. Right-click the Ribbon and select Customize the Ribbon.

Customize the Ribbon

2. This will open up the Excel Options dialog box displaying the Customize the Ribbon page. In the right section of this dialog, select Home and then click New Group.

Create New Group in Excel

3. A new group will now be created in the Home tab called New Group (Custom). Right-click this group and rename it Speech Tools.

Rename the group

4. In the left pane, under the Choose commands from drop-down menu, select Commands not in the Ribbon.

How to Use Text to Speech to Check Errors in Excel

5. With the new group selected, from the left drop down list, select the following commands and add it to the newly created group.

  • Speak Cells
  • Speak Cells – Stop Speaking Cells
  • Speak Cells by Columns
  • Speak Cells by Rows
  • Speak Cells on Enter
ALSO READ:  How to Change the Regional Date and Time Format for Excel

6. Click OK to close the Excel Options dialog box.

Speech tools in Excel

The new group that you created (Speech tools) will now be available on the Ribbon with all the speech commands inside it.

7. To start the feature, first select the range of cells you want to be read aloud. If you want the contents of a table to be read, just place the cursor inside the first cell of the table and Excel will automatically select the entire table when you click the Speak command.

8. Now from the Ribbon’s newly created group, click Speak Cells and Windows will start reading the data inside the selected range of cells. This feature works by reading the data downwards column-wise and then row-wise.

If there is some inconsistency in your data and you need to make a correction, click the Speak Cells – Stop Speaking Cells command to pause the reading.

Remember, you can also use the Speak Cells on Enter command to check each entry manually using the Enter button.

Have you used the Text to Speech command to check errors and inconsistencies between 2 documents in Excel? If you haven’t done so, this is a very convenient way to do it, so be sure to check it out!

If you are new to Excel, be sure to check out Udemy Course “Excel 2016 Training Course for Beginners” which will provide a strong Excel foundation for anyone just getting with the program. You can read all the details about the course here or head straight over to Udemy to check out the details.

You can read our archives section if you want more tool tips, tricks, and ideas on how to use Excel.

Tweet8
Share
WhatsApp
Pin3
Buffer
11 Shares

Filed Under: How To Tagged With: excel how to

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazfit Falcon Smartwatch - TATFI

The Amazfit Falcon is a Military Grade Smartwatch with Premium Looks and Great Features

Couchmaster Cyboss Ergonomic Couch Desk - TATFI

Couchmaster Cyboss is an Ergonomic Desk to Keep Off Neck Pain

Philips Hue Festavia String Lights - TATFI

Add a Bit of Sparkle to Your Christmas Tree with Philips Hue Festavia String Lights

Samsung Galaxy Tab A7 Lite Kids Edition - TATFI

This Kid Friendly Tablet from AT&T is a Thoughtful Gift for Your Little One This Christmas

Is An iPhone Really Worth It - TATFI

Is an iPhone is Really Worth It?

Devices You Might Want to Try - TATFI

4 Fantastic Devices You Might Want to Try

Amazon Kindle 2022 - TATFI

Meet the Amazon Kindle 2022 – Packed with New Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Tips to Boost Your Ranking and Sales on Etsy - TATFI

5 Ways to Boost Your Ranking and Sales on Etsy

PunchBee Time Management App - TATFI

Know How You Spend Your Time with PunchBee

DevOps Model Explained - TATFI

The Complete Guide to DevOps: How the Model Works and Who It Benefits

Approaches to Digital Marketing - TATFI

Blending Technical and Content-Centric Approaches to Digital Marketing

Tech Tips For Startups - TATFI

Useful Tech Tips For Startups

Boox Tab X Android eReader - TATFI

Boox Tab X is an Android eReader That Helps You Do More Than Just Read

Best e Readers to Buy in 2023 - TATFI

5 Best eReaders to Buy in 2023

Best Translation Apps for Android - TATFI

5 Great Translation Apps for Android

Dynamic Island Feature on Your Android - TATFI

How to Get the Dynamic Island Feature on Android

Connected TV Advertising In 2023 - TATFI

5 Things You Need To Know About Connected TV Advertising In 2023

Smart Cost Cutting Strategies for SMEs - TATFI

5 Smart Cost Cutting Strategies for SMEs

Technologies behind the online casino world - TATFI

The Latest Technologies Behind the Online Casino World

TheAppTimes © 2023 // Runs on StudioPress