Sunday, June 3, 2012

Enable Auto Filter in protected sheet in Excel

In Excel 2010

  • Goto to Review Tab.
  • Select Protect sheet, a dialog box (protect sheet) will appear.
  • Check Use Auto Filter.

No comments:

Post a Comment