Filter Mode Is Stuck on Microsoft Excel

1. Select the column or columns, by clicking the letters at the top of the spreadsheet, that you have filtered. Click the 'Data' menu at the top of the window, move your mouse over 'Filter,' and select 'AutoFilter.' This will remove the filter from your data.
2. Click the 'Tools' menu, then select 'Options' from the drop-down menu. Select the 'Calculation' tab at the top of the Options window.
3. Click the box next to 'Manual,' and click 'OK' to close the window. Excel will no longer perform calculations automatically.
4. Select your data, and click the 'Tools' menu. Move your mouse over 'Filter,' and select 'AutoFilter.' Click the arrow at the top of the column that you want to you for filtering your data. Select your desired option, and the data will be filtered, but the message in the status box will tell you how many records you have filtered, instead of being stuck saying 'Filter Mode.'