how do you lock individual cells?

  • Thread starter Thread starter drewmacher
  • Start date Start date
drew

By default all cells on a worksheet are "locked" when Tools>Protection>Protect
Sheet is enabled.

To lock just a few cells, hit CRTL + A which selects all cells, then
Format>Cells>Protection>uncheck "locked".

Now select the cells you want locked and Format>Cells>Protection>check
"locked".

Now Tools>Protection>Protect Sheet. Provide Password if desired.

Note: sheet protection passwords can be easily broken, so the "locking" is for
protection from inadvertant overwrite only.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Macro / Programming to lock cells 1
Lock specific cell 1
HOW DO I LOCK CERTAIN CELLS 2
Lock cells conditionally formatted in 2007 1
lock cell 1
Locking Cells 2
Protecting a Sheet 7
How unlock locked cells 2

Back
Top