ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I add a fixed value to all cells in a table? (https://www.excelbanter.com/excel-worksheet-functions/65483-how-can-i-add-fixed-value-all-cells-table.html)

BMHeiss

How can I add a fixed value to all cells in a table?
 
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.

Niek Otten

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.





All times are GMT +1. The time now is 07:04 PM.

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