View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default How can I add a fixed value to all cells in a table?

Enter the number in an empty cell (just to be sure, format the cell as
Number FIRST)
EditCopy
Select the cells to be updated
EditPaste special, check Add

--
Kind regards,

Niek Otten

"BMHeiss" wrote in message
...
I simply want to update a table full of values by adding a certain number
to
all cells. How can I do this easiest?

thanks.