ADD A DOLLAR VALUE TO ALL DATA

[mastequila]

If I have a shipping spreadsheet that has a shipping
cost shown by weight on the left and zone on the top , how can i select all
fields and add a certain dollar amount to every field ???

For example
Zone 1 zone 2
1Lb 1.00 2.00
2Lb 2.00 3.00
3Lb 3.00 4.00

How do I select all the shipping fees and add say 1.00 to the current rates
???

 

[Don Guillett]

one simple way
put 1 in a cell>copy that cell>select all cells to
change>edit>pastespecial>add

 

[Gord Dibben]

Place 1 in an unused cell.

Copy that cell.

Select the cells to change and Edit>Paste Special(in place)>Add>OK>Esc

Delete the 1 from the cell.


Gord Dibben MS Excel MVP