Skip to main content
Home

Main navigation

  • Apps
  • Forum
  • Blog
    • Podcast
    • Guides
    • Hardware & Accessory Reviews
    • Bug Tracker
    • Developer Resources
  • Log in

Breadcrumb

  1. Home
  2. Forums
  3. macOS and Mac Apps

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

  • Log in or register to post comments

Comments

A couple Answers

By Zack

8 years 1 month ago

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.

Thanks for your help

By Crysania

8 years ago

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.

More Like This

question about speech central and generating audio (Forum Topic)
Are there new things for Braille in iOS 16? (Forum Topic)
Question About Multitrack Recording (Forum Topic)
Changes in voices (Forum Topic)
Accessible Sudoku (iOS and iPadOS App Directory)
New VoiceOver features in iOS 16 beta (Forum Topic)
Announcing Changes to Our Guidelines Regarding Discussion of Beta and Preview Versions of Apple Software (Blog Post)
Any recommendations for a hard case for my new MacBook Pro 14, 2021? (Forum Topic)

Site Information

  • About
  • Club AppleVis
  • FAQ
  • Contact

Unless stated otherwise, all content is copyright AppleVis. All rights reserved. © 2023 | Accessibility | Terms | Privacy