How to Delete a Cell in Excel (4 Easy Ways)

We are going to use a datasheet with four columns containing sales information for some sales representatives. This table represents sales information for different locations. The columns are Sales Rep, Location, Product, and Sales.

sample dataset to Delete a Cell in Excel

Method 1 – Using the Delete Cells Feature in the Home Tab to Delete a Cell in Excel

Steps:

To delete a cell using the ribbon, select the cell you want to delete.
Open the Home tab >> Go to Cells >> From Delete, select Delete Cells. Here, we select cell B10.

A dialog box will pop up, showing 4 Delete options.
Select Shift cells left.
Click OK.

The Delete option Shift cells left will delete the selected B10 cell also it will shift the rest of the adjacent cells C10, D10, and E10 of the Location, Product, and Sales column to the left.

Delete a Cell in Excel

To delete a cell using the ribbon, select the cell you want to delete.
Open the Home tab >> Go to Cells >> From Delete, select Delete Cells. Here, we selected cell B10.

A dialog box will pop up that will show some Delete options.
Select Shift cells up.
Click OK.

select shift cells up option

The Delete option, which shifts cells up, deletes the selected B10 cell and shifts the rest of the Sales Rep’s cells (B10:B15) upward.

Method 2 – Deleting a Cell Through the Context Menu

Steps:

Select the cell, right-click on the right side of the mouse, and select Delete. Here, we selected cell C11.

use context menu to Delete a Cell in Excel

A dialog box will pop up, showing 4 Delete options.
Select Shift cells left.
Click OK.

select shift cells left

The Delete option (Shift cells left) will delete the selected C11 cell. It will also move the rest of the adjacent cells, D11 and E11, of the Product and Sales column to the left.

Delete a Cell in Excel

Select the cell, right-click on the right side of the mouse, and select Delete. Here, we selected cell C11.

A dialog box will pop up, showing 4 Delete options.
Select Shift cells up.
Click OK.

The Delete option Shift cells up will delete the selected C11 cell and shift the rest of the adjacent cells (C11:C15) of the Location column upward.

Delete a Cell in Excel

Method 3 – Using Excel VBA to Delete a Cell

Steps:

Insert the code in the VBA window.
To open the VBA window, click the Developer tab on your ribbon.
Select Visual Basic from the Code group.

open VBA window

A new window of Microsoft Visual Basic for Applications will appear.
Open Insert >> Select Module.

insert module

Enter the code in the module:

Sub Delete_Cells()
Range("b9").Delete
End Sub

Close the Visual Basic window.
Press Alt+F8.
When the Macro dialogue box opens, select the following macro in the Macro name.
Click on Run.

It will delete the selected cell and shift the rest of the cells in the Sales Rep column upward.

Delete a Cell in Excel

Method 4 – Removing an Unwanted Cell in Excel

Steps:

Select the row in which you want to separate text.
Open the Data tab >> go to Data Tools >> Select Text to Columns.

Delete a unwanted Cell in Excel

A dialog box called Convert Text to Columns Wizard will pop up.
Select the Delimited file type.
Click Next.

Select the Delimiters Space.
Click Next.

select space

Select the Destination where you want to place your converted text.
We made two new columns, which are Sales Rep Name and Email ID.
As we want to place my converted text in these columns we have chosen the Destination of these columns.
Click Finish.

click on Finish

You will see the converted text in the new columns.

As we want to keep the Sales Rep Name and Email ID columns text so we will remove the C11 and C12 cells.

Select the cell you want to delete.
Open the Home tab >> Go to Cells >> From Delete, select Delete Cells.

select delete option to Delete a Cell in Excel

A pop-up dialog box will appear with 4 Delete options.
Select Shift cells left because we want to show these two columns as adjacent.
Click OK.

You will get the following output.

finally Delete a unwanted Cell in Excel

How to Delete a Cell Range in Excel

Steps:

To delete a cell range, select the cell range you want to delete.
Open the Home tab >> Go to Cells >> From Delete, select Delete Cells.
Select the range (B8:B12) cell.

select delete cells option to Delete a Cell in Excel

A pop-up dialog box will open showing 4 Delete options.
Select Shift cells left.
Click OK.

The Delete option Shift cells left will delete the selected range (B8:B12) cell; also, it will shift the rest of the adjacent cells of range (B8:B12) to the left.

Delete a range of Cell in Excel

Open the Home tab >> go to Cells >> from Delete select Delete Cells.
Select the range (B8:B12) cell.

Select the Shift cells up option from the Delete.
Click OK.

The Delete option, which shifts cells up, deletes the selected cell range (B8: B12) and shifts the rest of the Sales Rep’s cell range (B8: B12) upward.

finally Delete a range of Cell in Excel