Excel will not do the filter on all rows
Closed
Puja
-
Jun 9, 2010 at 11:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 11:35 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 11:35 AM
Hello,
I'm trying to sort and filter a file with 167 rows. When I do the filter, it will only go up to row 150. I looks like it will not do anything below a certain row. How do I fix this?
I'm trying to sort and filter a file with 167 rows. When I do the filter, it will only go up to row 150. I looks like it will not do anything below a certain row. How do I fix this?
Related:
- Excel will not do the filter on all rows
- Excel mod apk for pc - Download - Spreadsheets
- Safe search filter - Guide
- Number to words in excel - Guide
- Filter unknown senders android - Guide
- Kernel for excel - Download - Backup and recovery
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 11:35 AM
Jun 9, 2010 at 11:35 AM
Chances are there is a blank row at that spot. So try one of the following
A. Delete Blank row
b. Before applying the filter select all cells
A. Delete Blank row
b. Before applying the filter select all cells