Guides

How to dictate in Numbers on a Mac: cells, comments, and what to type instead

By ยท Published

To dictate in Numbers on a Mac, double-click a cell so the insertion point appears, choose Edit, Start Dictation, speak, and press Return to move to the cell below. That is Apple Dictation, free and built into macOS, and Apple's Numbers guide documents it from the Edit menu.

YapToText, the free app I built, types into Numbers cells too, keeps your voice on your Mac, can press Return for you after each value, and writes spoken numbers as digits when you ask. I built it because my hands make typing difficult, and I dictate with it every day. The one thing I would not dictate is a formula, and the section on formulas explains why.

Download YapToText on the Mac App StoreDownload for free. No account, nothing locked, macOS 14 or later on Apple silicon. Source on GitHub.

On this page: 11 sections
  1. Steps
  2. Put the insertion point in the cell first
    1. Step 1: Start editing the cell
    2. Step 2: Dictate the value
    3. Step 3: Move on
  3. Use Apple Dictation from the Edit menu
    1. Step 1: Turn Dictation on once
    2. Step 2: Dictate into the cell
  4. Use YapToText in Numbers, free and on device
    1. Step 1: Click into the cell
    2. Step 2: Tap Right Command and talk
    3. Step 3: Tap it again
    4. Let YapToText press Return for you
  5. Dictate numbers as digits
  6. Dictate comments on a cell
  7. Type the formulas, don't dictate them
  8. If dictation is not working in Numbers
    1. If YapToText's words do not land in Numbers
  9. What each one cannot do
  10. The short version
  11. Questions

Steps

  1. Double-click the cell in Numbers, or select it and press Option Return, so the insertion point appears.
  2. Choose Edit, Start Dictation to use Apple Dictation, or tap Right Command to start YapToText.
  3. Say the value. With YapToText, press 3 while you talk for Clean Up if it is a number.
  4. Click Done or press Esc for Apple Dictation, or tap Right Command again for YapToText, and check the words in the cell.
  5. Press Return to select the cell below.

Put the insertion point in the cell first

A selected cell has a border around it, not a blinking cursor, and dictation types at the insertion point. Apple's Numbers guide says to double-click a cell to make the insertion point appear, and its keyboard shortcuts list Option-Return to edit a cell. Give Numbers a blinking cursor before you talk.

Step 1: Start editing the cell

  • You: Double-click the cell, or select it and press Option Return.
  • Check: A text cursor blinks inside the cell, not just a border around it.

Step 2: Dictate the value

  • You: Start Apple Dictation or YapToText, as below, and say the text or the number.
  • Check: The words appear in the cell.

Step 3: Move on

  • You: Press Return. Apple's Numbers shortcuts say Return selects the cell below, Tab selects the next cell and Shift-Tab the previous one.
  • Check: The value sits in its cell and the next cell is selected, ready for Option Return.

Apple adds two details that help with data entry: in the bottom row, Return adds a new row, and in the right-most column, Tab adds a new column. Apple also says you can click an empty cell and start typing, but I have not tested YapToText's paste into a cell that is only selected, so start editing first.

Use Apple Dictation from the Edit menu

Numbers takes dictation through the Mac's own Dictation, and Apple's Numbers guide starts it from the Edit menu. Apple's Mac guide says Dictation works anywhere you can type, so a cell in editing mode works like any other text field. Apple Dictation is free and fine for a label or a short note in a cell.

Step 1: Turn Dictation on once

  • You: Choose Apple menu, System Settings, then click Keyboard in the sidebar. Go to Dictation, turn it on, and click Enable.
  • macOS: May ask whether to share audio recordings to improve Siri and Dictation. Not Now is a fine answer.
  • Check: Dictation stays on. Note the keys in the Shortcut pop-up menu, because they start Dictation without the Edit menu.

Step 2: Dictate into the cell

  • You: Place the insertion point in the cell, or select the text you want to replace, then choose Edit, Start Dictation.
  • macOS: Shows the microphone when it is ready. If you have never used Dictation, guided setup instructions appear first.
  • Check: Words appear as you speak. Click Done below the microphone, or press Esc or your Dictation shortcut, then press Return.

Say: In Apple Dictation, just before a number.

numeral

What happens: Apple's commands list says numeral formats the next phrase as a number.

Three things matter more in a cell than in a document. In supported languages Apple adds commas, periods and question marks on its own, so look for a period you did not want; Apple says you can turn that Auto-punctuation off under Dictation in Keyboard settings. Dictation stops by itself after 30 seconds without speech, which is fine for one cell, and the 30-second limit page explains it. And your voice may be processed on your Mac or sent to Siri servers: the text below Dictation in Keyboard settings says which. The Mac dictation commands list has the rest of Apple's commands.

Use YapToText in Numbers, free and on device

YapToText is the free Mac app I built for dictating into every app, Numbers included. It runs Whisper on your Mac to hear you and puts the words at the cursor, with no account and no subscription. It needs an Apple silicon Mac with macOS 14 or later, and it is free on the Mac App Store. Edit the cell, tap, talk, tap, and the value lands where the cursor was.

