Multiple sheets are selected, the most likely reason the Sort & Filter icon is grayed out. Another reason the Sort and Filter icon is disabled is because the sheet is protected. … To protect a sheet, go to the Review tab and click Unprotect Sheet.
Why is the sort function grayed out in Excel?
The sorting problem probably occurs because your data is part of an array. If you select an entire column, you are actually selecting the table and all cells unrelated to that table. If you convert the array to a range, you can sort the entire column.
How to enable sorting and filtering in Excel?
To sort alphabetically:
- Select a cell in the column you want to sort (in this example we select a cell in column A).
- Click the Sort & Filter command in the Editing group of the Home tab.
- Choose Sort A to Z. Now the information in the Category column is sorted alphabetically.
Why can’t I sort in Excel?
Wrong selection. If you select the wrong rows and columns, or select less than the full range of cells that contain the information to sort, Microsoft Excel cannot arrange your data as you want. … When you open the Sort dialog, you will see a selection box with the data that Excel will arrange.
Why isn’t my filter working in Excel?
To fix this, just reapply the filter. If this doesn’t solve the problem and your Excel filters still don’t work, clear all filters from a worksheet and then reapply them. If your dataset contains blank rows, manually select the entire range with the mouse and then apply the auto filter.
How to Unlock Grayed Out Menu in Excel 2016?
Click on the “Home” menu and then select “Format” on the “Cells” tab. Select Unprotect Sheet from the Protection section of the drop-down menu to unlock the spreadsheet. If the worksheet is password protected, Excel will not unlock the menus until you type your password.
How to enable sorting in Excel?
To sort a range:
- Select the range of cells you want to sort. …
- Select the Data tab on the ribbon and then click the Sort command.
- The Sort dialog box appears. …
- Decide on the sort order (ascending or descending). …
- When you are happy with your selection, click OK.
- The cell range is sorted by the selected column.
Why won’t Excel let me sort and filter?
If the Filter button is greyed out, check if your worksheets are not grouped. You can tell if this is the case by looking at the title bar, which shows the filename at the top of the screen. If you can see your filename group, you currently have spreadsheets grouped.
How do I automatically reapply the filter?
Right-click your sheet’s name, select View Code, and paste the following code. After pasting, click the Excel icon under File in the top left or type AltF11 to return to the spreadsheet view. This will enable automatic updating. Remember to save the file in a format that supports lie macros.