← Back to Blog

Short answer: If Mac dictation is not working in Numbers, double-click the cell until a cursor blinks, because a selected cell or table cannot take dictated text. Check the table is not locked and the cell is not a checkbox or pop-up menu. If TextEdit fails too, fix Dictation in System Settings.

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

You click a cell in your spreadsheet, press the dictation key and start talking. Nothing appears. Or the words do appear, but they replace a figure you needed. Or a note you dictated into a comments column arrives as a date. Or a long sentence gets chopped up and spread down the column, one fragment per row.

Numbers has no dictation feature of its own. Every spoken word that reaches a cell arrives through macOS, either from Apple dictation or from a third-party app that types at your cursor. That makes troubleshooting simpler than it looks, because the list of causes is short. Almost every Numbers dictation problem comes down to one of three things: the cursor is not really inside a cell's text, the cell or table cannot accept text in its current state, or macOS dictation itself is off or misconfigured. This guide works through them in the order that finds your problem fastest. If dictation is failing in every app on your Mac and not just Numbers, start with our complete guide to Mac dictation not working, then come back here for the Numbers-specific parts.

Why a spreadsheet is harder on dictation than a document

In a word processor you are almost always inside text. Click anywhere on the page and a cursor appears, so dictation always has somewhere to go.

A Numbers sheet is different. It is a canvas that holds tables, charts, text boxes, shapes and images, and the tables themselves have layers. You can select a whole table, select one cell or a range of cells, or be editing the text inside a single cell. Only the last of those has a blinking cursor, and only the last one is a place dictation can reliably type.

Two more things make spreadsheets tricky. Every cell has a data format that decides what your words turn into, so the same sentence can land as text, a date, a number or nothing at all. And in a table, Return does not mean "new line." It means "I am done with this cell, take me to the next one." Dictation does not know any of this. It sends text to whatever has keyboard focus and trusts the app to do something sensible with it. Keep that picture in mind and most of the fixes below will make sense straight away.

The 30-second split test

Before you change any settings, find out which layer is failing. Open TextEdit, create a blank document, click inside it, and start dictation exactly the way you did in Numbers. Say one sentence.

The 10 fixes, in order

1. Double-click the cell until you see a blinking cursor

This is the most common cause by a wide margin. A single click on a cell selects it. The cell gets a highlighted border, and you can style it, copy it or move around the table with the arrow keys, but there is no insertion point. A double-click takes you inside the cell's contents, and a cursor appears. That is the state dictation needs.

When you type on a selected cell, Numbers starts a new entry and replaces what was there. Dictation into a selected cell is less predictable. Depending on how the text arrives, you may get nothing, only part of what you said, or the cell's existing contents replaced by your words. If a value just vanished, press Command-Z straight away.

The fix is simple. Double-click the cell and wait until you can see the cursor blinking before you speak. If the cell already has text and you want to add to it, double-click where you want the new words to go, or press the Right arrow to move the cursor to the end first.

Two related traps:

2. Stop Return from jumping you to the next row

In a Numbers table, pressing Return confirms what you entered and moves the selection down to the next cell. Tab confirms and moves to the right. That is exactly right for data entry, and exactly wrong for a long note.

Apple dictation's spoken commands such as "new line" and "new paragraph" insert a line break the same way the Return key would. In a table cell, that can finish the cell and move you on, so the rest of your sentence lands in the row below, or on a selected cell where it may replace a value. If your dictated notes are scattered down a column, this is why.

Dictate each cell as one continuous piece of text, without spoken line breaks. If you genuinely need a line break inside a cell, dictate the first part, press Option-Return to insert the break by hand, then dictate the rest. For anything longer than a couple of sentences, consider a text box on the canvas, or the comments feature, instead of a cell.

3. Check the cell's data format

Every cell has a data format, which you can see by selecting the cell and opening the Format sidebar, then the Cell tab, and looking at Data Format. It decides what happens to anything you enter, typed or dictated.

If a column is meant for words, select the whole column and set its data format to Text. If it is meant for values, keep its format and enter those values with the keyboard. There is a good reason for that split, which we come back to in the workflow section.

4. Get out of the formula editor

When you type an equals sign in a cell, or double-click a cell that already contains a formula, Numbers opens the formula editor. Anything you dictate while it is open becomes part of the formula, which usually produces a syntax error or a reference to something that does not exist.

