Deleting Rows
Results 1 to 3 of 3

Thread: Deleting Rows
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2008
    Location
    Maryland
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Deleting Rows

    I have a workbook with 314,000 rows sorted by a time stamp in Column A. Some of the rows are empty after the time stamp, some are not. How do I delete the rows which have no data after the time stamp? The 'tag rows with empty cells' function tags all of rows even if there is data present. If I try to delete - say 50 rows with blank cells it works fine. Is there a limit to how many rows I can tag and delete at one time?

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Deleting Rows

    The Easy-XL -> Rows -> Tag Rows -> Tag Rows With Empty Cells command is probably picking up blank cells in abandoned / disused columns on the right-hand side of the worksheet.

    You may be able to get the desired behaviour by deleting the right-most columns, even though they appear unused.

    You also need to remember to clear any existing tags before re-running a tag operation as they are not cleared automatically.

    You could also use the Easy-XL -> Rows -> Tag Rows -> Tag Rows By Column Value command to test a specific column for blanks.


  3. #3
    New Member
    Join Date
    Jul 2008
    Location
    Maryland
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Deleting Rows

    Ah ha! Now that works great! Thanks for the update!!

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
  •