Problem in Excel

[spotit3]

Can anyone tell me how I can add �500 to a row of figures in Excel say B16 to N16, I think it is something to do wuth Paste Special. All help greatly appreciated.

[weeal]

eh? lol

you dont want in shown in the column? cnat you add it to the formula?

[hippyhoppy]

lol - weeal... adorable!!

[weeal]

haaaaaaaaaaa im wee bit tidly

[hippyhoppy]

LOL - thought so!! Have you seen Stu tonight? hilarious!!! go and check it out!!

[weeal]

way out
ok

[spotit3]

There is no formula in the cell at present. I would really appreciate help on this please.

[ChuckFickens]

Probably several ways to do it.... I would insert a new column next to the one you want to add the �500 to and then in the top cell next to the first figure enter the formula =a1+500 (change cell number to suit) then copy that formula and paste it into the entire column, then copy the contents (not the formula) of the new column and paste it into the original column. You can now delete the new column you created

Does that make sense??

Oh and just realised you said row.... it would work for rows too, just insert a new row instead obviously.

[weeal]

Go chuck ^^ go chuck ^^

[hippyhoppy]

oooh - get Chucky - all professional.. while me and weeal are lushes!!! (ahem, full monty!?!)

[weeal]

weeal is howling lauching at stu baby

[hippyhoppy]

right - my next husbands: - chucky/stu/baz/steve.. can I become a (insert correct religion that allows more than one spouse) ?

Why can I hear Coldplay in my head..? lol

[weeal]

i know it cameon the radio going to work and i heard STU sing it

[ChuckFickens]

Thought I'd have a go at a sensible answer while I still can ;)

Stu is a hero :) and I will attempt to find a copy of the full monty for all (then go into hiding!!!)

;-)

[weeal]

in my head

sorry spotit3 sorry pal we will go now

[hippyhoppy]

Chucky - you can hide here at No. 30!!

[spotit3]

Thank you very much ChuckFickens. Your help is really appreciated.

[weeal]

aem...or No 14

[hippyhoppy]

oops - me and weeal are very sorry (why do I feel like I'm in the headmistresses office at Millais!) :-(

[weeal]

i know we didnt get a thanks, nbot even for the laugh

[bensmum]

You certainly can't hide here Chuck ;-)