Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default 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