To delete a whole column in Excel, select its lettered header, then choose Home > Delete > Delete Sheet Columns. You can also right-click the header and choose Delete. Excel removes the column and shifts columns to its right leftward, so check that you have the right column and save or be ready to undo before proceeding.
What You’ll Need
- An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The ribbon and right-click options are also available in Excel for Mac and Excel for the web, though the exact layout can vary slightly.
- Permission to edit the worksheet. A protected sheet may prevent column deletion.
- If the data matters, a saved copy of the workbook or a clear way to reverse the change. Ctrl+Z on Windows and Command+Z on Mac undo a recent deletion in the current editing session.
Step-by-Step
- Identify the column you want to remove. Look at the lettered headers along the top of the worksheet and check the cells below the likely column. Confirm its contents by scanning several rows, including the header row and any totals near the bottom. If the workbook has hidden columns, use the column letters and surrounding data to make sure you have identified the correct one. Deleting a worksheet column removes every cell in that column, including cells far below the visible data.
- Select the entire worksheet column. Click its letter at the top of the grid, such as the C or F header. The full column should become highlighted, and Excel will show the column letter as selected. Do not select only the cells that contain visible data: selecting a range and deleting it can open a different dialog or remove only those cells, shifting some worksheet cells rather than removing the whole column. If the selection outline is limited to a block of cells, click the lettered header again.
- Delete the selected column using the ribbon. On Windows, open the Home tab, select the arrow next to Delete in the Cells group, and choose Delete Sheet Columns. The command removes the entire selected worksheet column. In some ribbon layouts, the Delete control may be displayed as an icon; open its dropdown to find the specific Delete Sheet Columns command rather than choosing a command for clearing cell contents.
- Or use the column-header context menu. With the column selected, right-click its lettered header and choose Delete. This is often the quickest method when you are already working at the top of the sheet. Check that you right-clicked the header, not a cell inside the grid: the options in a cell’s context menu can act on cells or their contents instead of deleting the whole worksheet column.
- Or use the Windows keyboard shortcut. Select the column by clicking its header, then press
Ctrl+-(Ctrl and the minus key). If Excel displays a Delete dialog, choose Entire column and confirm. When a full column is selected, Excel may delete it immediately. If you see a dialog, read the options before confirming; choosing Shift cells left or Shift cells up is not the same as removing the whole worksheet column. - Check the result immediately. The columns that were to the right should move left to fill the gap. Check the new column letters and compare a few identifiable headings or values with the surrounding data. Formulas that refer to deleted cells may change or show an error, so look at important totals and charts as well. If the wrong column disappeared or the result is not what you expected, undo now rather than making more edits first.
- Delete more than one column only after confirming the selection. For adjacent columns, drag across their lettered headers or select the first header and extend the selection across the others; then use the same Delete Sheet Columns command. Excel removes all selected columns and shifts the remaining columns left. For separated columns, you can make a multi-selection with the platform’s modifier key, but the key and behavior can vary. If you are unsure, delete one column at a time and verify each result.
The ribbon path is the clearest method if you are learning Excel because it names the action explicitly. The right-click method is equally useful for a quick deletion, as long as the selection is the column header. In Excel for Mac, the same general ribbon and header context-menu methods apply; if a shortcut differs or does not work with your keyboard setup, use the menu instead. In Excel for the web, select the header and use the available Delete command on the Home tab or the header context menu.
Common Mistakes
- Pressing the keyboard Delete key and expecting the column to disappear. The Delete key generally clears the contents of selected cells; it does not remove the worksheet column. To remove the column structure and shift the columns to its right leftward, use Delete Sheet Columns or the column-header context menu.
- Selecting cells instead of the column header. If you select only a range such as C2:C20, the Delete command may offer options that shift individual cells. Those shifts can misalign data with neighboring columns. Start by clicking the lettered column header when your goal is to remove a whole worksheet column.
- Confusing Clear with Delete. Clear Contents removes values or formulas while leaving the column in place. Clear Formats removes formatting. Neither does the same job as deleting a column. Use the command that explicitly says Delete Sheet Columns when you want the full worksheet column gone.
- Assuming only visible data is removed. A worksheet column extends through the sheet, not just through the rows currently filled in or displayed. It can contain formulas, notes, formatting, validation rules, or data far below the visible area. Check the full column’s role before deleting it.
- Deleting a table field without checking what Excel selected. An Excel table has its own header row and structured columns. A table-specific Delete option may remove just a table column, whereas Delete Sheet Columns removes the worksheet column. Both can change your data layout, so read the menu wording and check the result afterward.
Tips
- Save before a high-impact change. Press
Ctrl+Son Windows orCommand+Son Mac. If the workbook is shared or important, consider using Save As to create a separate copy before deleting columns. A saved copy is a safer fallback than relying only on undo. - Use Undo promptly if the deletion was accidental. On Windows, press
Ctrl+Z; on Mac, pressCommand+Z. Undo reverses the most recent action, so avoid making unrelated edits first. If the file has been closed or the undo history is no longer available, restore a backup or an earlier version if your storage service provides one. - Review formulas and linked content. Excel often adjusts formula references when cells or columns are deleted, but formulas that depend on the removed data may return errors or produce a different result. Check totals, named ranges, charts, PivotTables, and other sheets that use the column. If the information is needed elsewhere, copy or move it before deleting the original.
- Consider hiding instead of deleting. If you only want a less cluttered view or want to keep the data for later, right-click the column header and choose Hide. Hidden columns remain in the workbook and can be unhidden later. Hiding is not a substitute for deletion when you need to remove the data permanently, but it is a reversible option for presentation.
- Be cautious with filters and hidden columns. A filter can make some rows invisible, but selecting a column header still selects the worksheet column. Confirm the header letter and data meaning rather than relying only on the currently displayed rows. If columns are hidden, inspect adjacent letters and unhide them temporarily if you need to verify which one you are removing.
Troubleshooting
The Delete command is unavailable or Excel will not remove the column. The worksheet may be protected. On Windows, open Review and look for Unprotect Sheet; if protection requires a password, you need the password or help from the workbook owner. In a shared or read-only file, you may also lack permission to make changes. Check whether the title bar or sharing controls indicate read-only access, then ask for edit access or save an editable copy if permitted.
Excel deleted cells but left the column in place. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Then click the column letter itself and choose Home > Delete > Delete Sheet Columns. If a Delete dialog appears, choose Entire column. Avoid selecting only the populated cells unless you specifically intend to remove that range and shift other cells.
The remaining data looks misaligned. You may have deleted a range of cells and chosen a shift direction instead of deleting the worksheet column, or you may have removed more than one column. Undo if possible, inspect the selection, and repeat with the lettered header selected. If undo is no longer available, restore the saved copy or use a previous workbook version. Do not try to repair a large misalignment by dragging cells until you have identified exactly what shifted.
A formula, chart, or total changed after deletion. Deleting a column can affect formulas or objects that use its cells. Check the formula bar for affected formulas and inspect the workbook’s key totals and charts. If the deleted information is still available in a backup, restore it or copy the needed data back. For future deletions, note dependencies first; moving the data to another location or hiding the column may be safer when other calculations rely on it.
The command behaves differently inside a formatted table. Click the relevant table header and inspect the context menu. Excel may offer an option for deleting a table column as well as commands that delete worksheet cells. Choose based on your goal: removing a field from the table is not necessarily the same as removing the entire worksheet column. If you want the whole sheet column gone, select its lettered worksheet header and use Delete Sheet Columns, then check nearby data and the table layout.
You cannot find the same button in Excel for Mac or the web. Ribbon arrangements can differ by window size and version. Look on the Home tab for the Delete dropdown, or select the column letter and open its context menu. The menu wording may be shorter in some interfaces. If you cannot confirm that the command deletes the entire column, cancel and use the context menu or ribbon command whose wording clearly identifies a column deletion.
Frequently Asked Questions
Does deleting a column permanently erase its data?
It removes that worksheet column and its contents from the current workbook state. You can usually undo immediately, but do not treat deletion as a secure data-erasure method. Save a backup first if you may need the information later.
How do I delete a column without shifting the others?
A whole worksheet column cannot be removed while leaving the columns to its right in the same positions; Excel closes the gap by shifting them left. If you want to preserve the layout, clear the column’s contents or hide it instead, depending on your goal.
Can I delete several columns at once?
Yes. Select multiple column headers, then choose Delete Sheet Columns or right-click the selection and choose Delete. Adjacent columns are easiest to select together. Confirm the highlighted headers before deleting because all selected columns will be removed.
What is the difference between deleting and clearing a column?
Deleting removes the worksheet column and shifts columns on its right leftward. Clearing removes some or all content or formatting but leaves the column in its place. Pressing the keyboard Delete key usually clears selected cell contents rather than deleting the entire column.
Can I get a deleted Excel column back?
If the deletion was your latest action, use Undo: Ctrl+Z on Windows or Command+Z on Mac. If you have already made other edits, closed the workbook, or lost the undo history, try restoring a saved copy or an earlier version of the file.
Related
- Count Green Cells in Excel: 3 Reliable Ways to Do It
- Count Days Between Dates in Excel: A Practical Guide
- How to Copy the Upper Cell in Excel with a Shortcut
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel IFS Function With Dates: Examples and Date RulesYes. Excel’s IFS function can test dates just like other values: compare a date cell with TODAY(), another…
- SUMIF Excel Formula: Examples, Syntax, and Common FixesTo add values that match one condition, use SUMIF: with regions in A2:A6 and sales in B2:B6, =SUMIF(A2:A6,"East",B2:B6)…
- Excel Sort Entire Row by One Column Without Splitting DataYes. To sort entire rows by one column in Excel for Microsoft 365 on Windows, select the full…
- Excel IF Statement for Dates: Compare DatesIf A2 contains a due date and B2 contains the date you want to check, enter =IF(A2<B2,"Overdue","Not overdue")…
- Filter by Two Criteria in Excel: A Practical GuideTo filter by two criteria in Excel, turn on filters with Data > Filter, then set a condition…
- Excel Date Minus Days: Formulas and ExamplesTo subtract calendar days from a date in Excel, subtract a number from the date cell: if the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.