See all How-To Articles

How to Delete Every Other Column in Excel & Google Sheets

This article will demonstrate how to delete every other column in Excel & Google Sheets.

 

delete every other column start

 

Delete Every Other Column Using Sort

1. Right-click on the row number in the top row of the data and select Insert to insert a new row above the data.

 

delete every other column insert row

 

2. In the cell just above the first column of data, type TRUE then in the second column, type FALSE.

 

delete every other column true false

 

3. Highlight the TRUE and FALSE cells and drag them across to the last column with data.

 

delete every other column true false copy

 

4. Release the mouse to copy TRUE and FALSE across the columns.

 

delete every other column true false copied

 

5. Use the mouse to (1) highlight the data and then in the Ribbon, (2) select Home > Editing > Sort & Filter > Custom Sort.

 

delete every other column custom sort

 

6. Click Options.

 

delete every other column sort options

 

7. Select Sort left to right and then click OK.

 

delete every other column left to right

 

8. In the Row, Sort by drop down list, select Row 2.

 

delete every other column sort row

 

9. In the Order drop down list, select Smallest to Largest and click OK.

 

delete every other column smallest largest

 

10. All the FALSE columns will now be sorted to the left, while all the TRUE columns will be sorted to the right.

 

delete every other column false sort

 

11. Select the columns that are not needed.

 

delete every other column-highlight colums

 

12. In the Ribbon, select Home > Cells > Delete > Delete Sheet Columns to remove the columns.

 

delete every other column delete

 

13. Delete the extra row (added in Step 1) to remove the remaining TRUEs and FALSEs.

 

delete every other column final

 

Delete Every Other Column Using Selection

If you do not have a huge quantity of columns, you can delete every other (or every nth) column by selection.

1. Click on the column header of the first column to select the column.

 

delete every other column single select

 

2. Holding down the CONTROL key on the keyboard, click on the column header of each column to be deleted.

 

delete every other column multiple select

 

3. Right-click on one of the column headers and select Delete.

 

delete every other column right click

 

The columns will be removed from the worksheet.

 

delete every other column remove

 

Deleting every other column in Excel can also be achieved by creating a macro using VBA.

 

How to Delete Every Other Column in Google Sheets

You can delete every other column in Google Sheets in exactly the same way as is done in Excel above.