L
lotivbarjoh
Is there a way to delete filtered rows without deleting the unfiltered
rows.
rows.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
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
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
L
lotivbarjoh
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 -
No, it doesn't work. This was possible in Office 1997, but not since
Office 2003.
R
Roger Govier
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.
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.
L
lotivbarjoh
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 -
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.
J
Jarek Kujawa
in Excel 2003
select all filtered area
Edit->GoTo->Special->Select visible cells
then Delete
select all filtered area
Edit->GoTo->Special->Select visible cells
then Delete
R
Roger Govier
It also does work as I described.