Protecting a document while still using it

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.


Jolene said:
I am trying to make a document where information can be typed into it,
Click to expand...
without the threat of losing any of my original form.
 
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
 
Back
Top