View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
doug doug is offline
external usenet poster
 
Posts: 5
Default freezing a cell or cells

I want to archive a spreadsheet (and freeze those cells that want to
update itself) so that when I access it one year later, it no longer
updates the cells that have functions like " =today() ". I would
want to freeze those particular cells so that when I froze those
cells, they show the last date when frozen. I guess it would be as if
the spreadsheet became a text file.

Is there a command/function within excel to do this?