Right-click on the sheet tab and "move or copy".

Select "create a copy" and OK.

Now, on the copied sheet enter 1.10 in an empty cell.

Copy that cell.

Select all other cells and EditPaste SpecialMultipleOKEsc.

All prices will be marked up 10%


Gord Dibben MS Excel MVP


On Tue, 12 Jun 2007 12:09:01 -0700, T-Bone
wrote:

I have a spreadsheet with large amount of pricing from a supplier (3000 cells).

I would like to mutiply those prices by a number and creat a new spreadsheet
for my pricing.

Any help is appreciated