freezing a cell or cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

doug - 23 Feb 2007 03:06 GMT

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?

Reply to this Message

Jason - 23 Feb 2007 03:41 GMT

Hi, Doug.

One way to do this is the following:

CTRL + a (selects all cells)
CTRL + c (copy)
Edit > Paste Special, then select Values and OK.

This will remove all formulas.

HTH

Jason

> 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
[quoted text clipped - 4 lines]
>
> Is there a command/function within excel to do this?

Reply to this Message

doug - 23 Feb 2007 12:28 GMT

Jason, thanks a lot. It works like a charm and exactly what I wanted.

--doug--

>Hi, Doug.
>
[quoted text clipped - 18 lines]
>>
>> Is there a command/function within excel to do this?

Reply to this Message