ATOI365D

#Office365Challenge – Did you know that Excel can read cells to you so you can proofread it? Well, neither did I. Picked this cool tip up today from a friend Corrie, thanks cupcake!!

Day: 142 of 365, 223 left
Tools: Excel
Description: Speak Cells in Excel

Many a times I find myself having to check data that I’ve read into Excel from another Excel document or even a printed document. This is SO much easier if you can follow on the source document while listening to the cells being read out to you.

How to do this?

Go to the File Tab > Options > Customize Ribbon. See my blog about setting this up:  Around the Office in 365 Days:  Day 8 – Customizing the Office Ribbon

Here I’ve changed the selection to “Commands not in Ribbon”, because yes, not all the commands are showing on your Ribbon in Excel. I’ve created a new custom group under my Review Tab called More. I then select “Speak Cells” and add it to this newly created group. (Refer to above post for more detail on how to do this).

SpeakCells

Now back in Excel, you’ll be able to select cells, click on the “Speak Cells” command, and it will be read out to you, while you’re checking it on the other document to make sure your input was correct.

SpeakCells2

Yup, that’s super cool!!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements