increase existing cells

B

Basikstylz

I have a spreadsheet which has cells that I have already filled several cells
with numbers. Now I need to increase the cells by the same amount, say 10.
how can I increase all the cells without having to key them by hand?
 
E

Erin Searfoss

By using the Paste Special Add feature.

Type 10 in a cell of to the side somewhere. Copy that cell. Highlight the
cells you want to increase by 10, right click to get the shortcut menu,
choose Paste Special, select Values and Add, clidk OK. Delete the 10 you
typed.

Good luck.
Erin
 
J

Jim Thomlinson

Place the amount to incerease by (10 in your example) in any empty cell. Copy
that cell. Select the range you want to increase and select Edit | Paste
Special -> Add. Now just delete the cell with the 10 in it...
 
G

Gord Dibben

Enter 10 in an unused cell.

Copy that cell.

Select your range of cells to change and Edit>Paste Special>Add>OK>Esc

Delete the cell with 10.


Gord Dibben MS Excel MVP
 
Top