Filter and Delete
It also does work as I described.
--
Regards
Roger Govier
"lotivbarjoh" wrote in message
...
On Jun 30, 3:05 pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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
"lotivbarjoh" wrote in message
...
On Jun 30, 2:14 pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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 clickDelete
--
Regards
Roger Govier
"lotivbarjoh" wrote in message
...
Is there a way to delete filtered rows without deleting the
unfiltered
rows.- Hide quoted text -
- Show quoted text -
No, it doesn't work. This was possible in Office 1997, but not since
Office 2003.- Hide quoted text -
- 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.
|