dictate for excel?

Tammy,

Just another user here.

I have used dictation in Excel. 

I enter data into a cell using dictation, but haven't yet used dictation to move to other cells, etc.

(Dictation is not meant to be the same as "voice commands, so please remember that.)

I'm using it to enter barcodes that can't be scanned. 

My dictation consists of reading the number off the package, so that it is placed in the cell.

I can keep my eyes on the barcode and use my finger to move along the barcode number on the package so I don't miss digits, all without looking at or touching my computer.

Please know that I've only "tinkered with dictation in Excel", and so I think there are more things that can be done which I just have not discovered yet.

How I dictate a number into a cell:

1. Start dictation (WIN+H)
2. Move Excel's cursor box to the intended cell.
3. Speak your cell contents.
4. Press enter/tab/arrow to move to another cell.
5. Click on the microphone icon in the dictate bar to dictate another cell entry.

Some notes from my experience:

After a momentary delay, the spoken data gets placed in the cell all at once.

So, when I speak 13 digits in a row, nothing happens until I'm done speaking.  Then, after a brief pause, the entire number gets "pasted" into the cell.  Each number does not appear "as you speak it."

A number will be entered as digits, not the spelled out number.

I was clicking in the cell to begin editing (same as F2), but I've been successful just moving to another cell and dictating another number without going into the edit mode.

Dictation (goes to sleep?) as soon as you use your mouse or keyboard to move to another cell.

Just press the microphone icon in the dictate bar to "reawaken it", and start speaking the contents of the new cell.

IF YOU SWITCH FROM EXCEL TO ANY OTHER APPLICATION, then when you switch back to Excel, although the dictate bar is still there, it seems furbar'd.   So I click the X to close the dictation bar and press WIN+H to restart it.  That's all you need to do.  And that's only if you switch to something besides Excel.

HTH,

~spamster

hello tammy sorry for the inconvenience caused to you

dictate in word comes with office 365 subscription ..it seems you have already office 365 subscription->https://support.office.com/en-us/article/dictat...

for excel you need to use windows 10 speech re-recognition

go to control panel

easy of access

speech recognition

set up speech recognition if not set up

after that when ever your are in excel press win+cltr+s that would toggle speech recognition

and now you can convert speech to text

tips ->

->The more time you spend working on calibrating the microphone beyond the minimum requirements, the more effectively the software will recognize your voice commands. It's worth taking the extra time to eliminate later frustration.

windows speech recognition do evolve with your pronunciation with time

i would also like you to see if this feature is available in excel if not follow above steps ->https://support.office.com/en-us/article/dictat...

if your problem still persist please do reply

Thanks but this hasn't worked. This simply reads the typed text out. It hasn't allowed me to speak the content and have it turned into text.

hi i am an independent advisor and would ike to hep you resolve your issue

to use dictate in excel you must enable speak cells command

->go to file

->options

->quick access toolbar

->under choose command from select all command and search for speak cells command

->add that command and your good to go

please let me know if it works

Hi Graeme,

Thanks for this. Though I still can't get it working on anything other than word.