To delete one cell in Excel and move nearby data into the gap, select the cell, choose Home > Delete > Delete Cells, select Shift cells left or Shift cells up, and click OK. If you only want to remove the cell’s contents while keeping its place, select it and press Delete instead. Check which result you need before proceeding, because shifting cells changes the layout around the selected cell.
What You’ll Need
- A workbook open in Excel for Microsoft 365 on Windows, with the worksheet you want to edit.
- The location of the cell you intend to remove. If the data is important, save a copy of the workbook first or be ready to use Undo.
- Permission to edit the sheet. A protected worksheet may prevent cell deletion until it is unprotected.
Step-by-Step
- Choose the right kind of deletion. Decide whether you mean to remove the cell’s contents or remove the cell from the grid and shift other cells into its position. Pressing Delete clears the selected cell’s contents; it does not close the gap or move neighboring cells. To remove the cell itself and shift data, use the Delete Cells command described below. This distinction matters when nearby rows and columns need to stay aligned.
- Select the cell. Click the cell once so it has the selection border. You can also click the Name Box, located to the left of the formula bar, type the cell address such as D6, and press Enter. If you use the Name Box, make sure the address identifies only one cell, not a range such as D6:D10. Check the selection before deleting, especially if the worksheet is zoomed out or has narrow columns.
- Open the Delete Cells command. On the Windows ribbon, select Home > Delete in the Cells group, then choose Delete Cells from the menu. You can also right-click the selected cell and choose Delete…. The three-dot menu item opens a dialog, rather than immediately removing the cell, so you can choose how the surrounding cells should move. Avoid selecting the separate Delete Sheet Rows or Delete Sheet Columns commands unless you intend to remove an entire row or column.
- Choose how to close the gap. In the Delete dialog, select one of the two cell-shift options. Choose Shift cells left when the cells in the same row should slide left to fill the space. Choose Shift cells up when cells below should move up to fill it. The dialog may also offer options to delete an entire row or column; do not choose those for a one-cell deletion. If you are unsure, cancel the dialog and inspect the surrounding data before making a choice.
- Confirm and inspect the result. Click OK. Excel removes the selected cell and moves the other cells in the direction you chose. Look at the edited row or column and at nearby values to confirm that the intended data moved and that headings still correspond to the right records. If the result is wrong, press Ctrl+Z immediately to undo, then repeat the steps with the other shift direction or use Clear Contents if you meant to keep the cell in place.
- Save the workbook when the layout is correct. Use Ctrl+S on Windows or choose File > Save. If the workbook is shared or stored in OneDrive, confirm that your edits have finished syncing before closing it. Saving does not change the deletion method, but it ensures the corrected worksheet is retained.
Keyboard option on Windows: Select a single cell and press Ctrl+- (Ctrl plus the minus key) to open the Delete dialog. Then choose Shift cells left or Shift cells up and confirm. On a Mac, the menu route Home > Delete > Delete Cells is a dependable alternative; keyboard shortcuts can differ with the keyboard and Excel version. In Excel for the web, select the cell, open the delete options on the Home tab, and choose the cell-deletion command if available; you can also right-click and look for Delete Cells. Menu labels and placement may vary slightly by browser or version.
Common Mistakes
- Pressing Delete when you meant to remove the cell. This clears the cell’s contents but leaves the grid unchanged. Use Delete Cells and select a shift direction when you want other cells to move into the gap.
- Deleting a whole row or column by accident. The Delete menu includes commands for entire rows and columns. Check the menu item and the dialog selection before confirming; those options affect far more than the selected cell.
- Choosing the wrong shift direction. Shifting left affects cells to the right in the relevant row; shifting up affects cells below in the relevant column. A wrong choice can misalign a list, table-like range, or paired values. Undo promptly if the result is not what you intended.
- Assuming the cell’s formatting is cleared with its contents. The Delete key removes contents, but typically leaves formatting such as fill color, borders, and number format. If you want to remove formatting too, use Home > Clear > Clear All for that cell, taking care not to clear more than you intend.
- Trying to shift a cell inside an Excel table. Excel tables keep their records in a structured layout, so you generally cannot shift one table cell independently without affecting the table structure. Use the table’s row or column controls when you need to remove a record or field, or convert the table to a normal range only if that is appropriate for your workbook.
Tips
- Preview the area around the cell. Before deleting, note the values immediately to its left, right, above, and below. That makes it easier to judge which direction will preserve the meaning of the data. If each row represents one record, shifting just one cell can break the relationship between fields, even if the resulting worksheet looks tidy.
- Use Clear Contents when the layout must remain fixed. Select the cell and press Delete, or choose Home > Clear > Clear Contents. This removes entered values or formulas while leaving the cell and its position in place. Use Clear All only when you also intend to remove formatting and other cell contents.
- Use Undo as a quick safety net. Ctrl+Z on Windows reverses the most recent edit. If you notice that values shifted in the wrong direction, undo before doing other work. Undo is not a substitute for a backup when making broad changes, and it may not reverse actions after the workbook has been closed or its history has changed.
- Check formulas and references. Excel often adjusts references when cells are deleted, but a formula’s result or meaning can still change. After a deletion, inspect nearby formulas and any totals, charts, or dependent calculations that use the affected range. If Excel displays a reference error, review the formulas that referred to the deleted cell.
- Consider deleting a row or column for structured data. If the cell is part of a record where every column belongs together, deleting only one cell can put values under the wrong headings. Removing the complete record row, or the complete field column, is usually more consistent—provided that is truly what you want.
Troubleshooting
The Delete Cells option is unavailable or Excel will not delete the cell. The worksheet may be protected, or the selection may be inside a feature with its own structure, such as an Excel table or a merged range. If you have permission, go to Review > Unprotect Sheet and try again. A password-protected sheet requires the password or help from its owner. For a table, use its row or column options rather than trying to shift an individual cell. For merged cells, consider unmerging them first with Home > Merge & Center > Unmerge Cells, then reassess the intended edit.
The wrong neighboring values moved. Press Ctrl+Z on Windows (or use Edit > Undo on a Mac) straight away. Reopen the Delete dialog and choose the other shift direction. If the change is no longer available to undo, use a saved copy or version history if the workbook has one; do not try to repair a complex range by repeatedly deleting and inserting cells without checking the original layout.
The cell looks empty but still has a color, border, or unusual number format. That is expected if you pressed Delete, because clearing contents does not necessarily remove formatting. Select only the affected cell and use Home > Clear > Clear Formats to remove formatting, or Home > Clear > Clear All to remove contents and formatting together. Review the selection first so you do not clear an entire range.
A formula now shows an error or a result changed. Deleting a referenced cell can alter formulas or leave a broken reference, depending on the formula and the surrounding range. Undo if possible, then consider clearing the cell’s contents instead of deleting the cell, or remove a whole row or column if the data structure calls for it. Recheck formulas and totals after any structural edit.
The keyboard shortcut does not open the dialog. Confirm that the worksheet cell is selected and that you are pressing Ctrl and the minus key together on Windows. Some keyboards place minus on a different key or require a particular key combination. Use the ribbon or right-click menu instead; these routes make the deletion choices visible and avoid relying on a shortcut that may differ by keyboard layout or platform.
Frequently Asked Questions
Does pressing Delete remove a cell in Excel?
No. It clears the selected cell’s contents, while the cell remains in the worksheet and surrounding cells stay where they are. To remove the cell and close the gap, choose Delete Cells and select a shift direction.
How do I delete one cell without shifting other cells?
Select the cell and press Delete, or use Home > Clear > Clear Contents. This removes its value or formula without moving neighboring cells. If you also need to remove its formatting, use a Clear option that includes formatting.
Should I choose Shift cells left or Shift cells up?
Choose Shift cells left to move cells on the same row into the gap, or Shift cells up to move cells below it upward. Base the choice on how the surrounding values are organized, and check that records and headings remain aligned.
Can I undo deleting a cell?
Usually, yes. Press Ctrl+Z on Windows or use Edit > Undo on a Mac immediately after the deletion. If you have made many later edits or closed the workbook, Undo may not be available; check for a saved copy or version history.
Can I delete a single cell in an Excel table?
Excel tables are designed to keep records and fields aligned, so they do not behave like an ordinary range when shifting one cell. To remove data from a table, clear the cell’s contents, or use the table’s row or column controls if you mean to remove a whole record or field.
Does deleting a cell remove its formatting?
Not necessarily. Clearing contents or deleting a cell can leave formatting behind in the worksheet. To remove formatting from a selected cell, use Home > Clear > Clear Formats; use Clear All only when you want to remove all cell contents and formatting as well.
Related
- How to Copy Multiple Sheets in Excel Without Errors
- How to Copy Only Filtered Data in Excel Without Hidden Rows
- How to Copy Only Selected Cells in Excel Without Extra Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Block a Sender in Outlook Mail: Steps, Limits and TipsTo block a sender in Outlook, select a message from that person, open the message actions or Junk…
- Google Sheets: Highlight a Row When a Checkbox Is CheckedYes. In Google Sheets, you can highlight an entire row when its checkbox is checked by applying conditional…
- Excel Keyboard Shortcuts: Settings and CustomizationExcel for Microsoft 365 on Windows does not provide one settings page where you can remap every built-in…
- Excel Time Minus Time: Calculate Hours Between TimesTo subtract one time from another in Excel, enter the start time in A2 and the end time…
- Google Sheets Date Difference: Formulas and ExamplesIn Google Sheets, subtract the earlier date from the later date to get the difference in days: if…
- Excel Cell Multiple Lines: Add Line Breaks and Wrap TextTo put multiple lines in one Excel cell, edit the cell, place the cursor where the next line…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.