 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006ADD 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 ??? one simple way put 1 in a cell>copy that cell>select all cells to change>edit>pastespecial>add  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > 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 [quoted text clipped - 10 lines] > rates > ??? 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 >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 [quoted text clipped - 8 lines] >How do I select all the shipping fees and add say 1.00 to the current rates >???
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.