ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Basic Cell Value Multiplication (https://www.excelbanter.com/excel-discussion-misc-queries/182943-basic-cell-value-multiplication.html)

Confusedben

Basic Cell Value Multiplication
 
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?

Mike H

Basic Cell Value Multiplication
 
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

"Confusedben" wrote:

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?


David Biddulph[_2_]

Basic Cell Value Multiplication
 
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.
--
David Biddulph

"Confusedben" wrote in message
...
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?





All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com