Excel Filtering Not Working

Excel Filtering Not Working

Resolution: Turn off filter, select all cells in the sheet and turn the filter back on.

Navigate to and select Data tab


Select Filter if it is highlighted - This will turn off the filter


Select all cells with data and then select filter again. This should allow for new data to be filterable.

Filtering stops working occasionally on larger files and this task will need to be done from time in order for newly added data to be found in filters. 
    • Related Articles

    • Office 365 Training

      This knowledge base article contains links that will provide training on various aspects of the Microsoft Office 365 suite of applications that we use daily at Finley. Click on the topics below to be redirected to step-by-step guides imbedded with ...
    • Acceptable Use Policy Legal Reviewed 10 02 2023

      Finley Engineering Co., Inc. Acceptable Use Policy Effective Date: Oct 04, 2023 Revision History: See End of Document Contact: helpdesk@finleyusa.com Introduction This document outlines the acceptable use policy for computers, networks, tablets, ...
    • iPad Guide

      Welcome to your iPad Basic Training Guide! This guide will help you get started with your device, covering essential functions and features to make your experience smooth. Getting Started: Power On/Off: To power on your iPad, press and hold the Power ...