View original (French)

Excel add a fixed number to an entire column

jakez -  
 Walhof -
Hello everyone,

basic Excel problem: I want to add 2 to all the cells in my column. It responds with a circular reference error!

How can I get around this?

Thanks in advance.

5 réponses

Réponse 1 / 5
blux Posted messages 5003 Registration date   Status Modérateur Last intervention   3 451
 
Hello,

a very simple way:

- Type the value you want to add in a cell.
- Copy that cell
- Select the range of values to which you want to add
- Do a 'special paste' from the "Edit" menu, and choose in the dialog box: addition
- And there you go!

That's how I switched to euros, with a copy divided by 6.55957 in all my cells...

We can also do many other things with special paste: reverse rows with columns, copy the result of a formula (and not the formula itself)...

See you, Blux 
 "Idiots dare anything. That's how you recognize them"
21
Jakez
 
Thank you Blux, it works.
0
J-R
 
Thank you, sir. Have a nice day.
0