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.

User profile for user: Gavmeo
Gavmeo Author
User level: Level 1
4 points

Numbers - How do I add a value to multiple cells in a column

OK, so I buy in lots of different products and have a list of products with their value to me in a column (example in column D)


I would like to be able to add a fixed amount to each product for example add £0.22 to each item.


I could easily do this in Excel (before Catalina upgrade) by adding an amount to a cell lower down - example 0.22 - copying the amount


then selecting the column with all the prices then select paste special - then add values ...


this automatically changed all selected values ... example


£0.66 - changed to £0.88

£0.56 - changed to £0.78

£0.46 - changed to £0.68


Often I get 50+ products and could change all 50 values in seconds.


I would like to try Numbers for Mac - as I don't want to be forced into subscribing to Microsoft Office


Thanks in advance




iMac Pro

Posted on Jan 25, 2020 1:25 AM

Reply
Question marked as Top-ranking reply
User profile for user: Wayne Contello
Wayne Contello
User level: Level 7
26,583 points

Posted on Jan 25, 2020 5:33 AM

create an extra column



In the new column "Revised Price" enter the formula as shown:


select cell B2, then type (or copy and paste from here) the formula

=A2+0.22



select cell B2, copy

select column B by:

1) clicking the column header B, then unselect the first cell in column B by holding the <command> key and single click cell B1 OR

2) select cell B2, then hold the shift key and type the key combination <command> + <down arrow>


copy


select column A by:

1) select column A, then unselect the first cell, OR

2) select cell A2, then hold the shift key and type the key combination <command> + <down arrow>


paste using the menu item "Edit > Paste Formula Result" or use the key <command> + <shift> + v

View in context

Similar questions

3 replies
Question marked as Top-ranking reply
User profile for user: Wayne Contello
Wayne Contello
User level: Level 7
26,583 points

Jan 25, 2020 5:33 AM in response to Gavmeo

create an extra column



In the new column "Revised Price" enter the formula as shown:


select cell B2, then type (or copy and paste from here) the formula

=A2+0.22



select cell B2, copy

select column B by:

1) clicking the column header B, then unselect the first cell in column B by holding the <command> key and single click cell B1 OR

2) select cell B2, then hold the shift key and type the key combination <command> + <down arrow>


copy


select column A by:

1) select column A, then unselect the first cell, OR

2) select cell A2, then hold the shift key and type the key combination <command> + <down arrow>


paste using the menu item "Edit > Paste Formula Result" or use the key <command> + <shift> + v

Reply

Numbers - How do I add a value to multiple cells in a column

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