If you see the formula editor with its cancel and accept buttons, click the cancel button to leave it without changes. To replace a formula with text, select the cell, delete its contents, then double-click and dictate. Also watch the start of what you say. If your dictation tool turns a spoken "equals" at the very beginning of a cell into a symbol, Numbers will read it as the start of a formula. Rephrase the start of the note, or type the first word by hand.

5. Unlock the table, and know which cells never take text

Numbers lets you lock tables and other objects so they cannot be changed by accident. A locked table looks like any other, but you cannot edit its cells, so dictation has nowhere to go. Select the table and open the Arrange menu. If Unlock is available, choose it, then double-click into the cell.

Some cells refuse text even when nothing is locked:

6. Make sure the spreadsheet itself can be edited

A spreadsheet you cannot edit looks exactly like one you can until you try to type. Common reasons in Numbers:

A quick test is to type a single letter into a cell with the keyboard. If typing does not work either, dictation is not the issue, and fixing the file's permissions will fix both.

7. Check where keyboard focus really is

Numbers has several text fields around the edges of the sheet, and keyboard focus stays in whichever one you used last. Dictation follows focus, not your eyes. Common places for words to go astray:

Click directly into the cell you want, double-click to get the cursor, and then speak. It sounds obvious, but it is the difference between a working session and one that feels broken.

8. Make sure nothing else is holding the microphone

Spreadsheets often get built during a video call, or reviewed while a recording app is running. Another app holding the microphone is a frequent reason dictation starts and immediately stops, or listens without ever typing anything.

Leave calls you are not using and close recording apps. Then open System Settings, go to Sound, choose Input, and speak while you watch the input level meter. If it does not move, your Mac is listening to the wrong input, often a headset, a display with a built-in microphone, or AirPods sitting in their case. Choose the right input and try again. Our guide to a Mac dictation microphone that is not working goes deeper on input problems.

9. Check Apple's dictation settings and shortcut

If the split test failed in TextEdit as well, the problem is in macOS. Open System Settings, go to Keyboard, and find the Dictation section.

10. Update Numbers and restart in the right order

If nothing above has helped, check the App Store for a Numbers update. Quit Numbers fully with Command-Q rather than closing its window, then reopen it. If the problem started right after a macOS update, restart the Mac too, since a restart clears speech services that updates occasionally leave stuck. If dictation works in other apps and only one spreadsheet misbehaves after all this, try a brand new spreadsheet. If dictation works there, the problem is something about the original file, such as locked tables, control-format cells or a view-only share.

Numbers quirks that look like broken dictation

Some behavior feels like a fault the first time you see it, but it is simply how Numbers handles what you enter.

The text is there, but cut off. A long entry in a narrow column is clipped at the cell edge when the next cell has content. Nothing is lost. Select the cell to see the full entry, widen the column, or turn on text wrapping for that column in the Format sidebar.

The row disappeared after you finished it. If the table has a filter, a row that no longer matches the filter after your edit can be hidden. Check the Organize sidebar for active filters before assuming your words were lost.

Numbers finished the word for you. Depending on your settings, Numbers can suggest an entry based on text already in the same column. Handy for repeated labels, surprising when a dictated phrase gets completed into something longer than you said.

Words change after they land. Numbers applies its own auto-correction, capitalization and text replacement settings to dictated text exactly as it does to typed text. If a word keeps changing after you say it, look in the Numbers settings under Auto-Correction, not in dictation.

A figure you said is not being added up. If you dictate a number into a cell formatted as Text, it is stored as text, and some calculations will not treat it as a number. Values belong in value-formatted cells.

Quick triage table

What you seeMost likely causeFix
Nothing happens when you dictate on a cellCell selected, no text cursor1
A value you needed was replacedDictated onto a selected cell1
A sentence is spread down the columnSpoken "new line" acting as Return2
Words turn into a date or a numberAutomatic or value data format3
A checkbox or menu cell ignores youControl data format, not text3
A syntax error appearsFormula editor was open4
One table ignores every clickLocked table or summary row5
Nothing types, spoken or keyboardLocked or view-only spreadsheet6
A setting or sheet name changedFocus in the sidebar or a sheet tab7
Dictation starts then stopsAnother app holding the microphone8
Fails in TextEdit as wellmacOS dictation off or shortcut changed9

