Enter text and numbers in Numbers on iPhone

You can add content to a table in several ways. You can type directly into cells using the standard keyboard or special keyboards for certain types of data and controls. You can also copy and paste content from somewhere else or let Numbers complete patterns for you with autofill.

Note: If you can’t modify a table, make sure it’s unlocked. Select the table, then tap Unlock (if you don’t see Unlock, the table isn’t locked).

Type content in cells

  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, tap the cell, then begin entering content.

    If the keyboard isn’t open, tap the Show Keyboard button at the bottom of the screen.

  3. To switch to a different keyboard, tap one of the buttons at the top of the keyboard:

    • Numeric keyboard: Tap the Numeric Keyboard button.

      You can enter numbers, currency values, and fractions (like 1 1/3); add a star rating or checkbox to a cell; and type a date or time (such as 12/31 or 2:15 PM).

    • Text keyboard: Tap the Text Keyboard button.

      You can type words, numbers, dates, and so on. What you type determines how the data is interpreted and used in calculations. For example, numbers with currency symbols are interpreted as monetary values, numbers with percent symbols (%) are interpreted as fractions of 100, and so on. For information about data formats, see Format dates, currency, and more.

    • Date and time keyboard: Tap the Date and Time Keyboard button.

    • Duration keyboard: Tap the Duration Keyboard button.

    • Formula keyboard: Tap the Formula Keyboard button.

  4. To edit what you typed (except a formula), tap to place the insertion point where you want to type (drag the insertion point to reposition it).

    To edit a cell that has a formula, see Change an existing formula.

  5. To insert a line break or a tab between words, tap to place the insertion point, then tap again to view the pop-up menu. Tap the Forward Button, tap Insert, then tap Tab or Line Break.

    To reposition the insertion point, drag it.

  6. When you finish, tap the Done button to dismiss the keyboard.

To delete content from a cell, tap the cell twice, then tap Delete (if you don’t see Delete, tap the Forward button).

You can also add an image or other object, insert functions in cells, and insert a link in a cell.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.