Filter and Delete
 

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

Filter and 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 clickDelete

--
Regards
Roger Govier

"lotivbarjoh" wrote in message
...
Is there a way to delete filtered rows without deleting the unfiltered
rows.

Filter and Delete
 

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.

Filter and Delete
 

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.

Filter and Delete
 

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.

Filter and Delete
 

in Excel 2003
select all filtered area
Edit-GoTo-Special-Select visible cells
then Delete

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.