Filter and Delete

  • Thread starter Thread starter lotivbarjoh
  • Start date Start date
L

lotivbarjoh

Is there a way to delete filtered rows without deleting the unfiltered
rows.
 
Hi

Work on a COPY of your data first time - just in case!

Select the rows that have been filtered by choosing the row numbers at far
left> right click>Delete
 
Hi

Work on a COPY of your data first time - just in case!

Select the rows that have been filtered by choosing the row numbers at far
left> right click>Delete

--
Regards
Roger Govier






- Show quoted text -
Click to expand...

No, it doesn't work. This was possible in Office 1997, but not since
Office 2003.
 
Hi

It does work in XL2003 9and all earlier versions)
In XL2007, you need to ensure that you have selected a cell within the
table, before you make the selection by dropdown.
 
Hi

It does work in XL2003 9and all earlier versions)
In XL2007, you need to ensure that you have selected a cell within the
table, before you make the selection by dropdown.

--
Regards
Roger Govier







- Show quoted text -
Click to expand...

I found the solution on a website. If you select the filtered rows,
press F5, click Special, tick "Visible cells only", click OK and then
delete.
 
in Excel 2003
select all filtered area
Edit->GoTo->Special->Select visible cells
then Delete
 
You must log in or register to reply here.

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

Similar Threads

Copying a Filter list to a new worksheet. 1
Macro - filter - show all data 2
count unique values with auto-filter on 6
filter and delete 1
emailing autofilter results 3
Filtered table using Countif 6
VBA Macro to unfilter specific column 1
Delete Filtered Rows in Excel 2007 7

Back
Top