| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
range of cells from + to -
How do you replace a range of cells from a positive value to a negative value.
|
|
#2
|
|||
|
|||
|
range of cells from + to -
Type -1 in some empty cell, and copy it. Select the range you want to
change, and Edit Paste Special. Select the radio button for 'multiply' and click OK. "Lise" wrote: How do you replace a range of cells from a positive value to a negative value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
