← Back to Blog

Short answer: If Mac dictation is not working in Google Sheets, double-click the cell or press Return until a blinking cursor appears, then start dictation. A selected cell is not in edit mode. Sheets has no voice typing of its own, so check your edit access, protected ranges and Apple's dictation settings.

Free to start Dictate into any app on your Mac or iPhone — hold a key, speak, release. Download for MaciPhone

You have a column of call notes to fill in, and talking through them would be far quicker than typing. You click a cell in Google Sheets, press your dictation shortcut, say a sentence, and nothing appears. Or the words appear and wipe out what was already in the cell. Or your first sentence lands where you wanted and the second one turns up a row further down, on top of somebody else's entry.

Google Sheets is an awkward place to dictate for three reasons. First, it has no voice typing of its own, so on a Mac you are relying on Apple's built-in dictation or another dictation app. Second, a spreadsheet grid is not a page of text. Clicking a cell selects it, but you are not editing it yet. Third, Sheets decides what your words become. A spoken date, a number or a phrase that starts with a plus sign can be stored as something you never said.

None of that means dictation is broken. It means the cell was not ready for text, the sheet would not accept it, or Sheets changed it on arrival. This guide works through each cause in order. If dictation is failing in every app on your Mac, not only in Sheets, start with our complete guide to Mac dictation not working instead.

Where is voice typing in Google Sheets?

If you are hunting for Tools, then Voice typing, you will not find it in a spreadsheet. That menu item belongs to Google Docs, and Google Slides offers voice typing only for speaker notes. Sheets simply does not have it. It is not a setting you switched off or something missing from your account. If voice typing inside Docs is what has stopped working for you, our guide to Google Docs voice typing not working covers that separately.

That leaves the dictation built into macOS, which works in any text field in any app, a browser tab included. Because Apple dictation is part of macOS rather than part of the website, Sheets never asks for microphone permission, and you do not need to allow the mic for Google's site in your browser. A missing site permission is not the reason dictation fails here. The reasons are all about the cell.

Why a spreadsheet is harder on dictation than a document

In a document, clicking anywhere puts a blinking cursor in the text, and whatever you say goes there. In Sheets, one click puts a blue border around a cell. That is selection, not editing. Typing into a selected cell replaces whatever was in it, and dictated words arrive exactly like typed ones, so at best you overwrite the cell, and the switch into editing is not always clean.

Editing mode is different. Double-click the cell, press Return, or click in the formula bar above the grid, and a cursor appears inside the cell's contents. Only then does dictation behave the way you expect. Then, when you are done, Return does not add a new line. It commits the cell and moves you down a row. Add access levels, protected ranges, formulas that fill whole blocks of cells, and a browser with its own extensions, and there are plenty of ways to be looking at a cell that will not take your words.

The 30-second split test

Before you change anything, find out whether the problem is Sheets, your browser or your Mac. Open TextEdit, create a new document, start dictation and say a sentence.

The 10 fixes, in order

1. Put the cell into edit mode before you speak

This is the most common cause by far. Double-click the cell, or select it and press Return, until you see a blinking cursor inside it. Pressing F2 also works on keyboards where the function keys are set up for it. You can also click in the formula bar above the grid, which edits the same cell with more room to see what you are saying. Only once the cursor is blinking should you start dictation.

Then check where that cursor is. Double-clicking a cell that already has text can drop the cursor in the middle of a word, and dictation inserts at the cursor. If any text is highlighted, dictation replaces it. To add to the end of an existing note, click once at the very end of the text in the formula bar before you speak, so nothing is selected and the cursor sits after the last word.

2. Stop Return from scattering your notes down the column

In Sheets, Return means "this cell is done". It saves the entry and moves the selection one row down. If you say "new line" or "new paragraph" while dictating, Apple dictation sends a line break, which Sheets treats as Return. The cell is committed mid-thought, and whatever you say next can land in the cell below, replacing what was there. Anything that sends a Tab does the same thing sideways.

To put a line break inside a cell, press Cmd+Return or Option+Return (which one works can depend on your browser) at the point where you want the break, then carry on dictating. For longer notes, dictate a sentence or two at a time and add breaks by hand. If your words have already spread down the column, Cmd+Z undoes one step at a time until the original cells come back.

3. Make sure you can actually edit the spreadsheet

If nothing you type or dictate changes anything, look near the title and the Share button at the top of the page. A label such as View only means you can look but not change. Comment access is similar: you can add comments, but not edit cells. Unlike Google Docs, Sheets has no suggesting mode, so there is no way to propose changes inside the cells themselves.

