Problem description: Auto Filter show blank lines below filtered results
Steps to reproduce:
1. Open the file attached
2. Select ADPM in the cell A1
3. What is expected :the filter results are shown with no blank lines below.
What happens instead : blank lines are shown below the filtered results. As well, these cannot be deleted by pressing the following 3 keys simultaneously:
Ctrl - +
Delete entire row(s) -> OK button
4. turn the filter off and on again, there's one more unwanted line at the bottom !
Created attachment 52804
The example file
Problem description: Auto Filter show blank lines below filtered results
Steps to reproduce:
1. Open the file attached
2. Select ADPM in the cell A1
3. What is expected :the filter results are shown with no blank lines below.
What happens instead : blank lines are shown below the filtered results. As well, these cannot be deleted by pressing the following 3 keys simultaneously:
Ctrl - +
Delete entire row(s) -> OK button
4. turn the filter off and on again, there's one more unwanted line at the bottom !