ADD A DOLLAR VALUE TO ALL DATA

M

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

Don Guillett

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top