Worksheet Protection

N

nhen5

When I protect my worksheet, I need to only be able to filter through the
worksheet to only those 6 cells I gave Data Validation to. Can you please
save me?
 
S

Sunday88310

Format Cells Dialog Box (Protection)
Protect worksheet , Then Select the cells that can be changed Click
Format click cells click the protection tab on the protect cells dialog box
Click the locked cells so the check mark is removed, this will unlock the
selected cells so changes can be made to them click ok Click tools,
protection and then click protect sheet, fill out the last dialog box by
using the default options.
Good Luck
 
Top