Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting specific cells in a worksheet.
How can I protect certain cells in a worksheet which contain text, and then
allow users to use specific cells without having to create a shared worksheet and password? |
#2
|
|||
|
|||
If you rightclick on all the cells, go to format cells, protection and unlock
them, then selectively lock the cells you want to protect, and finally protect the sheet under the tools bar, that should do it. Beverly "GaryS" wrote: How can I protect certain cells in a worksheet which contain text, and then allow users to use specific cells without having to create a shared worksheet and password? |
#3
|
|||
|
|||
Highlight cells for people to use by Format... Cells...
Protection... uncheck the cell(s) to let people work in them. Protect the sheet next with Tools... Protection. -----Original Message----- How can I protect certain cells in a worksheet which contain text, and then allow users to use specific cells without having to create a shared worksheet and password? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |