Add data, formulas, and text

You can add content to a table in several ways. You can type new content directly into cells, copy and paste content from somewhere else, or let Numbers complete patterns for you with autofill. You can always edit or clear a cell after you add content to it.

Note: If you can’t modify a table, make sure it’s unlocked. Click the table, then choose Arrange > Unlock (from the Arrange menu at the top of your screen).

Add content to cells

Do any of the following:

See Format cells to display different types of data to learn how to set specific data formats for cells.

You can also Add an object to a cell and insert a link in a cell.

Add an object to a cell

You can paste objects—including images, lines, shapes, and text boxes—into table cells. You can also add text to a cell that already has an object.

  1. Select an object (image, line, shape, or text box) in your spreadsheet (or some other document), then choose Edit > Cut or Edit > Copy (cut removes it from its original location).

  2. Click the cell where you want to add the object. (You can paste the object into a cell that already has text.)

  3. Choose Edit > Paste.

    By default, Numbers scales the object to fit in the cell. To change the object’s size, click the Cell tab at the top of the sidebar on the right, click the disclosure triangle next to Fill, then click the “Scale to Fit” pop-up menu and choose another option.

    If you don’t see a sidebar, or the sidebar doesn’t have a Cell tab, click Format button in the toolbar.

To remove an object from a cell, click the cell, click the Cell tab at the top of the sidebar on the right, click the disclosure triangle next to Fill, then click the Image Fill pop-up menu and choose No Fill.

The control for removing an object from the selected cell

Autofill cells

You can quickly fill cells, or a row or column, with the same formula, data, or a logical sequence of data—for example, a series of numbers, letters, or dates.

Do any of the following:

Autofilling doesn’t establish an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.

When you autofill cells, any formulas that refer to those cells are updated automatically to use the new value.

Copy or move cell content

When you copy a cell, or move a cell’s data to a new location in the table, the cell’s properties are also copied or moved, including its data format, fill, border, and comments.

  1. Select the cells you want to copy or move.

  2. Do one of the following:

    • Move the data: After selecting the cells, click and hold the cells until they appear to rise off the table, then drag them to another location in the table. Existing data is replaced by the new data.

    • Paste and overwrite existing content: Choose Edit > Copy (from the Edit menu at the top of your screen). Select the top-left cell where you want to paste the data (or select an area of the same dimensions as the cells you’re pasting), then choose Edit > Paste.

      If your data range contains formulas but you want to paste only the results, choose Paste Formula Results.

    • Paste without overwriting: Choose Edit > Copy, select the destination cells, then choose Insert > Copied Rows or Insert > Copied Columns (from the Insert menu at the top of your screen). New rows or columns are added for the copied cells.

    • Paste a cell style: Choose Format > Copy Style (from the Format menu at the top of your screen), select the cells where you want to copy the style, then choose Format > Paste Style.

    • Paste cell contents without the style: Choose Edit > Copy, select the cells where you want to paste, then choose Edit > Paste and Match Style. The pasted cells adopt the formatting of the new location.

    • Paste outside of an existing table to create a new table: Drag the cells outside the table. A new table is created with the pasted cells.

If you copy a range of cells that include hidden data (either hidden or filtered), the hidden data is also copied. If you paste to a range of cells with a matching arrangement of hidden cells, the hidden data is also pasted. Otherwise, the hidden content isn’t pasted.

Turn autocomplete suggestions off or on

As you type in a cell, Numbers can show a list of autocomplete suggestions. This list includes any text previously entered in that column, but not header or footer text. Autocomplete is on by default, but you can turn it off or on at any time.

  1. Choose Numbers > Preferences (from the Numbers menu at the top of your screen).

  2. Click General at the top of the preferences window.

  3. In the Editing section, select or deselect “Show suggestions when editing table cells.”

Show a cell’s row and column

You can temporarily highlight a cell’s row and column in blue as you move the pointer over a table. In a large table, this can help you identify column and row references for specific cells.

SEE ALSOFormat cells to display different types of dataResize rows and columnsLink to websites and email messagesMerge or unmerge cellsAdd controls to cells