Office Settings & Configuration

Fix Grayed-Out Sort and Filter Commands in Excel 2016

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

The user needs to restore access to the Sort and Filter commands in Excel 2016.

Fix Grayed-Out 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.
Before you start

Check whether a yellow Protected View bar appears above the worksheet. Enable editing only if you trust the file and its source.

Solution 1Recommended

Enable Editing in Protected View

Use this method when the workbook displays a Protected View warning bar.

1
Find the warning bar

Open the workbook in Excel 2016 and look for the yellow Protected View bar above the worksheet.

2
Enable editing

If you trust the file and its source, select Enable Editing on the warning bar.

3
Check the commands

Select a cell in the data range, open the Data tab, and check whether Sort and Filter are available.

Enable Editing in Protected View
Free Microsoft Office alternative

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.

Sort and filter spreadsheet data in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar interface that makes switching from Excel easierFree and lightweight office suite
microsoft office alternative - wps office

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.