Protection of single cell

  • Thread starter Thread starter Esssa
  • Start date Start date
Using old version of excel....
highlight whole sheet (box in corner between A and 1).
go to format,cell,protectection, untick locked.
go to cell you want to lock. then....
go to format,cell,protectection, tick locked
go to tools,protection,protect worksheet,ok
should be only locked cell in worksheet,
 

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

Excel Protection 2
Protect of Single Row or Column 3
protecting single cell 4
Email (LDAP) data download into a single Excel cell - data separat 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Enter data, move automatically to next unprotected cell 10
Using Group and Outline with Protected Cells 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top