Hi,
Is there a way to put a password lock on certain cells within a spreadsheet?
Also, is there a way to put password locks on sheets on a spreadsheet?
Many thanks,
Will
Hi,
Is there a way to put a password lock on certain cells within a spreadsheet?
Also, is there a way to put password locks on sheets on a spreadsheet?
Many thanks,
Will
To protect cells, highlight the range of cells you DON'T want protected, then right click, click the protection tab and uncheck the Locked box then you have to protect the sheet.
To protect the worksheet, right click the worksheet tab then click protect and enter a password 2x
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks