15 Ways to Delete Extra Columns in Excel: Essential Tutorial for Quick Fixes

Are you tired of dealing with those extra columns in your Excel spreadsheet that are just taking up space and making your data hard to manage? Well, fear not! We're here to guide you through 15 efficient methods to quickly delete those unwanted columns and streamline your data. Whether you're a beginner or a seasoned Excel user, these tips will make your life easier and save you precious time.

Method 1: Using the Delete Key

The simplest and most straightforward way to delete a column is by using the Delete key on your keyboard. Here's how:

1. Select the column you want to delete by clicking on the column header.
2. Press the Delete key on your keyboard.
3. The column will be removed, and the remaining columns will shift to the left to fill the gap.

Method 2: Right-Clicking and Deleting

Another quick method is to use the right-click menu. Follow these steps:

1. Click on the column header to select the column.
2. Right-click on the selected column.
3. From the context menu, choose Delete.
4. The column will be deleted, and the surrounding columns will adjust accordingly.

Method 3: Using the Home Tab

Excel's Home tab offers a range of options for formatting and manipulating data. To delete a column using this tab:

1. Select the column by clicking on its header.
2. Go to the Home tab in the Excel ribbon.
3. In the Cells group, click on the Delete drop-down arrow.
4. Choose Delete Sheet Columns from the menu.
5. The selected column will be removed.

Method 4: Using the Context Menu with the Keyboard

If you prefer using keyboard shortcuts, you can access the context menu without the need for a right-click. Here's how:

1. Select the column by clicking on its header.
2. Press the Shift + F10 keys simultaneously.
3. The context menu will appear. Use the arrow keys to navigate to Delete and press Enter.
4. The column will be deleted.

Method 5: Using the Ribbon's Edit Menu

Excel's ribbon also provides an Edit menu with the option to delete columns. Follow these steps:

1. Select the column you want to delete.
2. Go to the Home tab.
3. In the Cells group, click on the Format drop-down arrow.
4. Choose Delete Cells from the menu.
5. A dialog box will appear. Select Shift cells left to ensure the remaining data shifts to fill the gap.
6. Click OK, and the column will be deleted.

Method 6: Deleting Multiple Columns at Once

If you have multiple extra columns that need to be deleted, you can select them all and delete them simultaneously. Here's how:

1. Click and drag to select the columns you want to delete.
2. Use any of the previous methods, such as pressing Delete or right-clicking and selecting Delete.
3. The selected columns will be removed, and the data will shift accordingly.

Method 7: Deleting Columns Based on Criteria

Sometimes, you may want to delete columns based on specific criteria, such as empty cells or duplicate data. Excel's filtering feature can help with this. Here's how:

1. Select the range of cells you want to filter.
2. Go to the Data tab and click on the Filter button.
3. Click on the drop-down arrow in the column header for the criteria you want to filter by.
4. Choose the appropriate option, such as Blanks or Duplicate.
5. The filter will be applied, and only the rows meeting the criteria will be visible.
6. Now, you can use any of the previous methods to delete the columns containing filtered data.

Method 8: Deleting Columns Using VBA

For more advanced users, Excel's Visual Basic for Applications (VBA) can be a powerful tool. Here's a simple VBA script to delete a column:

 
Sub DeleteColumn() 
    ' Delete the selected column 
    Columns(Selection.Column).Delete 
End Sub 

You can run this script by pressing Alt + F11 to open the VBA editor, inserting the script, and running it using the Run button.

Method 9: Using the Quick Access Toolbar

If you frequently delete columns, you can add the Delete command to your Quick Access Toolbar for easy access. Here's how:

1. Click on the Customize Quick Access Toolbar icon (the down arrow next to the Quick Access Toolbar).
2. Choose More Commands... from the drop-down menu.
3. In the Excel Options dialog box, select All Commands from the Choose commands from drop-down list.
4. Scroll down and select Delete Sheet Columns from the list.
5. Click Add to add it to your Quick Access Toolbar.
6. Click OK to save the changes.
7. Now, you can click the Delete button in your Quick Access Toolbar to delete columns.

