LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Delete the filtered records

How to delete just the filter records? I had tried a few times, sometime it
work and sometime it doesn't. After filtered the column in Excel 2007, select
the invible records and right click the mouse and select "delete", it will
delete all the invisible records too in between the lines.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permanently delete filtered records Allen Excel Discussion (Misc queries) 12 August 8th 08 04:44 PM
accumulate filtered records from several sheets to one CaptDunsull Excel Discussion (Misc queries) 0 December 30th 05 03:03 PM
Be able to move not delete filtered records, to see the duplicats hmadari Excel Worksheet Functions 4 May 25th 05 09:06 PM
returning value from filtered records JulieD Excel Discussion (Misc queries) 3 April 29th 05 03:39 PM
how do I see more than 1000 records filtered ml Excel Discussion (Misc queries) 1 April 13th 05 08:47 PM


All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"