excell values

how do i increase all values in workbook by a fixed amount?

LambdaTS, Put your fixed amount in an unused cell, copy that cell then
select the cells you want to increase then edit paste special and under
operation pick 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

"LambdaTS" <LambdaTS@discussions.microsoft.com> wrote in message
news:A0F9017A-01FC-46A1-93D5-A0459416662C@microsoft.com...
> how do i increase all values in workbook by a fixed amount?

1. in an un-used cell, enter the fixed amount
2. select the cell and pull-down:
Edit > Copy
3. select the cells you want to increase and pull-down:
Edit > Paste Special > and check the Add option

This will add the fixed amount to all the cells you have selected in step 3
--
Gary's Student


"LambdaTS" wrote:

> how do i increase all values in workbook by a fixed amount?