Dictation works in Pages, so why not Numbers?

Both apps receive dictation from macOS in exactly the same way. The difference is what your click does. In Pages, clicking in the body of a document puts a cursor in text almost every time. In Numbers, a click usually selects a cell, and a selected cell is not text you are editing. On top of that, Numbers interprets what you enter through the cell's data format, and treats Return as "move on." None of that exists in a document.

If you work across spreadsheet apps, our guide to Mac dictation not working in Excel covers the same selected-cell problem in Microsoft's app, along with the extra issues its own Dictate button adds. And if presentations are next on your list, Mac dictation not working in Keynote deals with the object-versus-text problem on slides.

A dictation workflow that suits spreadsheets

Dictation fits some parts of a spreadsheet much better than others. Using it where it fits removes most of the friction above.

Speak the words, type the values. A misheard word is usually obvious when you read it back. A misheard number is not: fifteen and fifty look equally plausible in a budget. Use dictation for notes, descriptions, status updates and comments, and use the keyboard for figures, dates and codes. Our guide to dictating numbers, dates and currency explains where spoken figures go wrong if you do need to say them.

Give prose its own column. Set up a Notes or Comments column formatted as Text. Once the format is right, dictation lands as words every time, with no surprise dates.

Work row by row. Double-click the note cell, dictate, press Return or Tab yourself, then double-click the next one. Keeping the movement on the keyboard and the words in your voice is faster than trying to steer a table by speaking.

Put summaries in a text box. A paragraph explaining what a sheet shows reads better in a text box above the table than crammed into a cell, and a text box behaves like a document when you dictate into it.

Spend the time where it saves the most. Most people speak at roughly 130 to 150 words per minute and type at around 40, so the gain is largest on longer written entries. A one-word label is quicker to type. A three-sentence note on why a figure changed is much quicker to say. For the full walkthrough of setting this up, see how to dictate in Apple Numbers on Mac.

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 can stop when you pause to think, and every start and stop costs a keypress. On a sheet where you are dictating short notes into dozens of cells, that overhead adds up.

Voice Keyboard Pro is a menu bar app for Mac that works the same way in Numbers as it does everywhere else. Hold your hotkey, speak, release, and the text appears at your cursor, whether that is a table cell, a text box or a comment. Because you hold the key for as long as you are speaking, you decide where each piece of dictation starts and ends. It does not depend on Apple's dictation toggle or shortcut. It uses its own microphone and Accessibility permissions, which 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 specifically:

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.

Frequently asked questions

Does Numbers have its own dictation button?

No. Numbers relies on macOS for dictation. You can start Apple dictation with its keyboard shortcut or, in most setups, from the Edit menu in Numbers, or use a third-party app that types at your cursor. All of them need a cursor inside a cell or text box.

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

A single click selects the cell without placing a cursor in it. Double-click until the cursor blinks. If the cell still ignores you, check whether the table is locked, whether the cell is a checkbox, slider or pop-up menu, and whether the spreadsheet was shared as view-only.

Why does my dictated text turn into a date or a number?

The cell's data format is Automatic or a value format, so Numbers is interpreting what you said as a value. Select the column, open the Format sidebar, choose the Cell tab, and set Data Format to Text.

How do I dictate a line break inside a cell?

Do not use a spoken "new line," which can finish the cell and move you to the next row. Dictate the first part, press Option-Return to add a line break inside the cell, then dictate the rest.

Does Numbers need microphone permission for dictation?

Not for Apple dictation, which is part of macOS and listens on its own behalf. A third-party dictation app uses its own entry under Microphone in Privacy & Security.

What to do next

Run the split test in TextEdit. If dictation works there, go back to Numbers and double-click into a cell until the cursor blinks. That single step fixes most Numbers dictation problems. If the words still go wrong, check the cell's data format and avoid spoken line breaks. If the cell refuses altogether, look for a lock, a control-format cell or a view-only file. If dictation fails everywhere, fix macOS first, and Numbers will follow.

And if you want dictation that behaves the same way in every cell, every text box and every other app on your Mac, Voice Keyboard Pro has a free tier. Open your notes column, hold the key, and talk through the first row.

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