For all you Excel Nutters – Small question

[Mathew]

I need to add 2 units to each sell for example
2 to be 4
1 to be 3
3 to be 5
However there are hundreds of cells and I don’t want to do them automatically. Is there any way I can highlight them all and just up the amount by an additional 2? However I don’t want to leave any signs of formulas.
Thanks
Mat

[jsap]

Why not just insert 2 extra columns, in one use =SUM(cell+2), and drag it down to so this sum on all, then copy all the values, in next empty column, right click at top, choose 'paste special', then when you get the dialogue, choose 'values'. This will then paste the result without the forumla making it. Just delete the original number and sum column and you've got what you want. '

[Astaroth]

If you simply want to add 2 to everything in the column you could simply type 2, copy it, select the sells you want to add it to and then do paste special, and select the option Add