how do I lock only a few cells in Excel within a worksheet?

F

Franz Verga

"Locking cells in Excel" <Locking cells in (e-mail address removed)>
ha scritto nel messaggio

I think you should tell us what do you mean with lock in the specific case
.... And give us an example of which cells you want to lock...

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
G

Gord Dibben

By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and Format>Cells>Protection.
Check "locked" and OK

Tools>Protection>Protect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP

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

Add formatting to all pages in workbook 1
Bound Controls on UserForms lock Worksheet cells 3
ow do I lock up certain cells in a worksheet? 1
how can I lock/unlock a range of cells depending on state of a checkbox? 4
I have a workaround 0
HOW DO I LOCK CERTAIN CELLS 2
how do I lock cells in a table? 2
How do I lock/protect cells so they can't be changed 2

Top