delete only visible rows in filter mode

[ajezmohd]

I use filter for a range of data but when I try to delete some visible rows (
while in filter mode ) it also delete unvisible rows
Im using Excel 2007 with Vista

 

[Ms-Exl-Learner]

I am also faced this problem, in that case I used to delete the 500 rows
first and another 500 rows next like that… If I delete the whole unwanted
rows at a single time when it is in filter then it is getting deleted.

 

[PhilosophersSage]

The only work around I have found for this is using sort rather then filter;
however, sometimes this requires adding extra columns to allow you to return
your spreadsheet to origonal sorting.

 

[Geoff B]

This was easy under the old versions of office, you just had to add the
command button 'View Visible Cells' to any toolbar and click this once you
had highlighted the cells you wanted to copy or delete; but in 2007 you need
to do the following

Highlight the cells you want to copy. From the 'Home' tab you need to go to
the 'Editing' group , click on 'Find and Select' then click on 'Go To
Special'. In the dialog box that opens you need to select 'Visible Cells
Only'.
So now when you copy or delete, only the visible cells will be copied or
deleted.

 

[Ron de Bruin]

Use the shortcut

Alt ;


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm