How to Delete Every Other Column in Excel & Google Sheets

This tutorial demonstrates how to delete every other column in Excel and Google Sheets.

 

delete every other column start

 

Sort and Delete Every Other Column

For worksheets with many columns, it may be best to sort the columns horizontally with a helper row.

  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

 

  1. 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

 

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

 

delete every other column true false copy

 

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

 

delete every other column true false copied

 

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

 

delete every other column custom sort

 

  1. Click Options.

 

delete every other column sort options

 

  1. Select Sort left to right, and then click OK.

 

delete every other column left to right

 

  1. In the Row: Sort by drop-down list, select Row 2.

 

delete every other column sort row

 

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

 

delete every other column smallest largest

 

  1. All the FALSE columns are now sorted to the left, while all the TRUE columns are sorted to the right.

 

delete every other column false sort

 

  1. Select the columns that are not needed.

 

delete every other column-highlight colums

 

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

 

delete every other column delete

 

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

 

delete every other column final

 

Select and Delete Every Other Column

If you do not have a large number 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

 

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

 

delete every other column multiple select

 

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

 

delete every other column right click

 

The columns are 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.

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.

 

delete every other column gs