LinkBack URL
About LinkBacks
internova 
Can someone tell me it is posible to increase cels value (diferent values) from D2 to D21 for example, by 20. I just start to use excel. Thank you.
Can someone tell me it is posible to increase cels value (diferent values) from D2 to D21 for example, by 20. I just start to use excel. Thank you.
Last edited by internova; 03-12-2009 at 07:58 AM.
re: Increase value in group of cells
Good afternoon internova
...and welcome to the forum!!
Type 20 into an empty cell somewhere - anywhere will do and you can delete it after.Originally Posted by internova
Right click the cell containing "20" and select copy
Highlight rows D2:D21, then right click the highlighted cells and click Paste Special
In the dialog box select add and click OK
Delete your "20".
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
But if you think to add different values every time you want best way could be to define some cell (for example B1 where you will type value) and in E row to add =$D2+$B$1 (and extend formula from E2 to E20 (or how big your column is)
Instead of 999 you can write any number...
What to add >>> 999 43 1042 6 1005 34 1033 76 1075 344 1343 75 1074 2 1001 465 1464 0 999 65 1064 54 1053 1754 2753 78 1077 54 1053 23 1022 757 1756 545 1544 18765 19764 54 1053
Never use Merged Cells in Excel
Re: Increase value in group of cells
Maybe more explanation, in cutting list in cabinetry sometimes need to be change width or depth of the cabinet. Instead deleting and taping new values I need to know if it’s possible to change the values in easy way. (Group of cells by the same value). Usually added.
ZBOR’s solution working perfect but is bit complicated.
DOMINICB solutions is simple, perfect for me but I think not working in 2007 excel. In Paste Special dialog box is not add to select instead come with Unicode text or Text to select.
Any other ideas?
Works for me in Excel 2007...
Make sure what you are copying is actual cell entries and not text box or something like that.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
It works on 2003 too. The option is in "Operation" part of Paste Special.
Work perfect, Geate site, Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks