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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.