You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Basic copying of a formula in Numbers

How can I copy the sum formula at the bottom "total" row of one column of numbers across the entire total row to show the sums of all the columns in the spreadsheet.


I'm so frustrated. In Excel it couldn't be more simple. You just highlight the cell and drag it across the entire formula and all the cells populate with the totals. I've tried that with Numbers and it doesn't work.

iMac 27″, macOS 10.15

Posted on Dec 23, 2021 10:14 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 23, 2021 10:20 AM

Same as with Excel except in Numbers you drag on the little yellow circle on the edge of the selection box, not the circle in the corner. The yellow circle appears when you put the pointer on/near an edge.

2 replies

Basic copying of a formula in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.