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.
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.
- It fails in TextEdit too. Numbers is not the problem. macOS dictation or the microphone is. Go to fixes 8 and 9.
- It works in TextEdit but not in Numbers. The problem is almost certainly where your cursor is, what format the cell has, or whether the table or file can be edited. Start with fixes 1 to 7.
- Text appears in Numbers, just not the way you expected. Dictation worked. Skip to the section on Numbers quirks further down.
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:
- A selected table. Clicking the edge of a table, or clicking a table once after working elsewhere on the sheet, can select the whole table. Click once more to reach a cell, then double-click to get inside it.
- Objects on the canvas. Charts, images and shapes without text have nowhere for words to go. Text boxes and most shapes work once you double-click inside them and see a cursor.
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.
- Automatic. Numbers tries to recognize numbers, dates, percentages and currency in what you enter. A dictated note that starts with a date or looks like a fraction can be turned into a value instead of staying as words.
- Number, Currency, Percentage, Date & Time and Duration. These expect values. Words may be rejected, converted or displayed in a way that looks nothing like what you said.
- Checkbox, Star Rating, Slider, Stepper and Pop-Up Menu. These are controls, not text fields. They have no text cursor to dictate into.
- Text. Everything you enter is kept exactly as entered. This is the right format for a notes or comments column.
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:
- Category summary rows. In a table organized into categories, the summary rows show calculated values you choose, such as a total or an average. They are not ordinary text cells.
- Cells in a group. If a table was grouped with other objects, your first click selects the group. Click again to reach the table, then double-click into a cell.
- Anything in a chart. Chart labels and values come from the table the chart is built on. Edit the table, not the chart.
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:
- The file is locked in Finder. Numbers tells you the document is locked and will not accept changes. Unlock it, or duplicate it and work on the copy.
- It was shared with you as view-only. A collaborative spreadsheet shared through iCloud can give some people permission to view without editing. Ask the owner for edit access, or duplicate it into your own files.
- It came from an email or a download. Files opened straight from an attachment can sit in a temporary location. Save a copy to your own folder before you do any real work in it.
- It started as an Excel file. Numbers opens an Excel workbook as a new Numbers spreadsheet. You can edit it, but save it as a Numbers file first, and export back to Excel from the File menu if someone needs the original format.
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:
- The Format sidebar. If you just changed a font size, a number of decimal places or a cell border width, focus may still be in that field. Dictated words land there, get rejected, or change a setting.
- The Organize sidebar. Filter and sort rules have text fields. Dictating into one can quietly change which rows you can see.
- The search field. After you use Find, focus can remain in the search box.
- A sheet tab. Double-clicking a sheet tab renames it. Dictate there and you have renamed your sheet.
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.
- Turn it on. If it is already on, turn it off, wait a few seconds, and turn it back on. This clears a stuck state on some Macs.
- Check the shortcut. If the shortcut is set to Off, no key will start dictation. If it is a combination another app or utility also uses, the press may never reach macOS. Try Start Dictation from the Edit menu in Numbers, where macOS usually adds it, to rule the shortcut out. Our guide to a Mac dictation shortcut that is not working covers the common conflicts.
- Check the language. Dictating in one language while another is selected produces nothing or nonsense.
- Check the microphone source. The Dictation section lets you pick a microphone separately from your general input setting.
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 see | Most likely cause | Fix |
|---|---|---|
| Nothing happens when you dictate on a cell | Cell selected, no text cursor | 1 |
| A value you needed was replaced | Dictated onto a selected cell | 1 |
| A sentence is spread down the column | Spoken "new line" acting as Return | 2 |
| Words turn into a date or a number | Automatic or value data format | 3 |
| A checkbox or menu cell ignores you | Control data format, not text | 3 |
| A syntax error appears | Formula editor was open | 4 |
| One table ignores every click | Locked table or summary row | 5 |
| Nothing types, spoken or keyboard | Locked or view-only spreadsheet | 6 |
| A setting or sheet name changed | Focus in the sidebar or a sheet tab | 7 |
| Dictation starts then stops | Another app holding the microphone | 8 |
| Fails in TextEdit as well | macOS dictation off or shortcut changed | 9 |
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:
- Smart Vocabulary is a personal dictionary with replacement rules. Add your client names, product names and internal terms once, and they come out spelled the same way every time. In a spreadsheet that matters more than usual, because sorting, filtering and categories all depend on entries matching exactly.
- Meeting Mode records meetings with speaker detection and produces AI notes, which is useful for capturing decisions from a budget or planning review so you can update the sheet afterward.
- Calendar meeting detection notices when a scheduled meeting is starting, so you do not have to remember to set anything up before the review begins.
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.
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