Check which Google account the sheet is open under, too. If you are signed in with a personal and a work account in the same browser, the file may have opened under the one without edit rights. Switch accounts from your profile picture, or ask the owner for edit access. If you only need your own version, choose File, then Make a copy, and dictate into the copy. And if the file is an uploaded Excel spreadsheet showing in Drive's preview, open it with Google Sheets before you try to edit.

4. Look for protected sheets and ranges

Owners can protect a whole sheet or a range of cells. Depending on how the protection is set, you are either blocked with a message saying the cell is protected, or shown a warning you have to confirm before editing. Either way, a dialog opens and takes keyboard focus, so your dictated words have nowhere to go. If a box flashed up and disappeared as you started speaking, this is the likely cause.

If you own the sheet, open Data, then Protect sheets and ranges, to see what is protected and who can edit it. If you do not, ask the owner which cells are open for you, or work in a copy.

5. Stop Sheets turning your words into dates, numbers or formulas

Sheets looks at every entry and decides what kind of value it is. Dictate "March 3" and you may get a date. Dictate "3/4" and you may get a date that depends on your locale settings. Dictate a phone number or an ID with a leading zero and the zero can disappear. And if what you say begins with an equals sign, a plus sign or a minus sign, Sheets treats the whole entry as a formula, which usually ends in an error such as #ERROR! or #NAME?.

Apple dictation adds to this, because it converts spoken words into digits and symbols. "Five percent" can arrive as "5%", which Sheets then stores as a number rather than the words you meant. There are two reliable fixes:

6. Watch for autocomplete, dropdowns and smart chips

Three Sheets features can change your words after you speak them:

7. Know which cells will not hold your words

Some cells look like ordinary values but are really the output of a formula. Dictating into one of them replaces the formula with your text, which is rarely what you wanted.

The trickier case is a formula that fills a whole block of cells from one cell at the top, such as FILTER, SORT, UNIQUE, ARRAYFORMULA or IMPORTRANGE. Everything below the top cell belongs to that formula. If you dictate into one of those cells, the formula at the top breaks with a #REF! error saying the result was not expanded because it would overwrite data. Delete what you dictated and the block fills back in. Pivot table results are calculated in the same way, so change the source data rather than the pivot table itself.

8. Check where keyboard focus really is

A spreadsheet window is full of text boxes that are not cells. The Name box at the top left shows the cell reference, such as A1, and anything you dictate there is treated as a place to jump to. Cmd+F opens Sheets' own find bar. Comment threads, the chart editor, version history and other side panels all have their own fields. And the browser's address bar is always one click away.

If your words keep appearing somewhere unexpected, focus was in one of those places when you started. Click back into the grid, get the cell into edit mode (fix 1), and try again. Also remember that dictation goes to the active cell even if you have scrolled away from it. If the blue border is off screen, your words are going to a cell you cannot see.

9. Rule out the browser and its extensions

Sheets runs inside your browser, so anything that changes how the browser handles typing can affect dictation. Grammar checkers, translation tools, text expanders and some password managers all watch what you type. Open the sheet in a Chrome Incognito window, where extensions are off unless you have allowed them, or in a different browser. If dictation suddenly works, turn your extensions back on one at a time to find the culprit. Our guide to Mac dictation not working in Chrome goes deeper on browser-side causes.

While you are there, look at the status near the top of the sheet. If Sheets says it is offline or trying to connect, edits can stall until the connection comes back, so wait for it or reload the page. Very large sheets can also lag, so dictated text arrives in a burst a moment after you finish speaking. Give it a second before clicking elsewhere, or you may commit a half-finished entry.

10. Check Apple dictation itself

If dictation failed in TextEdit too, the problem is on the Mac. Open System Settings, then Keyboard, and make sure Dictation is turned on. Check the shortcut shown there, since pressing the wrong key is a frequent cause, and our guide to a Mac dictation shortcut that does nothing covers every shortcut problem. Check that the dictation language matches the language you are speaking, and that the microphone source is the mic you are actually using.

Dictation also cannot hear you if something else is holding the microphone, such as a video call or a recording app. Finish those first. On a work Mac, dictation may be restricted by your organization's management profile. If everything looks right and it still fails, quit your browser completely, restart the Mac and try again.

Google Sheets quirks that look like broken dictation

Some problems are not failures at all, just the way spreadsheets handle text:

