Hello,
I often build one-table database in Excel. For the purpose of this question and to match the Excel help file text wording, lets call such one-table database "list".
I always include automatic filters in the heading of my lists.
Fact:In order to operate automatic filter correctly, Excel automaticly define the range of the list and seems to save it as an hidden name.
Result: After few manipulations in the list(e.g.: data entry, inserting/deleting rows, etc.), Excel may define a range for the list that includes many empty rows after the actual last entry in the list. In such cases, setting the automatic filter of any field to "empty" will result in Excel hidding many empty rows after the list.
My question: on which basis does Excel determine the range of a filtered list? Is there a way of changing the definition of the range of a filtered list the same way I can change the definition of the range of a name (Insert/Name/Define)?
Thank you
Louis
I often build one-table database in Excel. For the purpose of this question and to match the Excel help file text wording, lets call such one-table database "list".
I always include automatic filters in the heading of my lists.
Fact:In order to operate automatic filter correctly, Excel automaticly define the range of the list and seems to save it as an hidden name.
Result: After few manipulations in the list(e.g.: data entry, inserting/deleting rows, etc.), Excel may define a range for the list that includes many empty rows after the actual last entry in the list. In such cases, setting the automatic filter of any field to "empty" will result in Excel hidding many empty rows after the list.
My question: on which basis does Excel determine the range of a filtered list? Is there a way of changing the definition of the range of a filtered list the same way I can change the definition of the range of a name (Insert/Name/Define)?
Thank you
Louis
