ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HowdoIincreasethevalues of aselectedgroup of cells by the same val (https://www.excelbanter.com/excel-discussion-misc-queries/10415-howdoiincreasethevalues-aselectedgroup-cells-same-val.html)

V. Szekely

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?

Peo Sjoblom

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?



All times are GMT +1. The time now is 09:12 AM.

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