Why excel´s filter doesn´t work?

Hello! JOHN FREDY MARTINEZ GARZON

Thank you for posting in Microsoft Community

There could be several reasons why the filter function in Excel is not working. Allow me to ask:

• What version and edition of Office do you have installed in your device? Example: Personal/Family/Enterprise?
  • You can open any Office apps
  • Go to File > Accounts - on the right side you can see Product Information
• What error message are you getting?
• is this happening to other devices? or just specific device?

Here are a few things you can try:

1. Make sure that the data you are trying to filter is in a table format. If it is not, you can convert it to a table by selecting the data and pressing Ctrl+T.
2. Check if the filter shortcut key is enabled in Excel. To do this, go to File > Options > Customize Ribbon > Keyboard Shortcuts and make sure that the shortcut key for the filter function is not disabled.
3. Try resetting the filter function by going to the Data tab and clicking on the Clear button in the Sort & Filter group. To filter data in Excel, follow these steps:
4. Click any single cell inside a data set.
5. On the Data tab, in the Sort & Filter group, click Filter. Arrows in the column headers appear.
6. Click the arrow next to the column you want to filter.
7. In the drop-down menu, select the criteria you want to filter by.
8. Click OK.
9. You can also try to use the shortcut CTRL + SHIFT + L while highlighting the cells that you wish to be filtered/sorted.

I hope this helps! Let me know if you have any further questions.

Thank you,

Vince

Microsoft Community Moderator

Hello JOHN FREDY MARTINEZ GARZON

We haven't heard from you, so we assume that your issue has already been addressed. We will not be monitoring this thread moving forward so, if you need further assistance, please create a new thread to discuss these concerns by clicking this link: Create a new question (microsoft.com)

Thank you for understanding.

Regards,

Vince