Benches Uncategorized

7

How do you add a cell in Numbers?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Excel offers this simple option in the Insert menu, but I don't see this in Numbers.

7 replies

Sign in or join Beachball Help to reply.

  1. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi generdude,

    In Numbers, you can drag adjacent cells to leave a blank cell behind.

    Suppose you want to insert a cell above C3.

    Select the C3 and the cells below (but leave a blank row below).

    Hard click and hold. The selection will "lift" off the table. Drag it down.

    Regards,

    Ian.

  2. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi generdude,

    In Numbers, you can drag adjacent cells to leave a blank cell behind.

    Suppose you want to insert a cell above C3.

    Select the C3 and the cells below (but leave a blank row below).

    Hard click and hold. The selection will "lift" off the table. Drag it down.

    Regards,

    Ian.

  3. 0

    generdude

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    That works. But I have over a hundred rows of entries. So I need to select and move over a hundred cells just to enter one single solitary cell? Yikes!

  4. 0

    Wayne Contello

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    you can insert a row or column

    by using the key combinations:

    add a new row above: <option> + <up arrow>

    add a new row below: <option> + <down arrow>

    add a new column after: <option> + <right arrow>

    add a new row before: <option> + <left arrow>

  5. 0

    generdude

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yes, but I have two columns, so if I insert a row, it affects both columns. Then I'll have an unwanted extra row in the second column.

  6. 0

    Wayne Contello

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yes. I understand. you can use the combination of suggestions to get what you want but there is no built0in feature to insert a single cell in a select row or column.

    you can post feedback to Apple using the Numbers menu item "Numbers > Provide Numbers Feedback"

  7. 0

    generdude

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Alright, then, thanks to everyone here and I will post to Apple.