You are currently viewing How to delete every other row in Excel

How to delete every other row in Excel

Data recording into excel sheets may involve all wanted and unwanted records. You find that when you gather and collect from data, it may have unwanted content that is not essential in the excel sheet. An example of such data is the use of only even numbers.

Deleting is the act or the process of omitting the unwanted content from an excel sheet. This content may include rows, columns, and cells. This function or command is used on nearly all occasions because errors are made every time.

There may be a lot of situations that may lead to the deleting of rows or columns in an excel sheet. For example, you might need to keep data about odd weeks and transfer the other data of even weeks on another excel sheet.

For us to achieve a successful deleting of alternate rows in an excel sheet, we will need to follow some of the steps to lead us to what we want. Some of the steps include the ones below.

Step 1

Create a new data set on an excel sheet, to have this done, open a blank or a new excel sheet, and insert or record some data into it. You can use my example below.

The column with values contains 0 and 1. Even numbers have the value 0 because when you divide an even number with 2 there will be no reminder unlike in the case of odd numbers that return a remainder.

Step 2

The next step is now to select the top row. After you select the top row with the headers, select on filter and sort from the Home tab. Under sort and filter choose a filter and click on it.

Step 3

The filter option will give drop-down filter arrows on the headers of the first row. Click on the drop-down filter arrow on the values header. Select on the value to filter from the checkboxes and click ok to make the changes.

The changes will take effect immediately you click on ok, the new excel sheet will look like the one below.