How can I add £1 to each of these items all in one go, I cannot remember the formula at all so any help would be greatly appreciated. I just want to be able to drag down the list so it adds just £1 to each item?
https://ibb.co/7RPvM0y
Increasing the price in the cells by £1 each only. Need Help.
-
- Posts: 1
- Joined: Fri Oct 13, 2023 4:19 pm
Re: Increasing the price in the cells by £1 each only. Need Help.
Good morning,
If you want to add 1 to the numbers located in B3:B10 for example, you enter 1 in cell C2 for example. You copy this cell. You select the range B3:B10, right click, paste special, transpose, calculate, add to destination.
Sincerely,
Mimile
If you want to add 1 to the numbers located in B3:B10 for example, you enter 1 in cell C2 for example. You copy this cell. You select the range B3:B10, right click, paste special, transpose, calculate, add to destination.
Sincerely,
Mimile
- Attachments
-
- Capture 01.JPG (21.6 KiB) Viewed 8150 times