Thread: Delete specific rows of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Delete specific rows of data
One quick way ..

Select the entire email col
Press F5 Special Check "Blanks" OK
This selects all the blank cells in the email col
Then just right-click on the selection Delete Check "Entire row" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Bell" wrote:
Is there a way that you can delete/remove rows of data where a specific
situation applies. For example I want to remove the entire row where email
addresses are blank

Thanks for any help

Reply With QuoteReply With Quote