I’ve gotten a lot of inquiries lately about using speech recognition in Excel.
The fastest way to learn to apply Utter Command to Excel is to read UC Lesson 10.9: Navigating, numbers, functions, selecting and formatting in tables and spreadsheets, and UC Lesson 10.10: Putting it all together in any program (say “UC Lesson 10 Point 9” and “UC Lesson 10 Point 10” to call them up). Then take a look at the Top Excel Guide, which opens a list of useful shortcuts along the right edge of your screen.
Here are some basics:
- “Cell” followed by a letter and number jumps to any cell, e.g. “Cell B 2” or “Cell Bravo 2”
- “Control Space” selects the row the cursor is on
- “Shift Space” selects the column the cursor is on
Here are some particularly useful combinations:
- A number followed by a direction selects cells — keep in mind you can select in two directions at once, e.g. “3 Rights Â· 5 Downs” to select 3 columns to the right and 5 rows down
- “3 Downs Â· Control d” selects 3 rows down, then invokes the fill function to copy whatever was in the first row to the selected rows
And here’s a method that will save you time whether you use one formula or many:
Add the formulas you use to the Vocabulary Editor, with a comfortable spoken form. For instance “Equals Sum” to type “=SUM(”
To add a formula, say
- “NatSpeak Vocabulary”
- Speak the formula using “spell” to put the written form in the Written Form text box, e.g. “spell equals caps Sierra Uniform Mike close paren” to type “=SUM(“
- “1 Tab”
- Put a comfortable and memorable written form in the spoken Form dialog box, e.g. “equals sum”.
- “Escape” to exit or “Written Form” to add another.
Now every time you want to type “=SUM(“, say “equals sum”.