Re: Problems deleting filtered rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.



--

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


"Rodrigo Alonso" <ralonso@xxxxxxxxxxxxxx> wrote in message news:eDe%23rFJdIHA.1824@xxxxxxxxxxxxxxxxxxxxxxx
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.

"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:%23RMSiBAdIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
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.





--

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


"Rodrigo Alonso" <ralonso@xxxxxxxxxxxxxx> wrote in message news:uPbfD%23$cIHA.3788@xxxxxxxxxxxxxxxxxxxxxxx
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.

.

Relevant Pages

  • Re: Problems deleting filtered rows
    ... 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. ... 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. ... or F5>Special>Visible cells only>OK to select only the Visible cells. ... if I use Filter to find blanks cells and then delete the filtered rows also hidden rows are deleted. ...
    (microsoft.public.excel)
  • Re: Excel 2007 - Filtering by Cell Background Color NOT WORKING
    ... I will create a bug report if I can reproduce it ... When I filter on a selected color the system doesn't filter all of the cells with the color and it displays some cells with a totally different color. ...
    (microsoft.public.excel.programming)
  • Re: Excel Macro Filtered Data in-place: cannot calculate Frequency of Visible Cells
    ... What you could do, perhaps, is to use the Advanced Filter, set a criteria ... I have implemented your suggestion for a separate> named range object SET to the original range that contains the whole> un-filtered list, ... But the data> returned is still based on the whole un-filtered list and not the> filtered, Visible Cells only. ... >>> Returns a frequency distribution as a vertical array. ...
    (microsoft.public.excel.programming)
  • Re: Copy rows (in Excel 2007)
    ... copied all cells and the crawling ants were around the outer perimeter of the ... In my testing's Excel 2007 is working the same as older Excel versions if you use AutoFilter. ... selected whether it is just the filtered data or the filtered data plus the ... Select the entire range and run the menu command Data> Filter> AutoFilter. ...
    (microsoft.public.excel)
  • RE: retrieving top/bottom n rank()-ed data
    ... In this case, I think I'd implement an AutoFilter or, depending on your ... circumstances, an Advance Filter. ... The filtered cells are then copied and pasted at cell D1 ... suppose column A stores the age of individuals and some ...
    (microsoft.public.excel.programming)