add 1

E

excelled

I havent used excel in a while and am stuck on what i thought was easy
doh any help appreciated

want columns to add 1 even if it is just adding 1 to the corresponding
value in the left column it would be a great help e.g.

Karen 1 2 3 4 5
Frank 6 7 8 9 10

Cheers
 
D

davesexcel

If you enter a formula and then fill it across the columns this should
work
if Coluimn A has a name then column B will have a number and column C
will have this formula
=B1+1

copy the formula across the columns and it should work for you
 
Top