How to insert a password in a single column or single row?
How to insert a password in a single column or single row?
You can't, not really.
What you CAN do is UNlock ALL other cells except the ones you want protected...
With the sheet UNprotected
Press CTRL + A to select ALL cells in the sheet
Format - Cells - Protection - UNcheck "locked"
Click OK
Now highlight the cells you DO want to protect (a single column or single row)
Format - Cells - Protection - Check "Locked"
Click OK
Now protect the sheet as usual, making sure to check "select unlocked cells"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks