Hi, this is Wayne again with a topic “Using the Speak Cells on Enter Tool in Excel”.
In this short excel tutorial, I want to show you a wonderful but little-known feature in Microsoft Excel, and it’s one that I think many of you will find very very helpful and it’s called speak cells on enter, and I want to start by talking about why you Might want to use speak cells on enter. This feature is perfect for people who enter a lot of data. Let’S say that your boss or your manager or someone gives you a bunch of data that you’re supposed to enter into Excel you’re, probably going to be looking at a piece of paper or some other source of that data. Maybe it’s another screen or another application, but you’re going to be looking at the source and then typing that data into your Excel spreadsheet. So unless you’re, very confident in your typing skills, you’re gon na be looking back and forth from the source of the information. Let’S say the piece of paper and switching from that and then you’re going to move your attention to your Excel spreadsheet, to make sure that you typed the number or the data correctly. And then your eyes are going to go back to the paper and then back to Excel back to the paper back to Excel.
This is going to be very time-consuming and it might drive you crazy. So, let’s look at how we can use speak cells on enter to help us with that situation. Basically, I can just go up here to what’s called the quick access toolbar and you can see right now. I’Ve added a couple of extra tools. If you want to learn more about this, please watch my video that covers the quick access toolbar, but I’m gon na click. This button here to customize the quick access toolbar, I’m gon na, go down to more commands and it’s gon na give me a list of some of the popular commands that you can easily add to the quick access toolbar so that they appear here.
But I’m gon na click where it says popular commands and I’m gon na switch to either all commands or just commands, not in the ribbon, and if I click on that, I should be able to browse down and find speak cells on enter there. It is I’m gon na click on it, click Add, and it adds it to this list of tools that I want to be here on the quick access toolbar. Now, if I don’t like the order, I could click on it and then click this button to move it up or down to put it in the right spot.
Now I simply click, ok and there it is. I have a button for speak cells on enter and it’s right there on my quick access, toolbar. So let’s say with this spreadsheet here, which is a list of games that I would sell in a hypothetical board game and card game store. And let’s say we add some more games to the inventory, let’s say a classic game like Stratego, it’s a lot of fun. I type in Stratego I hit enter and nothing happened. Why? The reason nothing happened is because up here on the quick access toolbar, even though I added speak cells on enter to the toolbar – it’s not activated yet so I have to click on else will now be spoken on enter and it’s ready to go. So, let’s try that again Stratego, I type it in hit enter HECO and it tried to pronounce. It did ok and now I’ll go down and I want to add Settlers of Catan tap enter, ok, yeah pretty good, but that at least tells me that it recognized what I typed and that now I can move on to the next data to enter Settlers of Cayden, the last one, I’m gon na add, is uno madness. We know madness now. This is especially useful in many cases with numbers, so I can put in the sales for Stratego 5 for Settlers of Catan, 65 and uno madness.
32. So I hope you can see the potential benefit here with speak cells on enter. It really can help you to check your work as you enter it into the spreadsheet. If you ever get sick of speak cells on enter 9 then go up here to the quick access. Toolbar. Just click off speak on enter and this is a toggle button, so you can toggle it on cells will now be spoken on enter and you can toggle it off turned off speak on enter. I hope you’ve enjoyed watching this tutorial. If you did, please click the like button below and consider connecting with me on my social media websites like Facebook, Pinterest and Twitter, and definitely do subscribe to my youtube channel for more videos about technology for teachers and students and watch for another video. From me. At least every Monday, if you’d like to learn more about any of these fun games, please look in the description below and if you’d like, to support my youtube channel, please consider becoming a patron of mine on patreon and you’ll, find links to my patreon account in The description below .