Share via

How do I delete every other row without having to select them all? There is a 7000# data set to pull from.

Anonymous
2023-07-13T15:54:22+00:00

Reformatting something

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-07-13T15:57:55+00:00

    In an empty column, enter the following formula in row 2:

    =ISEVEN(ROW())

    Fill down to the last used row.

    Turn on Filter, and select either TRUE or FALSE depending on what you want.

    Select all the visible rows from row 2 down and delete them.

    Then turn off the filter, and clear the column.

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-13T16:09:30+00:00

    Add a help column, Copy that column and paste as value. Then you can sort that column and filter to delete unwanted rows.

    =MOD(ROW(),2)

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-07-13T16:04:23+00:00

    Thank You

    1 person found this answer helpful.
    0 comments