Basic Cell Value Multiplication

  • Thread starter Thread starter Confusedben
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - Selection Instead of Range 2
Sumproduct 3
Excel 2007 compatibility issue - speed between cells 2
Calculation based on lowest price 6
VLOOKUP 2
If Statement for Pricing 3
simple formula help in Excel 2007 2
How to synchronize all cell values? 1

Back
Top