Method 10: Deleting Columns with Keyboard Shortcuts

Excel offers various keyboard shortcuts to delete columns. Here are a few:

• Ctrl + Shift + - (minus sign): Deletes the selected column.
• Ctrl + Shift + + (plus sign): Inserts a new column to the left of the selected column, effectively deleting the original column.
• Ctrl + Shift + Right Arrow: Moves the selected column to the right, effectively deleting it.

Method 11: Deleting Columns with the Mouse

If you prefer using your mouse, you can delete columns by dragging them to the recycle bin. Here's how:

1. Click on the column header to select the column.
2. Drag the column header to the recycle bin icon at the bottom-right corner of the Excel window.
3. The column will be deleted.

Method 12: Deleting Columns with the Clipboard

You can also use the clipboard to delete columns. Here's how:

1. Select the column you want to delete.
2. Press Ctrl + C to copy the column to the clipboard.
3. Right-click on the column header and choose Paste Special.
4. In the Paste Special dialog box, select All and check the Transpose box.
5. Click OK, and the copied data will be pasted as rows instead of columns, effectively deleting the original column.

Method 13: Deleting Columns with the Find and Replace Feature

Excel's Find and Replace feature can also be used to delete columns. Here's how:

1. Select the range of cells you want to work with.
2. Go to the Home tab and click on the Find & Select drop-down arrow.
3. Choose Find... from the menu.
4. In the Find and Replace dialog box, leave the Find what field empty and click Find All.
5. A list of cells containing the search criteria will be displayed. Select the cells you want to delete.
6. Right-click on the selected cells and choose Delete.
7. The selected cells, including the entire column, will be deleted.

Method 14: Deleting Columns with the Remove Duplicates Feature

If you have duplicate data in your columns, you can use Excel's Remove Duplicates feature to delete them. Here's how:

1. Select the range of cells you want to check for duplicates.
2. Go to the Data tab and click on the Remove Duplicates button.
3. In the Remove Duplicates dialog box, ensure that the columns containing duplicate data are checked.
4. Click OK, and Excel will remove the duplicate rows, effectively deleting the columns with duplicate data.

Method 15: Deleting Columns with the Advanced Filter Feature

Excel's Advanced Filter feature allows you to filter and copy data to another location, effectively deleting the original columns. Here's how:

1. Select the range of cells you want to filter.
2. Go to the Data tab and click on the Advanced button in the Sort & Filter group.
3. In the Advanced Filter dialog box, select Copy to another location and enter a cell reference where you want the filtered data to be copied.
4. Click OK, and Excel will copy the filtered data to the specified location, effectively deleting the original columns.

Conclusion

Deleting extra columns in Excel is a straightforward task, and there are numerous methods to choose from. Whether you prefer using keyboard shortcuts, right-click menus, or advanced features like VBA, you now have a comprehensive toolkit to streamline your data and make your Excel experience more efficient. So, go ahead and bid farewell to those unwanted columns with confidence!

Can I undo the deletion of a column?

+

Yes, Excel allows you to undo your actions. Simply press Ctrl + Z or click the Undo button in the Quick Access Toolbar to undo the deletion.

Can I delete multiple columns at once without selecting them individually?

+

Yes, you can use the Ctrl or Shift keys to select multiple non-adjacent or adjacent columns, respectively, and then delete them using any of the methods mentioned above.

What if I accidentally delete the wrong column? Can I recover it?

+

If you have the AutoRecover feature enabled, Excel might have a backup of your file. Check the File tab, go to Info, and click Manage Versions to see if there’s an older version of your file that you can recover from.

Are there any keyboard shortcuts for deleting columns?

+

Yes, Excel provides keyboard shortcuts like Ctrl + Shift + - (minus sign) to delete a column. You can also use Ctrl + Shift + + (plus sign) to insert a new column, effectively deleting the original column.

Can I delete columns based on specific criteria, like empty cells or duplicate data?

+

Yes, you can use Excel’s filtering feature to delete columns based on specific criteria. Apply a filter to the data, select the criteria you want to delete, and then use any of the deletion methods mentioned above.