Thread: Excel 07 - deleting filtered items
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
  
Posts: 206
Default Excel 07 - deleting filtered items
Select the filtered items and press F5
Select the Special Button
Select Visible Cells Only and OK
Right Click on one of the visible cells row and select delete row

Reply With QuoteReply With Quote