Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HowdoIincreasethevalues of aselectedgroup of cells by the same val
I would like to select a group of cells in a column and increase each of them
by 20, how do I do it? |
#2
|
|||
|
|||
Put 20 in an empty cell, copy it, select the cells you want to increase and
do editpaste special and select add Since there is no audit trail you might want to do this on a separate sheet and leave the originals Regards, Peo Sjoblom "V. Szekely" wrote: I would like to select a group of cells in a column and increase each of them by 20, how do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |