CONVERTING NET PRICES ON A PRICE SHEET TO LIST PRICES

[CMEADOR]

I HAVE A PRICE SHEET WITH 1500 NET PRICES IN COLUMN "C". I WANT TO USE A 2X MULTIPLIER TO MAKE A LIST PRICE SHEET WITHOUT HAVING TO USE:"=PRODUCT(NET PRICE)*2" REPEATEDLY FOR EACH PRICE CHANGE. WHAT FORMULA CAN I USE TO DOUBLE ALL THE NET PRICES IN COLUMN 'C" WITH ONE ENTRY?
THANKS,
CHUCK

 

[Aladin Akyurek]

Enter 2 in an empty cell, copy this cell, select all of the net prices, activate Edit|Paste Special >Multiply.