This article will demonstrate how to delete every other column in Excel & Google Sheets.
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.
2. In the cell just above the first column of data, type TRUE then in the second column, type FALSE.
3. Highlight the TRUE and FALSE cells and drag them across to the last column with data.
4. Release the mouse to copy TRUE and FALSE across the columns.
5. Use the mouse to (1) highlight the data and then in the Ribbon, (2) select Home > Editing > Sort & Filter > Custom Sort.
6. Click Options.
7. Select Sort left to right and then click OK.
8. In the Row, Sort by drop down list, select Row 2.
9. In the Order drop down list, select Smallest to Largest and click OK.
10. All the FALSE columns will now be sorted to the left, while all the TRUE columns will be sorted to the right.
11. Select the columns that are not needed.
12. In the Ribbon, select Home > Cells > Delete > Delete Sheet Columns to remove the columns.
13. Delete the extra row (added in Step 1) to remove the remaining TRUEs and FALSEs.
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.
2. Holding down the CONTROL key on the keyboard, click on the column header of each column to be deleted.
3. Right-click on one of the column headers and select Delete.
The columns will be removed from the worksheet.
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.