Benches Uncategorized

7

insert cells

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Sorry if this is too simple for some of the issues being discussed, but all I want to do is insert some blank cells into a sheet. I don't see any way to easily do it. Can insert rows, insert copied rows, but I don't see any insert cells or insert copied cells. Am I missing something? I have just started using numbers after years of excel.

Thanks,

Tom

7 replies

Sign in or join Beachball Help to reply.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    No can do. You can select cells in a row and move them over to make space but there is no "insert cells" command.

  2. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Tom,

    Numbers and Excel are built on different frameworks in the sense that an Excel table/spreadsheet is virtually boundless and Numbers tables are finite and generally only as large as the data requires. Pushing some cells out of the way to make room for others has greater implications in Numbers, and it is left to the user to make room by moving the cells manually. I once counted mouse clicks to achieve the insertion in Numbers vs. Excel and the difference was small to none. Yes, Excel will move cells for you, but not until you tell it which way to move them. With Numbers you just do it yourself.

    There's a nifty command pair in Numbers that helps with the job. It is +Mark for Move+ and
    Move.

    Select the cells to be moved, Edit > Mark for Move, click to select the cell where you want the upper left cell of the range to move to and then Edit > Move.

    Jerry

  3. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    No can do. You can select cells in a row and move them over to make space but there is no "insert cells" command.

  4. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Tom,

    Numbers and Excel are built on different frameworks in the sense that an Excel table/spreadsheet is virtually boundless and Numbers tables are finite and generally only as large as the data requires. Pushing some cells out of the way to make room for others has greater implications in Numbers, and it is left to the user to make room by moving the cells manually. I once counted mouse clicks to achieve the insertion in Numbers vs. Excel and the difference was small to none. Yes, Excel will move cells for you, but not until you tell it which way to move them. With Numbers you just do it yourself.

    There's a nifty command pair in Numbers that helps with the job. It is +Mark for Move+ and
    Move.

    Select the cells to be moved, Edit > Mark for Move, click to select the cell where you want the upper left cell of the range to move to and then Edit > Move.

    Jerry

  5. 0

    tommy123

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks for the answers and pointing me in the right direction. I still like the way excel handles it (my specific use of the insert is easier), but I see the reason for it and can learn to embrace it.

    Tom

  6. 0

    PDXSpree

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Not having the functionality to simply insert a cell is ridiculous. It takes twice as long to "mark for move" and then "move." This is a primary reason I am not upgrading to iWork 09 from 08. I understand that Excel and Numbers are different, but this is like not having spell check in a word processing program. Keep it simple. Less keystrokes is more.

    Message was edited by: PDXSpree

  7. 0

    Barry

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    PDXSpree wrote:

    Not having the functionality to simply insert a cell is ridiculous. It takes twice as long to "mark for move" and then "move." This is a primary reason I am not upgrading to iWork 09 from 08. I understand that Excel and Numbers are different, but this is like not having spell check in a word processing program. Keep it simple. Less keystrokes is more.

    As long as we're in rant mode, "fewer" keystrokes, not "less". "Less" is measured, "fewer" is counted.

    And a reminder that this is a
    user-to-user forum, a place where there's no guarantee your post will ever be seen by an Apple employee.

    If being able to "simply insert a cell" is an essential feature, this isn't the place to make that known.

    Go to Apple's
    Numbers Feedback page, and send the feature request directly to Apple.

    You can also get to that page by going to the Numbers menu in Numbers and choosing Provide Numbers Feedback.

    Regards,

    Barry