Formula
Not sure what you mean by not 'being visible'...
but to add 0.01 to all cells enter 0.01 in any unused cell
Copy the cell
press CTRL-A in the worksheet you want to select ALL
Right-click and choose Paste Special and choose ADD
Click OK
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...
"T-Bone" wrote:
I would like to take a large spreadsheet and add 0.01 to each cell in it
without that being visable to others when I distribute the spreadsheet to
others?
Thanks
|