Protecting a document while still using it

[Guest]

I am trying to make a document where information can be typed into it, without the threat of losing any of my original form.

 

[W L]

The cells that you want to be able to type into can be unlocked by
formatting the cell. Choose Format/Cell then click the Protection tab and
uncheck the box marked "Locked" You can then protect your workesheet and
only the unlocked cells will be available for change.

I am trying to make a document where information can be typed into it,

without the threat of losing any of my original form.

 

[Gord Dibben]

Jolene

Using worksheet protection you can prevent changes to many Excel functions
such as formatting, overwriting cells, sorting, filtering and others. Some
cells can be left unprotected for data entry.

Using workbook protection you can prevent changes to windows and structure.

These protection schemes can be passworded.

NOTE: worksheet and workbook passwords can easily be broken so there is no
real security in Excel.

Gord Dibben Excel MVP