View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default increase existing cells

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...
--
HTH...

Jim Thomlinson


"Basikstylz" wrote:

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?