BLOCK CELLS FROM BEING EDITED

P

Prasad Gopinath

I have a spread sheet where I need block the values of certain cells from
being edited by my team. At the same time I would like them to have the
rights to edit most of the other cells in the spread sheet.

Could anyone throw some light on how we can do this.


Prasad
 
G

Gord Dibben

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.

Then Tools>Protect>Protect Sheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top