| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter and Delete
Is there a way to delete filtered rows without deleting the unfiltered
rows. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filter and Delete
in Excel 2003
select all filtered area Edit-GoTo-Special-Select visible cells then Delete |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort or filter or delete by strike-through? | Excel Discussion (Misc queries) | |||
| AFTER 8 SEC ON SPACEBAR I GOT A FILTER?DELETE IT? | Excel Discussion (Misc queries) | |||
| Filter list and delete | Excel Discussion (Misc queries) | |||
| filter and delete | Excel Worksheet Functions | |||
| Fastest Way to Filter/Delete | Excel Worksheet Functions | |||
Linear Mode
