Protect column

  • Thread starter Thread starter Cindy Conover
  • Start date Start date
C

Cindy Conover

Is there a way in Excel 2002 SP3 to protect certain columns so employees do
not mess up and formulas?

TIA

Cindy
 
By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

Select all cells and unlock them.

Select the cells to be locked and lock them

Then Tools>Protect>Protect Sheet.

Note the selectable options under "allow users to" when protecting.


Gord Dibben MS Excel MVP
 
Wonderful. I know there was a way but I could not figure it out. Thanks so
Much

Cindy
 
Back
Top