View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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
???