| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiplication of a blank cell | Excel Worksheet Functions | |||
| Basic Cell / Formula Copy Using a Step | Excel Discussion (Misc queries) | |||
| Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
| Multiplication in one cell | Excel Discussion (Misc queries) | |||
| How do I run a Macro on basic of a value in a specific cell | Excel Worksheet Functions | |||
Hybrid Mode