Step 1: Click into the cell

  • You: Double-click the cell, or select it and press Option Return.
  • YapToText: Nothing yet. It types into the app in front, never into its own window.
  • Check: A text cursor is blinking in the cell.

Step 2: Tap Right Command and talk

  • You: Tap Right Command once and say the value.
  • YapToText: Opens the floating panel with your voice as a wave and your words as they form.
  • Check: The wave moves when you speak. If it stays flat, the app is not hearing your microphone yet.

Step 3: Tap it again

  • You: Tap Right Command again.
  • YapToText: Finishes the transcript on your Mac, pastes it at the cursor and puts back whatever you had copied before.
  • Check: The words are in the cell. Press Return to move to the cell below. If they went to the clipboard instead, Accessibility is not on yet; the fixes below cover it.
YapToText's floating dictation panel on a Mac: a live waveform, the sentence being typed, and cancel, pause and stop buttons.
Figure 1. The words form in the panel while you talk, and land in the cell when you tap the key again.

Let YapToText press Return for you

In Numbers, Return is the key you press after every value. YapToText can press it the moment your words land: in Settings, Advanced, Text output, under After a dictation lands, choose Add App, pick Numbers while it is open, and leave it on Press Return. The value lands, Return selects the cell below, and you press Option Return to edit that one. With Return pressed for you, filling a column is Option Return, tap, talk, tap.

It presses the key without a second look, so a misheard value goes into the cell too, and it is set for Numbers as a whole, so it also fires after a long comment. Turn it on for a session of data entry and off afterward. I have not tested this loop end to end in Numbers, so try it on a scratch table first.

  • Empty cells. Intelligent Insert reads the words around the cursor with a few invisible keystrokes. In an empty cell there is nothing to adapt to, so the text goes in as dictated. If Numbers beeps at the keystrokes, turn it off for Numbers, as the fixes below describe. The Intelligent Insert guide explains it.
  • Long text, no clock. A notes or description column is where dictation saves the most typing. A dictation runs until you tap the key again; only a safety stop at 30 minutes ends one on its own.
  • Names spelled your way. Product names and project codes are where speech models stumble. Dictionaries turn a phrase you say into the exact spelling you want.
  • A safety net. History keeps your last 500 dictations, with their audio, and deletes anything older than 30 days by default, so a value that landed in the wrong cell can be inserted again.

Dictate numbers as digits

Numbers is a spreadsheet, so most of what you say is a number. YapToText's Clean Up mode turns spoken numbers into digits without adding units you did not say, and Auto mode's careful pass does the same. For a number, press 3 while you talk, and Clean Up writes it as digits.

The catch is length. Auto mode, on by default, leaves a dictation of six words or fewer exactly as spoken, and most cell values are shorter than that. So a lone number under Auto comes out however Whisper wrote it. Pressing 3, Clean Up's number in the default order, sends that one dictation through Clean Up.

Say: In a cell you are editing, after pressing 3 for Clean Up while you talk.

twelve hundred and fifty

What happens: Clean Up writes the number in digits, with no currency sign or unit you did not say.

YapToText's Switch Mode list: Auto, Raw Transcription, Clean Up, Note, Email, Message and Code Comment, numbered 1 to 7.
Figure 2. In the default order Clean Up is number 3, so pressing 3 while you talk sends that one value through Clean Up.
  • For one dictation. Press 3 while you talk. With Auto on, the next dictation goes back to Auto.
  • For every dictation in Numbers. Turn Auto mode off, open Clean Up's editor on the Modes page, and add Numbers under Apps that use this mode. While Auto is on, it decides how each dictation is written, so this takes over only with Auto off.
  • For a currency sign. Say it. Dollar sign is a two-word name, so "dollar sign 50" gives $50 with no extra word.
  • For exactly what you said. Press 2 for Raw Transcription, which is literal speech to text with basic punctuation and no AI.

Read numbers back before you rely on them. Whisper can mishear a number like any other word, and a wrong digit in a column is harder to spot than a wrong word in a sentence. The modes guide covers Clean Up, and the Auto mode guide explains the six-word rule.

Dictate comments on a cell

Numbers keeps notes on a cell as comments. Apple's comments guide says to click the cell, click the Comment button in the toolbar, type your comment, then click Done or click outside it. A cell with a comment shows a triangle in its corner. A comment is a text box, so dictate into it the way you would type into it.

  • You: Click the cell, click the Comment button, and with the cursor in the comment, start Apple Dictation or tap Right Command.
  • Check: The words land in the comment. Click Done when you finish.

I have not tested YapToText in a Numbers comment specifically, so check the first one before you dictate a dozen. If you share the spreadsheet, Apple says each person's comments appear in their own color with their author name, so a dictated comment reads like any other. For longer notes in a document instead of a spreadsheet, the guide to dictation in Pages covers that side.

Type the formulas, don't dictate them

A formula is mostly symbols. Apple's Numbers guide says you start one by typing the equal sign in a cell, which opens the Formula Editor, then click cells or type values, add operators such as +, -, * or /, and press Return or click the Commit Formula button when you are done. Say the prose, type the syntax.

