Last Updated on October 30, 2023 by Jake Sheridan
How To Delete Columns In Google Sheets
Outdated or incorrect data can quickly make a spreadsheet less accurate and harder to use.
Fortunately, when you find you have a column of data in your spreadsheet that you no longer need, you can easily delete by following these steps:
Select the column or columns you want to delete.
To highlight multiple columns, hold down Ctrl on Windows or Command on Mac while you select the columns.
Right click on the selected columns and choose Delete Columns from the menu.
The menu option will show which columns you’re deleting. E.g. “Delete Columns B – C”
The selected columns and all data they contain will be removed from the spreadsheet
Note that if your spreadsheet contains any references to cells in the deleted columns, those references will break when the column is deleted.
The broken reference will show up as an error in the cell that reads #REF! And will look like the image below.
To fix these errors, you’ll have to re-write the formulas they contain to reference cells that still exist in your spreadsheet.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to delete columns in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to use columns in Google Sheets:
- Move A Column
- Add A Column
- Set Column Width
- Rename A Column
- Compare Two Columns
- Make All Columns The Same Width
- Add Multiple Columns
- Apply A Formula To An Entire Column
- Sort Multiple Columns
- Auto Fit Column Width
- Group Columns
- How To Name Columns
- Sum A Column
- Sort By Column
- Lock Column
- Split Text into Columns
- Apply Formula To Entire Column
- Combine Columns
- Find Unique Values In Column
- Move Columns
- Filter Columns
- Filter Multiple Columns
- Split A Column
- Get the Last Value in a Column
- Convert Rows To Columns
- Multiply Columns
- Highlight Duplicates In Multiple Columns
- Switch Columns
- Select Multiple Columns
- Subtract Columns
- Number A Column