Share via

Not able to click on Filter symbol to filter data in excel online

Anonymous
2023-09-20T05:43:45+00:00

Not able to click on the filter symbol on the top row from a row.

When opening in the desktop version I'm able to filter it, but as it is a shared document and not all have the desktop app we need to solve this issue.

Any idea how to solve?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-20T18:46:24+00:00

    This just started happening across our organization today. Myself and 2 other used have checked 5 large workbooks and the filter buttons show up, and you can enable/disable filtering, but are all unclickable.

    In-cell drop-downs are unaffected, this seems to be isolated to column filters.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-09-20T19:04:39+00:00

    Quick Update - All the tables in question have data above them. If I delete the data so the table headers are on the first row, the filter drop-down starts working. Adding a row above the headers then breaks the ability to click the filter drop-down arrow.

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-09-29T13:26:48+00:00

    Hello!

    We haven't heard from you in the last 72 hours, so we will be considering your issue resolved. Moving forward, we will not be monitoring this thread so if you need further assistance, please create a new thread to discuss these concerns by clicking the link below. Or click on the Ask a question option as shown in the photo.

    https://answers.microsoft.com/en-us/newthread?threadtype=Questions&cancelurl=%2Fen-us%2F

    ..

    Thank you for understanding.

    Respectfully,

    Glenn

    0 comments
  4. Anonymous
    2023-09-27T11:11:40+00:00

    Thanks for the update, Craig.

    Since this seem to be an issue with Excel Online exclusively, it cannot be resolved normally by just reinstalling Office or trying a different web browser than the one you are using right now. Thus, you need to provide this experience as feedback to our developers using the steps in the link below.

    https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-365-2b102d44-b43f-4dd2-9ff4-23cf144cfb11#platform=Office_for_the_web

    As explained in the link above: "We’d love to hear from you about what’s working well, what’s not, and any ideas for improvements including possible new features and functions. Your input will help us improve the user experience for you and all Microsoft 365 users worldwide."

    "To make your feedback more actionable, please include a screenshot (where applicable). Also, preferably, select the option to allow us to contact you, then provide your email address."

    Thanks again for choosing Microsoft! We’re here when you need us.

    Respectfully,

    Glenn

    0 comments
  5. Anonymous
    2023-09-20T17:44:37+00:00

    Hello, Misael Andriulo.

    Welcome to the Microsoft Community Forum. Please accept our warmest regards and sincerest hope that all is well.

    We understand that you are having trouble filtering data in Excel Online. One possible reason why you're not able to click on the filter symbol could be due to the fact that the filter option is not available in Excel Online for tables that have merged cells or blank cells within the header row. It could also be an issue with the web browser or computer you are using. So, let's work together as a team to get to the bottom of this. But to better assist you I need to ask:

    1. Is this happening with only one specific Excel file shared with everyone? Or are shared Excel files affected?
    2. So, filtering works in the desktop app but never for any user using Excel Online?
    3. If you create an Excel file in Excel Online and make use of the suggestions in the guide below when using filters does the same issue occur?

    https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e#OfficeVersion=Web

    Hope to hear from you soon.

    Respectfully,

    Glenn Rue

    Forum Moderator

    Microsoft Community

    0 comments