Quick triage table

What you seeMost likely causeFix
Nothing appears in the cellCell selected, not in edit mode1
Dictation replaced the whole cellCell selected, or text highlighted1
Second sentence lands a row down"New line" sent Return2
Nothing can be changed at allView-only access or wrong account3
A box flashes up and dictation vanishesProtected cell or range4
Words become a date, number or errorAutomatic formatting or formula parsing5
Extra words appear after yoursAutocomplete accepted a suggestion6
A #REF! error appears aboveDictated into a formula's output block7
Words turn up in the wrong placeFocus in a panel, box or address bar8
Fails on every web pageBrowser or extension9
Fails in TextEdit tooApple dictation or mic problem10

Dictation works in Google Docs, so why not Sheets?

A document is one long run of text, so the cursor is always somewhere sensible and Return just starts a new line. A spreadsheet is hundreds of small text boxes, each of which has to be opened, filled and committed, and each of which Sheets inspects and may reformat. Docs also has its own voice typing, which Sheets lacks. The same selected-versus-editing split exists in desktop spreadsheet apps as well, so if you use both, our guides to dictation in Excel on Mac and dictation in Numbers will look familiar.

A dictation workflow that suits spreadsheets

Dictation in Sheets works best when you treat each cell as a short, deliberate entry:

It is worth the effort, because speaking is much faster than typing. Most adults type around 40 words per minute, and even professional typists usually sit around 80 to 100, while normal speech runs at 130 to 150 words per minute. For a sheet full of notes, comments or descriptions, that difference adds up quickly. For more on setting up a sheet for voice entry, see our guide to dictating into Google Sheets cells.

A dictation tool that behaves the same in every cell

Apple dictation is free and built in, but it has its own shortcut quirks, it stops when you pause to think, and its "new line" commands send exactly the Return key that commits a cell. On a sheet where you are dictating short entries into dozens of cells, those small frictions add up.

Voice Keyboard Pro is a menu bar app for Mac that works in Google Sheets the same way it works everywhere else. Hold your hotkey, speak, release, and the text appears at your cursor, whether that is a cell, the formula bar or a comment box. Because you hold the key for as long as you are speaking, you decide exactly where each entry starts and ends. It does not depend on Apple's dictation toggle or shortcut, and the website never needs microphone permission, because the app uses its own permissions that you grant once in Privacy & Security. It still needs a cursor inside a cell, like any typing does, so fix 1 applies to it too.

A few features matter for spreadsheet work in particular:

On privacy, our servers store only operational pings. No audio and no transcript content is stored. There is a free tier with daily limits, and Pro is $4.99 a month or $34.99 a year. The same app is also a custom keyboard on iPhone, with a mic button for dictation in any iOS app.

Frequently asked questions

Does Google Sheets have voice typing?

No. Voice typing is a Google Docs feature, and Google Slides offers it only for speaker notes. In Sheets on a Mac, use Apple's built-in dictation or another dictation app, which work in any cell you can edit.

Why does clicking a cell not let me dictate into it?

One click only selects the cell. Double-click it, press Return, or click in the formula bar until a blinking cursor appears, then start dictating. Dictating into a cell that is only selected replaces its contents at best.

Why does my dictation jump to the cell below?

Saying "new line" makes Apple dictation send a line break, and Sheets treats that as Return, which saves the cell and moves down a row. To add a line break inside a cell, press Cmd+Return or Option+Return instead.

Why do dictated numbers turn into dates or errors?

Sheets reformats entries it recognizes as dates or numbers, and treats anything that starts with =, + or - as a formula. Type an apostrophe before dictating, or set the column to Plain text under Format, then Number.

Do I need to allow the microphone for Google Sheets in my browser?

Not for Apple dictation, which is part of macOS and never asks the website for permission. The browser only needs microphone access for a website's own mic button, and Sheets does not have one.

What to do next

Run the 30-second split test, then work through the fixes that match what you saw. For most people it is fix 1: the cell was selected but never in edit mode. If your notes keep ending up a row too low, fix 2 is the answer, and if words turn into dates or errors, fix 5. And if you want dictation that starts and stops exactly when you choose in every cell, try Voice Keyboard Pro's free tier on your next column of notes.

Voice Keyboard Pro
Hold your key · Speak · Release

The words land at your cursor in whatever app you are already in — Mail, Slack, Word, a browser form. No dictation window, nothing to copy across.

Free forever for casual use · Apple Silicon & Intel