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?

Enter 30 in a cell. EditCopy
Select your cells to be updated, EditPaste Special, check Add.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sn0wman" wrote in message
...
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?

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

"Sn0wman" wrote in message
...
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?

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.

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.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sn0wman" wrote ...
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.