+ Reply to Thread
Results 1 to 4 of 4

i a have locked my columns but it is not allowing filter option please let me know how

  1. 12-02-2014, 02:35 AM #1
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i a have locked my columns but it is not allowing filter option please let me know how

    please let me know how to Allow filtering in an protected Sheet when excel columns are locked

    Please Login or Register  to view this content.
    Last edited by baig123; 12-02-2014 at 03:00 AM. Reason: paragraph
    Reply With QuoteRegister To Reply
  2. 12-02-2014, 02:51 AM #2
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: locked my columns but filter option in excel are disabled let me know how to release

    While Locking the sheet Using the option " Protect sheet ", there is a checkbox ie. "Use autofilters" which needs to be check to make the filters work in protection mode.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  3. 12-02-2014, 03:30 AM #3
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i a have locked my columns but it is not allowing filter option please let me know how

    let me know where to go checkbox because i am new for excel
    Reply With QuoteRegister To Reply
  4. 12-02-2014, 07:59 AM #4
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: i a have locked my columns but it is not allowing filter option please let me know how

    Try this then..

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Excel 2007 - option to set password to open disabled?
    By imbubbling in forum Excel General
    Replies: 7
    Last Post: 07-24-2008, 01:47 AM
  2. [SOLVED] Suggestion to add Auto Filter option for columns
    By Firoz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-21-2006, 12:35 AM
  3. option button disabled
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2006, 03:00 PM
  4. Why is my sort menu option disabled?
    By Valerie M in forum Excel General
    Replies: 2
    Last Post: 10-20-2005, 05:05 PM
  5. Excel sort option disabled--file name followed by "group" at top .
    By Margaret in forum Excel General
    Replies: 1
    Last Post: 04-07-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1