Basic Cell Value Multiplication

C

Confusedben

The new version of excel has me lost. I have 240 cells with different prices
in each. I want to multiply all the cells by 2. How do i accomplish this?
 
M

Mike H

Put 2 in a cell and copy it
Select all your cells to multiply then
Edit|Paste special
select multiply
click ok
delete the 2

mike
 
D

David Biddulph

Put 2 in a spare cell, Copy.
Select the cells you want to multiply. Edit/ Paste Special/ Multiply.
You can now delete the 2 from your spare cell.
 
Top