We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

Filter Mode Is Stuck on Microsoft Excel

Updated February 21, 2017

Excel 2003 and earlier versions can run across a bug when you choose to filter the information. The message in the status bar becomes stuck on "Filter Mode," instead of displaying how many records were filtered. According to Microsoft, this should only occur when you have over 51 formulas in your list, you have filtered the list, each cell contains a cell reference and Excel changes the status bar before the filter process is complete. While Microsoft never fixed the bug, it has released a workaround.

Loading ...
  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."

  5. Tip

    When you are done filtering your data, you can turn calculation back on by going to the Calculation tab again and selecting "Automatic."

Loading ...

About the Author

Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts. He has published numerous articles in both national and local publications, and online at various websites. He is currently pursuing his master's degree in journalism at Clarion University.

Loading ...