Adding a number to all cells

[alosGs]

First of all thanks a lot for this nice site,
and my newbie question

I want to add 10 for example, to all the emements in column A,
lets say there are 200 cells in A column, and need to add 10 to all of them, what can I do?
Thanx

 

[Smitty]

Welcome to the Board!

You can put 10 in an unused cell and copy it. Then highlight the range to add it to and goto Edit-->Paste Special-->Add.

Hope that helps,

Smitty

 

[alosGs]

Thanks a lot pennysaver,
perfect board, perfect sharing