A
A
Andrey Shiryaev2014-06-09 21:01:46
excel
Andrey Shiryaev, 2014-06-09 21:01:46

How to activate filters in excel?

There is a large table in xls format, I want filters in the first column. I open it in excel, there are no filters, and the section with filters is not active: when you right-click in the filters section, all items are inactive, and there are no active elements in the data section either.
Tried to open in LibreOffice 4.2 everything is all right there. There is a section filters and you can enable them. I tried to save it in xlsx and then open it in excel, the select appears in the first column, but it is not active, it writes (all) on hover, but the filters still remain inactive.
How to make filters work in excel?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Y
Yuri Lobanov, 2014-06-09
@iiil

1. What office?
2. Does another arbitrary table and filters work in it?
3. Can you upload the file itself?

O
oia, 2014-06-09
@oia

so give me a test file for seeding, maybe everything will work for us)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question