I'm making a price list and Excel 2003 my cost is in the spreadsheet I would
like to add an exact dollar amount to the cost how can I do this without
retyping the entire number for each and everyone. For example in the current
spreadsheet is listed at a certain item cost $100 I would like that to say
$125 the problem is there's over 300 items and if I had to add $25 to each
item I would have to retype each number all 300 I'm looking for a formula
that I can use to add $25 and then just use to fill handle. Secondly I would
like to also be able to do this by just adding a percentage of the original
number instead of a dollar amount for example if the item cost $100 just add
25% of the initial cost to give me a new price of 125

Either can be handled with paste special. To add $25, type 25 in some blank
cell and copy (ctrl+c). Highlight your old prices and Edit > Paste Special,
select Add and click OK.
To add, say 25%, type 1.25 (1 + 25%) in some blank cell and copy. This time
Edit > Paste Special, select Multiply and click OK.

"Jason" wrote:

> I'm making a price list and Excel 2003 my cost is in the spreadsheet I would
> like to add an exact dollar amount to the cost how can I do this without
> retyping the entire number for each and everyone. For example in the current
> spreadsheet is listed at a certain item cost $100 I would like that to say
> $125 the problem is there's over 300 items and if I had to add $25 to each
> item I would have to retype each number all 300 I'm looking for a formula
> that I can use to add $25 and then just use to fill handle. Secondly I would
> like to also be able to do this by just adding a percentage of the original
> number instead of a dollar amount for example if the item cost $100 just add
> 25% of the initial cost to give me a new price of 125