Dictation in Google Sheets on a Mac

Google Docs has a Voice typing item under the Tools menu. Google Sheets does not, and never has. Dictating into a spreadsheet on macOS means using system dictation against a grid that interprets keystrokes as navigation.

The Sheets-specific trap: Return commits the cell

Selecting a cell is not the same as editing it. Press Return once and the cell opens for editing with the cursor at the end of its contents. Press Return again and Sheets commits the value and moves the selection down one row. A dictated "new line" halfway through a sentence therefore saves half a sentence and types the remainder into the cell below.

• For a line break inside a cell, press Command+Return. There is no spoken command for it.
• Tab commits and moves right. Escape cancels the edit and throws the dictated text away entirely.
• Arrow keys inside an editing cell move the text cursor. Arrow keys on a selected cell move the selection, so stopping dictation and pressing an arrow can jump you to a different cell before you notice.

The second trap: a leading equals turns text into a formula

Sheets reads the first character to decide what a cell is. A dictated "equals" at the start makes the cell a formula and Sheets shows a parse error rather than your sentence. The same applies to a leading plus, minus, or single quote, which Sheets uses to force text. If you need a sentence that starts with one of those characters, type the leading character yourself and dictate the rest.

Dictate into a cell, a note, or a comment

1. Turn Dictation on once: System Settings → Keyboard → Dictation. Full steps in enable dictation on macOS.
2. Click the cell, then press Return or double-click to enter edit mode. Watch for the blinking text cursor inside the cell.
3. Start Dictation and speak the value. Say "comma" and "period" only where you want the characters.
4. Stop Dictation, then press Return once to commit.
5. For anything longer than a phrase, dictate into a comment (Command+Option+M) instead. A comment is a real multi-line text area with no commit behaviour, so spoken line breaks behave normally there.

Where dictation actually pays off in a spreadsheet

• Comment threads on a review sheet, where the text is long and the formatting does not matter.
• A notes or description column: one sentence per row, dictated in edit mode, committed with Return.
• Not numeric entry. Speaking digits into a grid is slower than the number row and misrecognitions in a number column are hard to spot on review.

If nothing types at all

• Sheets runs in a browser, so the microphone permission that matters belongs to the browser and to the dictation tool, under System Settings → Privacy & Security → Microphone.
• If the cell is selected but not in edit mode, dictated characters go to Sheets' single-key shortcuts instead of into the cell.
• Dictation dead everywhere, not just Sheets: dictation not working on Mac.

A hotkey that inserts once instead of streaming keys

Voice Type writes the finished text in a single insertion on release, so a spreadsheet cell receives one value rather than a stream of keystrokes that Sheets can interpret as navigation. The model runs on your Mac: voice typing for Mac.

Keep going

• Dictation in Google Docs (two engines, one of them Chrome only)
• Dictation in Microsoft Word (and where the audio goes)

Sources

• Google Docs Editors Help: Keyboard shortcuts for Google Sheets
• Google Docs Editors Help: Type and edit with your voice (Docs only)
• Apple: Dictate messages and documents on Mac