Fix Grayed-Out Sort and Filter Commands in Excel 2016
Question details
The user needs to restore access to the Sort and Filter commands in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- The user wants to sort or filter data in a workbook opened from email or File Explorer.
- Observed behavior
- Sort and Filter are grayed out, although Advanced Filter may still be available.
Check whether a yellow Protected View bar appears above the worksheet. Enable editing only if you trust the file and its source.
Enable Editing in Protected View
Use this method when the workbook displays a Protected View warning bar.
Open the workbook in Excel 2016 and look for the yellow Protected View bar above the worksheet.
If you trust the file and its source, select Enable Editing on the warning bar.
Select a cell in the data range, open the Data tab, and check whether Sort and Filter are available.

Check Worksheet Protection and Workbook Access
Use these checks if Sort and Filter remain unavailable after you enable editing.
Sort and Filter Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and use WPS Spreadsheets to sort and filter data as you move between office suites.

Frequently Asked Questions
Why are Sort and Filter grayed out when Advanced Filter is available?
The workbook may be in Protected View, which can restrict editing commands. Look for the yellow warning bar and select Enable Editing if you trust the file.
How do I know whether my worksheet is protected?
Open the Review tab and look for Unprotect Sheet. If that command appears, the worksheet is protected; you may need a password to remove protection.
What should I check if there is no Protected View bar?
Check the Review tab for worksheet protection and the title bar for Read-Only. Also press Enter or Esc to leave cell-editing mode, select a cell in the data range, and try the commands on the Data tab.
Can I sort and filter an Excel workbook in WPS Office?
Yes. Open a compatible XLSX or XLS workbook in WPS Spreadsheets, select the data range, and use the sorting or filtering commands on the Data tab.




