BLOCK CELLS FROM BEING EDITED

  • Thread starter Thread starter Prasad Gopinath
  • Start date Start date
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
 
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

Similar Threads

Linking Spread Sheets 1
problem with fractions to decimal 1
Excel Disallow movement of embedded PDF 2
SET DEFAULT VALUES IN CELL TO RECORD NEGATIVE 3
In Excel, how do I print the cell blocks as well as the data? 2
Drop down box! 1
Change all text on Spread sheet 1
value changes after hitting Tab or Enter button 2

Back
Top