Excel Filters Greyed out after selecting a certain row/column?

[SK_786]

Hi there,

I have come across a new problem which I've not had seen before in Excel 365 version.

1. After a certain ROW and COLUMN my filters are not working - I have cleared the filters, checked blanks, etc but when I select the entire data "Filter options" are greyed out as per image below.

2. Excel is not formatting the Data as a Table, nothing is changing

If someone can help me with this issue I would really appreciate it.

Thanks
SK

 

[Fluff]

Excel is not formatting the Data as a Table

Judging by the fact that your image shows the Table Design Tab, I suspect that is not the case.
Are you sure that you don't have a table?

 

[starl]

Based on the fact that the Table Design subribbon is showing, part of what you have selected is a Table. If you select beyond the table (extra row or column), then the filter options are not available (but Table Design will still show). To select JUST the data in the Table, select a cell in the table and press CTRL+A once.