How do I protect one cell in a spreadsheet?

T

tbenson37303

How do I protect one cell in a spreadsheet (where approval by a specific user
will be given) and leave the rest of the sheet open to other users? I've
tried using the directions 'Protect worksheet or workbook - Give specific
users acess to protected ranges'. This does not allow other users to use the
sheet if the cell is protected and once the sheet password is used the
protected cell opens. Someone please help>>>>
 
F

Frank Kabel

Hi
first select all cells for which you want allow access
- goto 'Format - cells - Protection' and uncheck 'Locked'
- now protect the worksheet

--
Regards
Frank Kabel
Frankfurt, Germany

"(e-mail address removed)"
 

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

How do I protect cells or a range of cells in excel spreadsheet? 1
allow a user to edit ranges in a protected worksheet 3
External cell reference between two excel worksheets both in One Drive 0
hide columns on a protected sheet 2
Sheet Protection / Edit Objects 1
Protected cells can't be grouped 1
Sheet Protection / Edit Objects 0
Insert/ delete row in protected worksheet 6

Top