Excel 2007 - Deleting Filtered Rows

M

Marcia

In a spreadsheet, I use filter to show only rows that I want to delete. The
filter function will show correct view - I have checked and there's no
problem here. However, when I delete those rows, SOMETIMES it will delete all
rows that I want to keep as well, as if the filter function did not work.
This happens few times, NOT ALWAYS. And, this concerns me whether or not I
can rely on the filter function in regards of deleting rows. If I work with
large volume of data, this will definitely cause problem in term of accuracy.
My collegue has experienced the same thing eventhough we obtained the Office
2007 package seperately.

Has anybody experienced this too? If so, what is the fix?
 
R

Ron de Bruin

Hi Marcia

There are more people that report this but I never see it with AutoFilter.
To be sure use the shortcut Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

Btw: do you filter in a table ?
 
B

Bob Umlas, Excel MVP

press alt/; first (same as F5/Special/Visible cells only). Now that the
visible cells are the only ones selected, deleting them should not be a
problem.
Bob Umlas
Excel MVP
 
Joined
Apr 8, 2014
Messages
2
Reaction score
0
Hi,
I have faced the same issue in 2007, I tried folowing way it worked:
1. Keep the cursor on header cell eg, I wanted to filter by Product Name so I kept my cursor in Product Name Header.
2. Click on Data>Filter
3.Select Rows Number at Left most
4. Right Click> Delete Rows

Note: If only Delete option is displayed then it will delete hidden rows also, Try and follow steps again the option should be 'Delete Rows'
Please let me know if it worked
Gud Luck:thumb:


In a spreadsheet, I use filter to show only rows that I want to delete. The
filter function will show correct view - I have checked and there's no
problem here. However, when I delete those rows, SOMETIMES it will delete all
rows that I want to keep as well, as if the filter function did not work.
This happens few times, NOT ALWAYS. And, this concerns me whether or not I
can rely on the filter function in regards of deleting rows. If I work with
large volume of data, this will definitely cause problem in term of accuracy.
My collegue has experienced the same thing eventhough we obtained the Office
2007 package seperately.

Has anybody experienced this too? If so, what is the fix?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top