We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Numbers (the program) on Mac Problem

Heya everyone.

This is a question on behalf of my OH.

He got a Mac yesterday but is having some problems with the program Numbers (which is like the Mac version of Excel).

It won't let him add or delete single cells, only rows and columns.

Does anyone have any ideas, or know of a free alternative that allows a user to add and delete single cells, instead of just columns?

Has to be Mac compatible of course. =P

Thanks. :)

x
2019 Wins
1/25

£2019 in 2019
£10/£2019

Comments

  • Scrilla
    Scrilla Posts: 242 Forumite
    You can't do delete cells like you ask and shift cells at the time time - I'm guessing that's what you want to do.

    Out of habit more than anything else, I do this the drag and drop way in excel and this should work in Numbers to.
    Lets say you want to get rid of A2 and be moving A3 to A8 in it's place (so A3 replaces A2, A4 replaces A3 and so on). I would select A3 to A8, and drag and drop so A3 is in the A2 position.
    Of course, it's not as convenient if you have A3 to A10000000000 to move.
  • LadyMorticia
    LadyMorticia Posts: 19,899 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    Scrilla wrote: »
    You can't do delete cells like you ask and shift cells at the time time - I'm guessing that's what you want to do.

    Out of habit more than anything else, I do this the drag and drop way in excel and this should work in Numbers to.
    Lets say you want to get rid of A2 and be moving A3 to A8 in it's place (so A3 replaces A2, A4 replaces A3 and so on). I would select A3 to A8, and drag and drop so A3 is in the A2 position.
    Of course, it's not as convenient if you have A3 to A10000000000 to move.


    OH says thank you. :)

    He thinks he can get into the habit of that quite quickly. :)
    2019 Wins
    1/25

    £2019 in 2019
    £10/£2019
  • OH says thank you. :)

    He thinks he can get into the habit of that quite quickly. :)

    Tell him from us he should thank you daily :rotfl:
    4.8kWp 12x400W Longhi 9.6 kWh battery Giv-hy 5.0 Inverter, WSW facing Essex . Aint no sunshine ☀️ Octopus gas fixed dec 24 @ 5.74 tracker again+ Octopus Intelligent Flux leccy

    CEC Email energyclub@moneysavingexpert.com
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.5K Banking & Borrowing
  • 254.1K Reduce Debt & Boost Income
  • 455K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 602.9K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.