ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   autofiltering (https://www.excelbanter.com/excel-worksheet-functions/176006-autofiltering.html)

Bernie R

autofiltering
 
when using autofilter for a certain item in a column containing 80+ rows, the
filter stops at a blank row (row 15) and you can see the remaining rows below
that haven't been filtered.

appreciate any and all assistance

Max

autofiltering
 
Remove autofilter, then re-select the entire col(s), re-apply autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bernie R" wrote:
when using autofilter for a certain item in a column containing 80+ rows, the
filter stops at a blank row (row 15) and you can see the remaining rows below
that haven't been filtered.

appreciate any and all assistance



All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com