| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I Need to divide all cells in rows 2 and 3 by 100
Merry Christmas,
I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this? |
|
#2
|
|||
|
|||
|
put 100 in a cell, copy it, select row 2 and 3, do editpaste special and
check divide Regards, Peo Sjoblom "Brent E" wrote: Merry Christmas, I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this? |
|
#3
|
|||
|
|||
|
Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and
click edit | paste special | multiply. "Brent E" wrote: Merry Christmas, I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this? |
|
#4
|
|||
|
|||
|
Oops, I meant put "=1/100" ...
"Brandt" wrote: Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and click edit | paste special | multiply. "Brent E" wrote: Merry Christmas, I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| How do you select two cells in different rows and columns with ou. | Excel Discussion (Misc queries) | |||
| Unhide rows | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
Linear Mode
