 |
 | 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 / Worksheet Functions / January 2008whole price sheet change
Hi, I am trying to change a cost price list into a retail price is there a simple way to change every single price on a sheet without having to do each one individually ? Many thanks Michael Try on a copy of your file first........... Maybe put 1.1 in a helper cell somewhere and do Copy .....then highlight your prices and do Rightclick > PasteSpecial > Multiply.......this will raise them all 10% Vaya con Dios, Chuck, CABGx3 > Hi, > I am trying to change a cost price list into a retail price is there a [quoted text clipped - 4 lines] > > Michael thanks for the fast reply, i might sound slightly slupid here but what is a helper cell? > Try on a copy of your file first........... > [quoted text clipped - 14 lines] >> >> Michael A "helper cell" is an unused cell in your worksheet that you are going to use temporarily and then delete its contents after you no longer need it. So, for the process that Chuck gave you... put 1.1 in an unused cell and then press Ctrl+C (or pick Edit/Copy from Excel's menu bar); then highlight the cells you want to increase in value be 10% and select Edit/PasteSpecial from Excel's menu bar (or from the popup menu that appears on a right-click); then pick the Multiply option button on the dialog box that appears and OK your way back to the sheet. You can now unselect and delete the "helper cell" (which we needed only temporarily for use by the PasteSpecial process). Rick > thanks for the fast reply, i might sound slightly slupid here but what is > a helper cell? [quoted text clipped - 17 lines] >>> >>> Michael Good example Chuck but from cost to retail is more like 100% in my experience<g> Gord >.this will >raise them all 10% |
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.