Problems deleting filtered rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rodrigo Alonso - 20 Feb 2008 20:38 GMT

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.

Reply to this Message

Ron de Bruin - 20 Feb 2008 20:37 GMT

hi Rodrigo

You are not the only one
I only see this problem myself when I filter in a table in 2007 but not with Autofilter

You can do this (part of one of my webpages)

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5>Special>Current region>OK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>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
[quoted text clipped - 5 lines]
> I will appreciate any help regarding this problem
> Thanks.

Reply to this Message

Rodrigo Alonso - 21 Feb 2008 13:59 GMT

Hello Ron:
Thanks for your help.
The problem is that it seems to be a random problem, because when I was
testing your advice on the spreadsheet with problems it started working
fine.
In any case, I will have your advice at hand for the next time I run into
the problem.
It also allow me to learn about your webpage.
Thanks again.
Regards,
Rodrigo Alonso

P.S. But certainly it is a very annoying situation not to know if the
program works or not.

> hi Rodrigo
> You are not the only one
[quoted text clipped - 20 lines]
>> I will appreciate any help regarding this problem
>> Thanks.

Reply to this Message

Ron de Bruin - 21 Feb 2008 16:53 GMT

> The problem is that it seems to be a random problem, because when I was
> testing your advice on the spreadsheet with problems it started working
> fine.

That's the problem

When you can reproduce it every time it is easier to create a bug report.

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hello Ron:
> Thanks for your help.
[quoted text clipped - 35 lines]
>>> I will appreciate any help regarding this problem
>>> Thanks.

Reply to this Message

scott - 20 Feb 2008 22:05 GMT

I have had the same issue and used what Ron suggests going to visible
cells only.
If it is possible, without messing up your sheet, to sort all of the
blank cells into a group which you can delete that is another way to
remove them.
ScottD

>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
[quoted text clipped - 5 lines]
>I will appreciate any help regarding this problem
>Thanks.

Reply to this Message

Rodrigo Alonso - 21 Feb 2008 14:07 GMT

Thanks Scott for your help.
As I also answer to Ron, the problem is that this is a problem that appears
randomly, and makes it very annoying when you work with a lot of data.
Since the problem happens when a filtered is used, it is not only the risk
of unknowingly deleting a hidden row, but also changing their value when you
think only are doing this only to visible cells selected.
Hopefuly a fix to the problem will be found soon.
Regards,
Rodrigo Alonso

>I have had the same issue and used what Ron suggests going to visible
> cells only.
[quoted text clipped - 13 lines]
>>I will appreciate any help regarding this problem
>>Thanks.

Reply to this Message