On Wednesday, 20 February 2008 20:42:11 UTC, Rodrigo Alonso wrote:
I usually use the Filter function when dealing with data in Excel.
But I cannot figure out why SOMETIMES the hidden data (i.e. after being filtered) is also afected by changes to filtered data. For example, if I use
Filter to find blanks cells and then delete the filtered rows also hidden rows (with data) are deleted.
I am using Excel 2007, and I never had this problem before with earlier versions of Excel.
I will appreciate any help regarding this problem
Thanks.
Very old problem, but I know the answer..
This is caused when you select the header row and turn on the autofilter (something you had to do in Excel 2003 I believe) - If oyu turn on autofilter with the first row selected you will have this problem.
Turn on autofilter by just selecting a single cell anywhere in the table and you should be able to delete from filtered data without it deleting rows in between.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 293 |
Nodes: | 16 (2 / 14) |
Uptime: | 215:12:57 |
Calls: | 6,619 |
Calls today: | 1 |
Files: | 12,169 |
Messages: | 5,317,541 |