Скачать или смотреть Excel - Speak Cells After Each Cell is Data Entered - Episode 2039

Microsoft Excel Tutorial - Speak Cells on Enter.

Welcome to another episode of the MrExcel podcast, where we dive into all things Excel. In this episode, we'll be discussing a handy feature that can save you from getting whiplash while working with data from paper. That's right, we're talking about the Speak Cells feature in Excel.

If you've ever had to manually enter data from a paper document into Excel, you know how tedious and time-consuming it can be. And constantly looking back and forth between the paper and the screen can cause some serious neck strain. But fear not, because Excel has a solution for this problem.

To access the Speak Cells feature, you'll need to customize your Quick Access Toolbar. Simply right-click on the toolbar and select "Customize Quick Access Toolbar." Then, choose "All Commands" or "Commands Not in the Ribbon" and scroll down to the S's. Click on "Speak Cells" and add it to your toolbar. You'll want to add it five times to have access to all five icons.

Now, when you have a set of cells selected, you can click on the first icon to have Excel read the contents of those cells to you. And if you accidentally select too many cells, you can click on the second icon to stop the speaking. I joke that some of my coworkers could use this icon on their forehead.

But that's not all, you can also control whether the cells are read down the column or across the rows. And if you want to speed up the voice, you can adjust the settings in the Control Panel. The voice may vary depending on your operating system, but kudos to the Speech team for continuously improving this feature.

And if you want to learn even more Excel tips and tricks, be sure to check out our playlist in the top-right hand corner and click on the "i" for more information. And for a comprehensive guide to all of our podcast episodes, be sure to grab a copy of our book, which includes over 500 tips and tricks. Thank you for tuning in and we'll see you next time for another episode of the MrExcel podcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #walkthrough #evergreen #excelspeak #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp

This video answers these common search terms:
make excel stop talking
how to speak type in excel
how to stop excel from speaking cells
how to turn off speaking cells in excel
how to turn speak cells off in excel
where is speak cells in excel
can i text to speech in excel
can you speech to text on excel

Table of Contents:
(00:00) Avoid Whiplash with Speak Cells in Excel!
(00:15) Data on paper and proofreading in Excel.
(00:25) Accessing the hidden Speak Cells feature in Excel.
(01:10) Using the Speak Cells feature to read selected cells.
(01:26) Using the Stop Speaking icon
(01:39) Read down or across
(01:50) Changing voice or speed in Control Panel
(02:39) Recap of the episode
(03:00) Clicking Like really helps the algorithm

Sometimes, you have to key data from a piece of paper.
You want to proofread the data in Excel.
You will get whiplash going back and forth between screen and paper.
Right-click Quick Access Toolbar
Choose Customize Quick Access Toolbar
From the top left dropdown, choose Commands Not in the Ribbon
Find Speak Cells.
Click Add five times to move all the Speech icons.
Select some cells, click Speak Cells.
Some of my co-workers should have the Stop Speaking icon on their foreheads!
You can control if they read by columns or by rows.
Pro tip: speed up the voice in the Control Panel
Microsoft Anna is the voice in Windows 7

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...