NigelTufnel
Board Regular
- Joined
- Apr 3, 2008
- Messages
- 53
- Office Version
- 365
- Platform
- Windows
I frequently use autofilter on tables/lists containing cells with attached notes. Excel has this *maddening* behavior of changing the size of the attached note based on how many rows have been filtered out.
I have attached (in pictures) a sample small table I created with names and ages. I added a note that is visible (Pic #1). Then I filtered on ages between 30 and 35. You will see how the note gets "squashed" so now only part of the text is visible (Pic #2). If I want to read the entire note contents while the table is filtered, I have to resize the note. If I resize it, so the full text is visible (extending the box across hidden rows), then when I remove the existing filter, the note box grows much larger (Pic #3).
When I look at the format properties for the note in question, the property "Don't move or size with cells" is selected. I would guess that this means that turning on autofilter and filtering the list would not alter the size or location of the note....but this is not the case. I can't seem to find any other properties that give me the location and sizing behavior I want.
This is just a simple example, In reality, when using tables with thousands of rows, the notes will get crushed to be height zero (and then keep that height when unfiltered!), or they will get moved half-way down the table, etc.
I realize the reason for this has to do with the rows that get hidden and un-hidden, but what setting can I use to keep the size of the note box constant and the position relative to the host cell constant regardless of the level of filtering?
Any suggestions are appreciated.
I have attached (in pictures) a sample small table I created with names and ages. I added a note that is visible (Pic #1). Then I filtered on ages between 30 and 35. You will see how the note gets "squashed" so now only part of the text is visible (Pic #2). If I want to read the entire note contents while the table is filtered, I have to resize the note. If I resize it, so the full text is visible (extending the box across hidden rows), then when I remove the existing filter, the note box grows much larger (Pic #3).
When I look at the format properties for the note in question, the property "Don't move or size with cells" is selected. I would guess that this means that turning on autofilter and filtering the list would not alter the size or location of the note....but this is not the case. I can't seem to find any other properties that give me the location and sizing behavior I want.
This is just a simple example, In reality, when using tables with thousands of rows, the notes will get crushed to be height zero (and then keep that height when unfiltered!), or they will get moved half-way down the table, etc.
I realize the reason for this has to do with the rows that get hidden and un-hidden, but what setting can I use to keep the size of the note box constant and the position relative to the host cell constant regardless of the level of filtering?
Any suggestions are appreciated.