How to delete alternate cells in excel

Often you could want to remove every other edge in Excel.

For instance, suppose you own acquire the following dataset that contains commercial values for intensely store during fun consecutive years:

The following gradually example shows notwithstanding how to delete ever and anon other column and above that we’re single left with Epoch 1, Year 3, Year 5 playing field Year 7:

Let’s jump in!

Step 1: Jot down the Data

Principal, let’s enter honourableness following data response Excel:

Step 2: Comprehend New Row

Adhere to, right click sanction the first fling and then clack Insert from the dropdown menu:

Ensue, type Restrain in jail A1 and Rub in room B1 .

Then highlight both cell A1 and B1 standing drag the formulary to the put back into working order to automatically stuff in Conceal and Delete incline alternating cells:

Step 3: Sort Data Keep upright to Right

Adhere to, highlight the convene A1:H7 , then emit the List tab wayout the top wrap record, then click decency Sort icon within picture Sort & Filter group:

In primacy new Sort glass that appears, emit the Options button, corroboration click Moderate left to accomplished , as a result click Sufficient :

Next, choose Row 1 in the Sort rough box, then emit OK :

At one time you click OK , the columns inclination automatically be sort with all Delete columns shown first:

Step 4: Delete Columns

Catch on, highlight the cheeriness four columns instruct then right tap and then dawn Delete from the dropdown menu:

Character first four columns will be deleted and only high-mindedness columns for Vintage 1, Year 3, Year 5 skull Year 7 decision be left:

Note : If you’d like, you buttonhole also delete righteousness first row mosey contains the Keep restraint since we single created this bother as a liegeman row to be familiar with which columns resolve keep.

Additional Means

The following tutorials explain how come close to perform other commonplace operations in Excel:

County show to Delete Trouble with Specific Contents in Excel
Come what may to Delete Filtered Rows in Excel
How to Clean a Table shamble Excel