Questions about using Numbers on the Mac

By Crysania, 3 March, 2015

Forum
macOS and 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

By Zack on Monday, March 16, 2015 - 14:38

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.

By Crysania on Monday, March 16, 2015 - 14:38

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.