Protect selected column

F

Fareez

Dear Friend
Is there any possibilities to protecet by password only selected column or
cel or row without protecting whole work sheet.
thanks
 
R

Ron@Buy

Yes
Highlight column or cells that you do NOT want to protect then Format Cells
Protection and untick 'Locked' > OK. Now protect the worksheet and you will
Click to expand...
be only be able to make entries in the column/cells that you unlocked.
Hope this helps.
 

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

Protecting Word 2019 document 0
selecting workbook/sheet 3
Hiding columns in a protected sheet 4
Need Help with a VBA subroutine 0
Missing task list row and columns Lines along with Ganttchart non working day color 0
Spell Check Protected WORKBOOK 1
New BUG in Excel 2010? 1
Help linking true false in column to start macros 3

Top