YapToText does have spoken names for those marks. Equals sign and plus sign are two-word names, and one-word names such as asterisk need insert in front, as in "insert asterisk". But the Formula Editor expects you to click cells and pick functions, any misheard letter breaks a reference, and the cleanup modes rewrite sentences, not syntax. I have not tested dictating formulas, and I would not.

  • Say these. Column headings, labels, comments and descriptions, and anything else a person will read.
  • Type these. Formulas, cell references, function names and anything Numbers will calculate from.
  • Numbers. Either, as long as you read them back.

The same rule runs through the Excel dictation guide, and the spoken punctuation guide lists every name YapToText understands, if you want a symbol in a label.

If dictation is not working in Numbers

Most trouble in Numbers comes from the grid, not the microphone. If nothing types, check for a blinking cursor before anything else. Climb this ladder, smallest step first:

  1. Nothing types. The cell is selected but not being edited. Double-click it or press Option Return, then start again.
  2. A period at the end of a value. Both Apple Dictation and Whisper punctuate as they go. Delete it before you press Return, or turn off Auto-punctuation for Apple Dictation in Keyboard settings.
  3. A number came out as words. With YapToText, press 3 for Clean Up while you talk. With Apple Dictation, say numeral first.
  4. Turn Dictation on. In System Settings, Keyboard, make sure Dictation is on. If Edit, Start Dictation works and your key does not, only the shortcut is wrong.
  5. Check the microphone and language. Under Dictation, choose your microphone next to Microphone source, and click Edit next to Languages to select the language and region you speak.
  6. Turn off Voice Control. When Voice Control is on, standard Dictation is not available, and you dictate through Voice Control instead.

The Mac dictation not working guide goes through Apple Dictation fix by fix.

If YapToText's words do not land in Numbers

Another short ladder, smallest step first:

  1. If the words go to the clipboard. On YapToText's Home page, press Grant next to Accessibility and switch the app on in System Settings, Privacy & Security, Accessibility. Without it, every dictation is copied to the clipboard instead of typed.
  2. If Numbers beeps. Intelligent Insert reads the text around your cursor with a few invisible keystrokes, and some apps answer one with the alert sound. On the Dictation page, in the Delivery card, choose Turn off in another app and pick Numbers, or lower Alert volume in System Settings, Sound, which silences only alert beeps.
  3. If pasting misbehaves. In Settings, Advanced, choose Add App Override under Per-app method, pick Numbers and keep Type character-by-character.
YapToText's Dictation settings page on a Mac: the Keys, Recording, Microphone and Delivery cards.
Figure 3. The Delivery card at the bottom of the Dictation page holds Intelligent Insert and the list of apps where it is off, which is where Numbers goes if it beeps.

The troubleshooting guide covers the rest.

What each one cannot do

  • Apple Dictation. It stops after 30 seconds of silence, adds punctuation you may not want in a cell unless you turn Auto-punctuation off, and whether your voice leaves the Mac depends on what Keyboard settings says.
  • YapToText. It has no Numbers commands: it does not move between cells, select ranges or build formulas. It types at the cursor, and After a dictation lands can press Return for you. It needs an Apple silicon Mac with macOS 14 or later, and nothing is claimed for Intel Macs.

The short version

  • A cursor first. Double-click the cell or press Option Return, then dictate, then Return.
  • Apple Dictation. Edit, Start Dictation, free and built in; say numeral before a number.
  • YapToText. Free and on device; press 3 for Clean Up and numbers come out as digits.
  • Formulas. Type them; dictate the labels and comments around them.

In Numbers, dictate the words and the values, and type the syntax.

If something here does not match what you see in Numbers, open an issue on GitHub. Every one gets read.

Download YapToText on the Mac App StoreDownload for free. No account, nothing locked, macOS 14 or later on Apple silicon. Source on GitHub.

About the author. Ryleigh Newman is a developer whose hands make typing difficult and who dictates every day with YapToText, the app this site describes. Facts about other apps come from their own sites, with the date they were read. More about the project.

Sources

Questions

Can you dictate in Numbers on a Mac?

Yes. Apple's Numbers guide says to place the insertion point, choose Edit, Start Dictation and speak when the microphone appears. YapToText also types into Numbers cells: tap Right Command, talk, and tap it again.

How do I dictate into a cell in Numbers?

Double-click the cell, or select it and press Option Return, so a text cursor blinks. Start Apple Dictation or YapToText, say the value, then press Return to move to the cell below.

Can I dictate numbers as digits in Numbers?

With YapToText, press 3 for Clean Up while you talk, and spoken numbers come out as digits without units you did not say. With Apple Dictation, Apple's commands list says numeral formats the next phrase as a number. Read numbers back either way.

Can you dictate formulas in Numbers?

You can say some symbols by name, but a formula is mostly symbols, cell references and function names, and one misheard letter breaks it. Type the formula in the Formula Editor and dictate the labels and comments around it.

Why does dictation not type into my Numbers cell?

The cell is probably selected but not being edited. Double-click it or press Option Return so a cursor blinks, then start dictating again.