Enter text and numbers in Numbers on iPad

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 can’t see Unlock, the table isn’t locked).

Type content in cells

  1. Go to the Numbers app on your iPad.

  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 tickbox to a cell and enter numbers in scientific E-notation format (such as 1E+04). You can also type a date or time (such as 31/12 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 per cent symbols (%) are interpreted as fractions of 100, and so on. For information about data formats, see Format dates, currency and more.

    • Date, time and duration keyboards: Tap the Date and Time Keyboard button. Tap the Date & Time button or Duration button on the left side of the keyboard to show the keys for the type of data you want to enter.

    • 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 move to another cell, tap Return (or the Next Row key or the Next Column key) on the keyboard.

  6. 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.

  7. When you finish, tap the Hide Keyboard button to dismiss the keyboard.

To delete content from a cell, tap the cell twice, then tap Delete (if you can’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.

See alsoFormat dates, currency and more in Numbers on iPadResize rows and columns in Numbers on iPadLink to a web page, email, phone number or sheet in Numbers on iPadMerge or unmerge cells in Numbers on iPadAdd controls to cells in Numbers on iPad
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.