Results 1 to 2 of 2

Thread: deleting rows with empty cells

  1. #1
    New Member
    Join Date
    Jul 2016
    Posts
    47
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Exclamation deleting rows with empty cells

    Hi everyone,

    I am trying to delete all rows with empty cells in excel. I have 250k and more rows, and I want to delete entire row if a cell in field H is empty.

    I tried trick with Find-Go to special-Blanks, but it selects me only the last cell of collumn H (and there are many other empty cells)

    to make it clear, entire collumn H is formula, and I want to delete the rows where the formula returns empty field

  2. #2
    Board Regular jkpieterse's Avatar
    Join Date
    Dec 2007
    Location
    Weert
    Posts
    900
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: deleting rows with empty cells

    Filter the table for the value of column H you want deleted, then use goto special visible cells only and delete.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •