Anna has attended:
Excel Advanced course
Freezing data
how do you freeze all live data in a worksheet?
RE: freezing data
Hi Anna:
If by 'freezing data' you mean you want to prevent cell values or formulas from being overwritten, select:
Tools/Protection/Protect Sheet...
Enter a Password (this is optional) and click Okay. Since all cells are locked by default you will then be unable to change any cell.
If you want to protect only some cells, and leave others available for entry, before protecting the sheet you need to select the cells you want to remain unprotected and select:
Format/Cells/Protection and remove the tick from 'Locked'.
Hope this helps. Post back if you need further help.
Regards,
Tony Gay.