MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Parts List


Posted by Stan on October 17, 2001 11:26 AM

I need to be able to select the prices, and increase them by a cetain percent (5% example). How can I do this without having to add another row or formula?


Posted by Mark W. on October 17, 2001 11:28 AM

Use Paste Special Values to multiply your prices
by 1.05.

Posted by Stan on October 17, 2001 3:39 PM

I am using Excel 2000, I could not find an option that said "Paste Special Values" only Paste Special?

Posted by Mark W. on October 18, 2001 1:02 PM

Values" is one of the options found on the Paste
Special dialog. Specifically, here are the steps:

1. Enter 1.05 into an unused cell and Copy it.
2. Select the cells containing your prices.
3. Choose the Edit | Paste Special... menu command
4. Click the "Values" and "Multiply" radio buttons.
5. Press [ OK ].