filtering: sometimes data below blank lines is &isnt available?
When filtering: some of my sheets have blank lines inserted & i am still able
to filter the data below the blank lines. Sometimes I can not. Why? |
filtering: sometimes data below blank lines is &isnt available?
Depends on if you had all the data selected when you activated the
AutoFilter, or if you just had a single cell selected (in which case, XL "helps" and picks the complete set of data up till the first blank line). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Allison" wrote: When filtering: some of my sheets have blank lines inserted & i am still able to filter the data below the blank lines. Sometimes I can not. Why? |
filtering: sometimes data below blank lines is &isnt available?
If you highlight your entire table before activating the filter, all rows
will be included. If you don't, they Excel tries to guess the extent of the table. It figures that a blank line is the end of the table. To avoid this, change the height of the row, rather than using blank lines. Regards, Fred "Allison" wrote in message ... When filtering: some of my sheets have blank lines inserted & i am still able to filter the data below the blank lines. Sometimes I can not. Why? |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com