Change all values in an excel column at once?

[Guest]

I have an Access database I'm attempting to modify a bit in Excel. It has
over 16500 rows. I want to add 30 to all 16500+ values in a certain column.
Is there any way to do this in one step, or am I doomed to manually change
them one at a time?

 

[Niek Otten]

Enter 30 in a cell. Edit>Copy
Select your cells to be updated, Edit>Paste Special, check Add.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Paul B]

Sn0wman, put 30 in a cell, copy it, select the cells you want to add 30 to,
right click and paste special, under operation check add, OK.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you both very much. Exactly the info I was looking for, and I was
having trouble weeding through over 420,000 hits on Google to find it.

 

[David McRitchie]

I'd expect if you'd wanted to multiply instead of add and limited yourself
to Excel newsgroups, there would have been less hits and the answers
would have been faster to go through and more of them would be about the same.

Also the word "change" in your question could perhaps of been better
as "add a constant to" . Which having tried searching Google you
should appreciate having a subject as descriptive as possible with
what you know.

Any way, glad you got your answer, and for those that answer questions
it is a lot nicer to know that you tried to look up a solution first before
posting. To make it more friendly for those answering, I like to see
a person's real name.