How do I freeze data in the spreadsheet so no one can change it?
 

I have store daily sales in a spreadsheet then another sheet that breaks the
daily sales into monthly catagories. Once the month is over, I want to keep
this data frozen. So if I accidently put todays data in the wrong month I
want excell to tell me, "sorry stupid, you already froze this data and can't
change it!" Is this possible?

How do I freeze data in the spreadsheet so no one can change it?
 

gbbmech13,

Try this:

1. Select all cells in the worksheet (CTRL-A)
2. Format-Cells, in the Protection Tab, UNCHECK the "Locked" checkbox.
Click OK
3. Tools-Protection-Protect Sheet. Supply a password if you like, but
make sure you don't forget the password.

Now, at the end of the month, select the cells that you want "frozen".
Then, Format-Cells, in the Protection Tab, CHECK the "Locked" checkbox.


"gbbmech13" wrote:

I have store daily sales in a spreadsheet then another sheet that breaks the
daily sales into monthly catagories. Once the month is over, I want to keep
this data frozen. So if I accidently put todays data in the wrong month I
want excell to tell me, "sorry stupid, you already froze this data and can't
change it!" Is this possible?

How do I freeze data in the spreadsheet so no one can change i
 

I forgot, you need to unprotect the sheet first before you can lock/unlcok
the cells. So, at the end of the month, Un protect the sheet, select the
cells that you want "frozen" and lock them. Then protect the sheet again.



"Vergel Adriano" wrote:

gbbmech13,

Try this:

1. Select all cells in the worksheet (CTRL-A)
2. Format-Cells, in the Protection Tab, UNCHECK the "Locked" checkbox.
Click OK
3. Tools-Protection-Protect Sheet. Supply a password if you like, but
make sure you don't forget the password.

Now, at the end of the month, select the cells that you want "frozen".
Then, Format-Cells, in the Protection Tab, CHECK the "Locked" checkbox.


"gbbmech13" wrote:

I have store daily sales in a spreadsheet then another sheet that breaks the
daily sales into monthly catagories. Once the month is over, I want to keep
this data frozen. So if I accidently put todays data in the wrong month I
want excell to tell me, "sorry stupid, you already froze this data and can't
change it!" Is this possible?