Benches Uncategorized

8

insert or delete single cells

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

How do I insert or delete a single cell?

For example, I want two columns of text. aligned horizontally, and, separated by a blank column.

The two text lists have been created in other applications.

So I copy list1, and paste it in cell C7.

Then I copy list2, and paste it cell G6.

oops. Now the lists are not aligned horizontally.

The easiest way to align the lists is by either delete a single cell in column C or insert a single cell in column G.

But I can't find the option to add/delete single cells.

Does that option exist in Numbers? If so, how/where?

Thanks,

AJ

8 replies

Sign in or join Beachball Help to reply.

  1. 0

    pw1840

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    AJ,

    Basically, you cannot insert a single cell in a row or column. Now I may not be following your situation correctly, but why not re-paste list 2 in cell G7 to align with C7, then delete the contents of G6 which is now repeated in G7?

    pw

  2. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    AJ,

    My first thought on reading your post was: why are you using a single table for two side-by-side lists? If you had used two single-column tables you could use Delete Row or Insert Row to do what you want.

    pw and John both gave you perfectly good solutions, and I just wanted to add my two cents worth. I don't see much value in the Add/Delete Cell feature that you are looking for. The action never ends there because there's always a followup question as to what you want to do with the data to the right of and below the affected cell. So, it hasn't saved you any real time.

    Numbers has a very handy and secure method for moving a range of data. Highlight the range that you want to move. Then, Edit > Mark for Move. Now, click in the new starting location and Edit > Move.

    There you go; several ways to recover from the inevitable oops. Depending on how soon you discover your mistake, Command-Z is probably the easiest fix.

    Jerry

  3. 0

    pw1840

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    AJ,

    Basically, you cannot insert a single cell in a row or column. Now I may not be following your situation correctly, but why not re-paste list 2 in cell G7 to align with C7, then delete the contents of G6 which is now repeated in G7?

    pw

  4. 0

    John Hendy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    The option does not exist that I know of, either. In a similar line of thought to pw, you can simply press Command+z to undo, then move to G7 and press Command+v to repaste. Undoing an action does not eliminate the contents of the last copy/cut from the clipboard.

    I'm not on my Mac right now, but I thought there was a way to reposition selected cells to another location by clicking and dragging. This could be a fix as well but I can't verify until later. My apologies if I'm not remembering correctly.

    -John

  5. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    AJ,

    My first thought on reading your post was: why are you using a single table for two side-by-side lists? If you had used two single-column tables you could use Delete Row or Insert Row to do what you want.

    pw and John both gave you perfectly good solutions, and I just wanted to add my two cents worth. I don't see much value in the Add/Delete Cell feature that you are looking for. The action never ends there because there's always a followup question as to what you want to do with the data to the right of and below the affected cell. So, it hasn't saved you any real time.

    Numbers has a very handy and secure method for moving a range of data. Highlight the range that you want to move. Then, Edit > Mark for Move. Now, click in the new starting location and Edit > Move.

    There you go; several ways to recover from the inevitable oops. Depending on how soon you discover your mistake, Command-Z is probably the easiest fix.

    Jerry

  6. 0

    AJ

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yes, I know I could delete/repaste.

    I had already close the source document and made a couple other edits, so I could not undo the paste.

    It's faster/easier to delete a single cell (to shift the entire column up 1) than select the 85 item list, recopy, adjust the insert point, then repaste.

    (I'm a semi-reformed Excel user, which does have the ability to delete/add single cells.)

  7. 0

    AJ

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    For this exercise, I copied 2 different alphabetized lists of 85+ entries from 2 different web sites. I knew there was some duplicate data on the two lists.

    I want to do a side by side comparison. No calculations required, so no repercussions for shifting the data around.

    I had already close the web browsers and added a 'title' to column C before I saw the columns were not aligned horizontally, so I couldn't undo/redo the paste in column G.

    I'm accustomed to Excel, which has the ability to insert single cells or delete a range of cells with two clicks. Could figure out how to do that in Numbers.

    I was not aware of the edit/mark for move function in Numbers.

    Thank you all for the suggestions 🙂

  8. 0

    r_j_a

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Just select the cell range and drag it up/down - same for Excel, no?