How to delete columns in Google Sheets?

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: To delete a column in Google Sheets, select the column header, right-click, and choose ‘Delete column.’ For multiple columns, select and delete as needed. Undo any deletion quickly with Ctrl + Z (Command + Z for Mac).

This post will walk you through the step by step process.

Step 1: Open Your Google Sheet

Begin by opening the Google Sheets document where you need to delete columns. Ensure you have editing permissions if it’s a shared sheet.

Step 2: Select the Column(s) to Delete

Click on the letter at the top of the column you wish to delete. To delete multiple columns, click and drag across the column letters, or hold the Shift key to select a range.

Step 3: Deleting the Column(s)

Right-click on one of the selected column headers. In the context menu, select ‘Delete column’ (or ‘Delete columns’ for multiple). The column(s) will be removed from your sheet.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Alternative Method: Using the Menu Bar

Another way to delete columns is through the menu bar. Select the column(s), go to the ‘Edit’ menu, and click on ‘Delete column’ (or ‘Delete columns’).

Undoing the Deletion

If you need to undo the deletion, press Ctrl + Z (Command + Z for Mac users) or click the ‘Undo’ button in the Google Sheets toolbar. This will restore the deleted column(s).

Tips for Safe Column Deletion:

  1. Verify Data Dependencies: Ensure that the columns you’re deleting don’t contain crucial data linked to other parts of your spreadsheet.
  2. Backup Important Data: It’s wise to create a backup of your data before deleting significant portions, especially in a collaborative environment.
  3. Utilize Filters for Accuracy: For large datasets, filtering can help identify the columns that need to be deleted more accurately.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies