ADD A DOLLAR VALUE TO ALL DATA
 

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
???

ADD A DOLLAR VALUE TO ALL DATA
 

one simple way
put 1 in a cellcopy that cellselect all cells to
changeeditpastespecialadd

--
Don Guillett
SalesAid Software

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

ADD A DOLLAR VALUE TO ALL DATA
 

Place 1 in an unused cell.

Copy that cell.

Select the cells to change and EditPaste Special(in place)AddOKEsc

Delete the 1 from the cell.


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 15:40:02 -0800, mastequila
wrote:

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
???