The spreadsheet is made up of a combination of rows and columns. Users can anytime remove unwanted or extra columns from the data set. They can remove a column or multiple columns at the same time.
In this tutorial, we will show you how to remove columns in Google Sheets.
Remove a Column in Google Sheets Using Column Header Triangle Button
- First, go to the column header letter that you want to delete and then click on the triangle button in it, and your column will get selected and a drop-down opened.
- After that, click on the “Delete column” option from the drop-down menu.
- At this moment, that selected column will get removed and the data will get shifted to the left.
Remove a Column Using Right Click Option
This is another quick way of removing any column from the spreadsheet.
- First, click on any cell of the column which you want to remove and then right click from the mouse.
- After that, click on the “Delete column” option from the drop-down menu.
- At this moment, the column in which you clicked on the cell, will get removed.
Remove Multiple Columns in Google Sheets
In Google Sheets, you can remove the adjacent and non-adjacent multiple columns in one go instead of deleting them one by one.
Remove Adjacent Columns
- First, select the first column which you want to delete and then press and hold the “Shift” key and then click on the header column letter of the last column until which you want to select the columns for deletion.
- Once selected, release the “Shift” key.
- After that, click on the drop-down arrow from any of the selected column header letters, or right click and choose “Delete selected columns” from the drop-down menu.
- At this point, all the selected adjacent columns will get deleted.
Remove Non-Adjacent Columns
- First, select the first column which you want to delete and then press and hold the “Ctrl” key and then click on the header column letter of each column one by one to select which you want to select.
- Once selected, release the “Ctrl” key.
- After that, click on the drop-down arrow from any of the selected column header letters, or right click and choose “Delete selected columns” from the drop-down menu.
- At this point, all the selected non-adjacent columns will get deleted.
Keyboard Shortcut to Remove the Columns
- For Windows OS, Select the column or columns which you want to delete and then press the “Ctrl + -“ keyboard shortcut and the selected columns will get removed and data will get shifted to the left.
- For Mac OS, Select the column or columns which you want to delete and then press the “Cmd + -“ keyboard shortcut and the selected columns will get removed and data will get shifted to the left.
Remove Columns from Google Sheets Mobile
- First, tap on the column header letter to select a column.
- If want to remove multiple columns at once, after selecting the first column, tap and hold on the bold circle at the right border or the left border of the column and drag it towards the right to select more columns towards the right or to the left to select the columns towards the left side.
- Once you are done with selecting a column or multiple columns, tap and hold within the selected column and you will get the pop-up opened.
- Now, click on three dots of the pop-up menu and then click on “Delete” to delete the selected columns.
