How to Delete a Column in Google Sheets

Why deleting a column matters

In Google Sheets, columns are more than just empty space; they organize data, drive formulas, and influence charts and filters. Deleting an unnecessary column helps keep datasets clean, reduces confusion, and can improve performance in large spreadsheets. Before you delete, scan for hidden references in formulas, named ranges, or data validation rules that might rely on that column. A single deleted column can shift ranges and impact charts, pivot tables, and conditional formatting across the sheet. The How To Sheets team emphasizes careful planning: always confirm what sits in the column, whether any dependent formulas exist, and how downstream sheets will react. If you have multiple sheets that reference the same column, you’ll need to update each sheet or adopt a more conservative approach (such as hiding first or duplicating the sheet to test changes). By adopting a deliberate, well-documented deletion process, you reduce the risk of data loss and maintain audit trails for your team.

When to delete vs. hide

Hiding a column keeps the data intact while removing it from view. This is useful when you’re experimenting with layouts, or when a column contains data you may reuse later. Deleting, however, permanently removes the data and shifts adjacent columns left, which can alter formulas and references. If the column is referenced in other cells, consider replacing references or moving dependent data first. For shared workbooks, communicate changes with collaborators to avoid surprises. If your goal is temporary space management or temporary column exclusion, hiding is often the safer first step. If you’re cleaning up a dataset for reporting, deleting may be appropriate after confirming there are no downstream dependencies. How To Sheets recommends a test approach: duplicate the workbook, perform deletions there, and compare results against the original to ensure you’re not removing critical data.

Methods to delete a column

Google Sheets offers multiple ways to delete a column. The most common methods are via the right-click context menu, via the Edit menu, keyboard shortcuts, and, for power users, a short Apps Script snippet for automation.

• Right-click the header: Click the letter at the top of the column to select it, right-click the header again, and choose Delete column. This method is fast and works on any desktop browser.
• Menu bar: Select the column, go to Edit > Delete column. This path is explicit and works if you’ve disabled right-click context menus.
• Keyboard shortcuts: Windows: Ctrl + Alt + minus; Mac: Cmd + Option + minus. These shortcuts delete the selected column without using the mouse. If you need to delete multiple non-adjacent columns, repeat the action on each column, or use a script.
• Apps Script: For automation, open Extensions > Apps Script and run a function like deleteColumn(sheetName, columnIndex). Example:

Why each method matters: context menus are fastest for single-column deletions; menus help when you’re avoiding keyboard shortcuts; Apps Script shines when you need repeatable edits across many sheets.

Deleting multiple columns efficiently

To delete several adjacent columns, click the first column header, hold Shift, and click the last header to select a block, then delete using any method. For non-adjacent columns, hold Ctrl (Windows) or Cmd (Mac) while clicking each header to select multiple columns, then delete. When deleting many columns at once, performance can improve with a single operation rather than repeated single-column deletions. If your dataset uses relative references in formulas across those columns, Google Sheets will adjust references automatically, but some extremely complex formulas may require post-change validation. In shared documents, consider communicating the scope of the deletion, especially if filters, conditional formatting rules, or charts anchor to those columns. If you accidentally delete the wrong range, press Ctrl/Z (Cmd/Ctrl + Z) to undo immediately, or restore from a previously saved version using File > Version history > See version history.

Undo, backups, and safety tips

Before deleting, create a quick backup. Duplicate the sheet (Right-click tab > Duplicate) or download a copy (File > Download) to preserve a restore point. After deletion, use Edit > Undo if you realize the mistake within seconds, but note that undo may be limited after other actions. Version history (File > Version history > See version history) lets you review previous states and restore if needed. If multiple people collaborate, record the change in a comment or a changelog so teammates understand why the column disappeared. Where possible, test deletions on a copy of the sheet first, especially if the column contains data used by charts, pivot tables, or scripts. This practice protects critical data while giving you room to adjust.

Automating deletion with Google Apps Script

Apps Script can streamline column deletions across many sheets or workbooks. Create a small script that takes a sheet name and a column index, then deletes that column. You can schedule the script to run during night cleanups or tie it to a custom menu item. Example code:

To deploy: open Extensions > Apps Script, paste the function, save, and run. You may need to authorize the script. This approach is especially useful when you standardize a cleanup process across multiple sheets with similar structures. Prefer testing on a copy before applying to production files, and ensure your script respects protected ranges and permission boundaries.

Common pitfalls and troubleshooting

Common mistakes include deleting a column that contains formulas referencing it, not understanding how data shifts affect adjacent cells, and accidentally deleting merged cells. Always verify dependencies by using the Find and Replace or the formula auditing features to trace references. If charts or conditional formatting are based on a column, re-check their data ranges after deletion. If you delete a column that is part of a named range, you may need to update the named range. When working with protected sheets, ensure you have edit rights or adjust protection rules before deletion. If you encounter unexpected behavior, try undoing or restoring from a version history. Finally, remember that hiding a column instead of deleting can be a safer intermediate step when you’re testing changes.

Keyboard shortcuts and quick tips

Shortcuts save time: use Ctrl/Cmd + F to locate data before deleting, use Ctrl/Cmd + Z to undo, and use Ctrl/Cmd + Shift + Arrow to select large blocks quickly. When targeting a specific column by index in Apps Script, pass the exact numeric index. If you’re uncertain, practice deletions on a test dataset in a duplicate sheet to reduce risk. Consider enabling the Google Sheets right-click context menu if it’s disabled for your browser. Finally, for columns critical to data structure, document the change in your data dictionary so future editors understand the layout.

Practical example: cleaning up a budget sheet

Imagine a monthly budget sheet with many columns for income and expenses. You notice a column that collects unused category data and decide to remove it. Start by duplicating the sheet as a safety net, then select the target column header and delete it via the context menu. Check affected formulas and charts—your totals should shift only where intended. If a chart references the deleted column, update the data range to reflect the new structure. Finally, save a version tag like “Budget cleanup – 2026-03-07” in the sheet's notes. This concrete example illustrates how a deliberate deletion improves clarity without compromising insights.