To delete just one cell in Excel and move other cells into its place, select the cell, choose Home > Delete > Delete Cells, then choose Shift cells up or Shift cells left. Do not press the Delete key if you want to remove the cell itself: that clears its contents but leaves the cell and its formatting in place. Deleting a cell changes the layout around it, so check which direction the neighboring data should move before confirming.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the worksheet you want to edit.
- The address of the cell you intend to remove, such as C5, and a clear idea of whether cells below or to the right should move into its position.
- If the data is important, a saved copy of the workbook or a recent saved version. You can usually undo a deletion immediately, but a backup is useful if you continue editing afterward.
Step-by-Step
- Find and select the cell. Click the cell once so it has the active-cell outline. Check its address in the Name Box, which is to the left of the formula bar, if you want to confirm you selected the right location. For example, if the unwanted entry is in C5, the Name Box should show C5. Selecting the cell is not the same as selecting its row or column; avoid clicking the row number or column letter.
- Decide how the gap should close. Look at the surrounding worksheet before deleting. If the values below the selected cell should move upward by one position, choose Shift cells up. If values to its right should move left, choose Shift cells left. This choice affects only the selected cell’s column or row segment; it does not remove an entire worksheet row or column.
- Open the Delete Cells command. On the Windows ribbon, go to Home > Delete, using the arrow on the Delete button in the Cells group, and select Delete Cells. The plain Delete button may offer commands for deleting a whole row or column, so open its menu and choose the specific Delete Cells command. Another route is to right-click the selected cell and choose Delete from the context menu.
- Choose the shift direction. In the Delete dialog, select Shift cells up or Shift cells left. Read the option before confirming: shifting up pulls the cell below into the selected position, while shifting left pulls the cell on the right into it. Choose the direction that keeps the related information arranged as intended.
- Confirm the deletion. Click OK. Excel removes the selected cell and shifts the other cells in that direction. For instance, if you delete C5 and choose Shift cells up, the former C6 moves to C5, C7 moves to C6, and so on in that column. Cells in other columns are not automatically moved with them.
- Check the resulting data. Inspect the cells around the deletion, especially the first cell that moved into the gap and the last populated cell in that sequence. Confirm that records still line up across columns. If a row contains a person’s name, date, and amount, shifting just one cell can make those values belong to different records.
- Review formulas and formatting. If the deleted cell contained a value used by a formula, check the formula results for errors or unexpected changes. Also look at borders, number formats, and conditional formatting in the shifted area. Excel moves cell contents and associated cell formatting as part of the shift, but the visual result can still differ from what you intended.
- Undo immediately if the result is wrong. On Windows, press Ctrl+Z or choose Undo on the Quick Access Toolbar. On Mac, press Command+Z. Undo restores the deletion and the previous cell arrangement, provided you have not closed the workbook or undone past the action. Then repeat the process with the other shift direction, or use a method that clears contents instead.
In Excel for Mac, the same basic operation is available from the Home tab’s Delete menu or the selected cell’s context menu; menu labels may be arranged slightly differently depending on the window and ribbon layout. In Excel for the web, select the cell and use its context menu or the Home tab’s Delete menu, then choose the cell-deletion option and the shift direction if offered. If the web interface does not show the choice you need, open the workbook in the desktop app.
Common Mistakes
Pressing Delete and expecting the cell to disappear. The Delete key normally clears the selected cell’s contents in Excel; it does not close the gap or move neighboring cells. Use Delete Cells when the layout itself should change. Conversely, if you only want to remove a value while leaving the grid in place, pressing Delete is often the right action.
Choosing a whole-row or whole-column command by accident. The Delete menu contains commands that remove an entire row or column. A row deletion affects every cell across that worksheet row, and a column deletion affects every cell down that worksheet column. Choose Delete Cells in the dialog when only one cell should be removed.
Picking the shift direction without checking the data. Shift cells up and Shift cells left are not interchangeable. If columns represent fields in a record, shifting one cell sideways can place a value under the wrong heading. If rows represent records, shifting only one column upward can make the rows inconsistent. Stop and consider whether the cell is part of a structured dataset before proceeding.
Deleting in a table or a merged range. Excel tables are designed to keep a consistent rectangular structure, so they generally do not support shifting a single table cell independently in the way ordinary worksheet cells do. A merged cell can also prevent a shift because it spans multiple grid cells. Do not remove a table row or unmerge a range unless that broader change is what you actually want.
Tips
Use the Name Box to go directly to a cell if the worksheet is large: click the box, type an address such as C5, and press Enter. This helps avoid selecting the wrong cell when rows or columns are narrow, hidden, or far from the current view. Before using Delete Cells, you can also click the cell and inspect the formula bar to see whether it contains a constant, a formula, or nothing visible because of formatting.
When you mean to remove only a value, select the cell and press Delete on a Windows keyboard, or use Home > Clear > Clear Contents if you want to be explicit. Clearing contents preserves the cell itself and generally leaves its formatting intact. To remove contents and formatting, use Home > Clear > Clear All instead; that is a different action from deleting a cell and shifting neighbors.
For a simple list that has one unwanted entry, deleting the cell and shifting up may be appropriate if the list occupies only one column. For a table where each row contains related fields, removing an entire record usually means deleting the table row, not shifting one cell. Use the table’s row-deletion command only when the whole record should go. If you are unsure, duplicate the worksheet first or save a separate copy so you can compare the original layout.
Remember that a cell can look blank while still containing a formula, a space, or formatting. Selecting it and checking the formula bar can help identify what is actually there. Deleting a blank-looking cell can still shift data, so verify the cell address and the surrounding entries rather than relying only on appearance.
Troubleshooting
The Delete Cells option is unavailable or Excel refuses the shift. Check whether the worksheet is protected. If you have permission, go to Review > Unprotect Sheet and enter the password if prompted; without the password, ask the workbook owner. Also check whether the selected cell is part of a merged range or an Excel table. A protected sheet may block edits, a merged range may not allow a partial shift, and a table may require you to clear the value or remove a complete table row instead.
Cells moved, but the worksheet now looks wrong. Undo with Ctrl+Z on Windows or Command+Z on Mac as soon as you notice. If undo is no longer available, restore the workbook from a saved copy or use version history if the file is stored in OneDrive or SharePoint and version history is enabled. Avoid making more edits before deciding how to recover; additional actions can make it harder to return to the earlier layout.
A formula now shows an error or a different answer. Deleting a cell can affect formulas that refer to it or to a range containing it. Excel may adjust a reference when cells shift, but a formula can also return a reference error if the referenced cell is deleted. Select the formula cell and inspect the formula bar, then compare it with the intended inputs. Undo if necessary, or revise the formula after confirming which cells should be included.
Some data did not move with the deleted cell. That is expected when you delete one cell: Excel shifts only the selected cell’s row or column segment, not an entire record across all fields. Undo, then decide whether you meant to delete a complete row or column instead. If the range is filtered, hidden, or part of a table, check the full data set before changing it; the visible cells may not tell the whole story.
The cell disappeared but the worksheet still has an empty-looking spot. A worksheet always retains its grid of cells; deleting one cell does not remove a physical square from the sheet. The selected cell is removed as a position in its local sequence, and other cells shift to fill it. If you wanted to leave the position in place but remove text or a number, clear the contents rather than deleting the cell.
Frequently Asked Questions
How do I delete one cell without deleting the whole row?
Select only the cell, then choose Home > Delete > Delete Cells. In the dialog, select Shift cells up or Shift cells left. Do not select Delete Sheet Rows, which removes every cell in the worksheet row.
What is the difference between Delete and Delete Cells?
The Delete key clears the selected cell’s contents but leaves the cell in place. Delete Cells removes that cell from its local arrangement and shifts neighboring cells up or left, depending on your choice.
Can I delete a cell and leave an empty gap?
Not with the Delete Cells command, because it closes the gap by shifting cells. To leave the cell in place but make it blank, select it and press Delete, or choose Home > Clear > Clear Contents.
Can I delete just one cell inside an Excel table?
Excel tables maintain a consistent row-and-column structure, so deleting a single cell and shifting surrounding table cells independently is generally not available. Clear that cell’s contents, or delete the complete table row if the whole record should be removed.
Will deleting a cell change my formulas?
It can. Excel may update references as cells shift, but formulas that depend on a deleted cell can produce an error or a different result. Review affected formulas after deleting and undo if the change was unintended.
How can I recover a cell I deleted by mistake?
Use Ctrl+Z on Windows or Command+Z on Mac immediately. If you have already closed the workbook or made many later changes, check a backup or the file’s version history if it is stored in OneDrive or SharePoint.
Related
- Copy Horizontal to Vertical in Excel: Transpose Data
- How to Copy an Entire Row in Excel
- How to Copy Down in Excel with the Fill Handle or Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Inserting Citations in Word: A Step-by-Step GuideTo insert a citation in Microsoft Word for Microsoft 365 on Windows, place the cursor where the citation…
- Excel Goal Seek Keyboard Shortcut and How to Use ItIn Excel for Microsoft 365 on Windows, the Goal Seek keyboard sequence is Alt+A, W, G; press each…
- Google Sheets COUNTIF: Exclude Subtotal Rows CorrectlyTo keep subtotal rows out of a Google Sheets count, use COUNTIFS with a condition that rejects the…
- Create a Page Break in Excel: Steps and Print TipsTo create a page break in Excel for Microsoft 365 on Windows, select the cell below and to…
- Change Date Format in Excel for the Web: Step-by-StepTo change a date’s appearance in Excel for the web, select the date cell or range, open Home…
- Excel Find Defined Names: Name Manager, Scope, and UsesTo find defined names in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, or press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.