Protecting Worksheets which contain filters

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Victoria has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Victoria [14 posts] (2008 Mar 4 Tue, 14:47) Reply

Dear Best Training,

Please could you tell me if it is possible to protect a worksheet but still be able to use filters on the worksheet?

Thank you very much.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Protecting Worksheets which contain filters

by - trainer Mark gold contributer [180 posts] (2008 Mar 6 Thu, 14:49) Reply

Hi Victoria

It is very possible to do this specific task and, here's how
when you go to the tools menu and then protection and, protect sheet. From the window that appears relating to protection scroll down the list and things users can do, and then tick use auto filters then add your password if you want one, then confirm the password and click OK

This should work for you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East
mark@microsofttraining.net

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Customized Financial Excel Courses in London
· Database Tips from an Excel Training Course
· Excel Macros for the Non-Programmer
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips