Questions about using Numbers on the Mac

Forum
macOS & Mac Apps

Hey everyone,

I have a few questions about numbers on the Mac.

1. How do I edit the contents of a cell once I have typed data into it?
2: How do I autosum a number of cells.
3: Let's say I auto summed a number of values. Now I want to take the total, and paste it in another sheet. Basically, I want to make a spreadsheet of my blind work expenses, and will have totals from a number of categories. How would I do this?

I would really appreciate someone's help. If this is too many questions, I can work with a guide or podcast that has already been created.

Thank you

Options

Comments

Submitted by Zack on Tuesday, March 3, 2015

Hi There,

I can answer questions 1 and 2, at any rate. I don't know about 3, it's not something I've done much with myself.

1. To edit a cell, press vo-space on it. You'll open the editor with the contents highlighted. If you use an arrow key or something similar to move around in it, you'll cancel the highlight and can edit normally.

2. The formula you want is =sum(start:end), where start and end are the range of cells you want to sum. =sum(a1:a3), for instance.

There is probably a more elegant way to do both these things, but I don't use spreadsheets enough to know, I'm afraid.

Submitted by Crysania on Monday, March 9, 2015

Hi there,

Thanks for your help. I am going to the Apple Store to get help with question 3. But thanks so much for your answers to my other questions.