Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection and filters

Protection and filters

ResolvedVersion 2007

Thu 23 Sep 2010, 17:24 Delegate Liz said...

Liz has attended:
SharePoint course

Protection and filters

Hello

When we apply protection we seem to lose the facility to use data filters....is there any solution to this problem please?

Tue 28 Sep 2010, 14:12 Trainer Jacob said...

RE: protection and filters

Dear Liz

Further to your forum post we would need to see your working files and an itemised list of the issues you are facing.

We can then review and see if we can assist. If we can find a solution we will let you know the scope of work and any associated costs to complete.

Please feel free to send the files to me direct.

Regards

Jacob

Tue 5 Oct 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips

Protection and filters

Protection and filters

RE: protection and filters

Excel articles

Excel tip:

Hiding Formulae in the Formula Bar