Here’s an interesting feature of Excel you may not have heard of – Speak cells.  When activated, Excel will read everything you type into a cell or column aloud.

This can be especially useful if you’re entering a lot of data from a piece of paper or another app since it will confirm what you’re typing when you’re not looking at the screen.

Here’s how you can use it. Let’s start by putting shortcut icons to the feature as part of your Quick Access Toolbar in Excel. Open a spreadsheet in Excel and click the little drop-down arrow at the top right.

quick-access-toolbardrop.jpg

Choose More commands from the drop-down menu.

more-commands-excel.jpg

Click the arrow next to Choose commands from.

choose-commands-from.jpg

Select All commands.

all-commands.jpg

Scroll down to Speak Cells on Enter, select it, and then hit Add. There are also options to Speak CellsSpeak Cells by Columns or Speak Calls by Rows.  Select OK when you’re finished.

speak-cells-enter.jpg

If I want to have a column or row read aloud to be, I can just select it and choose

speak-cells-read.jpg

To have Excel read the cell each time I press enter, I select Speak Cells on Enter.

speak-cell-enter-incon.jpg

To turn off, choose Stop Speaking Cells.

choose-stop.jpg