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

It may require removing an unwanted cell. We can easily do it by deleting a cell. In this article, I am going to explain several ways of how to delete a cell in Excel.

To make it clearer, I’m going to use a datasheet of sales information of some sales representatives which has 4 columns.
This table represents sales information for different locations. The columns are Sales Rep, Location, Product, and Sales.

Sample datasheet

Workbook to Practice

Ways to Delete a Cell in Excel

1. Delete a Cell Using Excel Feature

a. Using Ribbon

I. Shift Cells Left

To delete a cell using ribbon, first, select the cell you want to delete. Then open the Home tab >> go to Cells >> From Delete select Delete Cells.
I selected the B9 cell.

Using ribbon to delete a cell

Now, there will pop up a dialog box where it will show 4 Delete options. From there I selected Shift cells left. Finally, click OK.

Using ribbon to delete a cell

The Delete option Shift cells left will delete the selected B9 cell also it will shift the rest of the adjacent cells C9, D9, and E9 of the Location, Product, and Sales column to the left.

A cell is deleted using shift cells left

II. Shift Cells Up

To delete a cell using ribbon, first, select the cell you want to delete. Then open the Home tab >> go to Cells >> From Delete select Delete Cells.
Here, I selected the B9 cell.

Using ribbon to delete a cell

Now, there will pop up a dialog box where it will show some Delete option. From there I selected Shift cells up. Finally, click OK.

Using ribbon to delete a cell

The Delete option Shift cells up will delete the selected B9 cell also it will shift the rest of the cells (B10:B15) of Sales Rep upward.

A cell is deleted using shift cells up

b. Using Right-Click

I. Shift Cells Left

First, select the cell then right-click on the right side of the mouse then select Delete.
Here, I selected the C10 cell.

Using right-click to delete a cell

Now, it will pop up a dialog box where it will show 4 Delete options. From there I selected Shift cells left. Then finally, click OK.

Using right-click to delete a cell

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

A cell is deleted using shift cells left

II. Shift Cells Up

First, select the cell then right-click on the right side of the mouse then select Delete.
Here, I selected the C10 cell.

Using right-click to delete a cell

Now, it will pop up a dialog box where it will show 4 Delete options. From there I selected Shift cells up. Then finally, click OK.

Using right-click to delete a cell

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

A cell is deleted using shift cells up

Read more: How to Shift Cells Down in Excel

2. Delete a Cell Using VBA

First, open the Developer tab >> then select Visual Basic.

Opening Visual basic

Now, a new window of Microsoft Visual Basic for Applications will appear.
Then, open Insert >> then select Module.

Inserting a module in VBA

Here the Module is opened.

Module of VBA

 

Now, write the code to Delete a cell in the module.

Sub Delete_Cells()

Range("b9").Delete

End Sub

VBA code to delete a cell

Now Save the code and go back to the worksheet. Then open the View tab >> then go to Macros >> select View Macros.

Using macros to run VBA

Now, a dialog box will pop up. It shows the saved Macro name. Now select the Delete_Cell from the Macro name and the worksheet from the Macro in. Finally, click Run.

Using macros to run VBA

It will delete the selected cell. Also, it will shift the rest of the cells of the Sales Rep column upward.

Deleted a cell using VBA


Similar Readings:


3. Delete a Cell Range in Excel

To delete a cell range, first, select the cell range you want to delete. Then open the Home tab >> go to Cells >> From Delete select Delete Cells.
I selected the range (B7:B11) cell.

Using ribbon to delete a cell

Now, it will pop up a dialog box where it will show 4 Delete options. From there I selected Shift cells left. Finally, click OK.

Using ribbon to delete a cell range

The Delete option Shift cells left will delete the selected range (B7:B11) cell also it will shift the rest of the adjacent cells of range (B7:B11) to the left.

A cell range is deleted using shift cells left

In case you want to delete the cell range using Shift cells up then select the Shift cells up option from the Delete. Then, click OK.

A cell range is deleted using shift cells up

The Delete option Shift cells up will delete the selected cell range (B7: B11) also it will shift the rest of the cells range (B7:B11)  of Sales Rep upward.

A cell range is deleted using shift cells up

You can delete a cell range using right-click also. After selecting the range of cells follow the steps I have shown in delete a cell using right-click.

4. Delete an Unwanted Cell

To delete an unwanted text from a column we can use Text to Columns and Delete Cells.
To separate the unwanted text from a row we will use Text to Columns.
First, select the row you want to separate text. Then, open the Data tab >> Go to Data Tools >> then select Text to Columns.

Using text to columns to separate a row

Now, it will pop up a dialog box named Convert Text to Columns Wizard. Here, select the Delimited file type then click Next.

Select convert text columns wizard

Now, select the Delimiters Space then click Next.

Using text to columns to separate a row

Now select the Destination where you want to place your converted text.

Selecting Destination

I made two new columns which are Sales Rep Name and Email ID. As I want to place my converted text in these columns so I have chosen the Destination of these columns. 

Destination selected

As Destination is selected finally, click Finish.

Finish the convert text to columns wizard

Here you will see the converted text in the new columns. As I want to keep the Sales Rep Name and Email ID columns text so I will remove the C11 and C12 cells.

Text is converted into new columns

Now, select the cell you want to delete. Then open the Home tab >> go to Cells >> From Delete select Delete Cells.

Using ribbon to delete a cell

Now, it will pop up a dialog box where it will show 4 Delete options. From there I selected Shift cells left because I want to show these two columns as adjacent. Finally, click OK.

Using ribbon to delete a cell

The unwanted cells will be deleted.

A cell is deleted using shift cells left

Conclusion

In this article, I explained several ways of how to delete a cell in Excel. I hope these different approaches will help you to delete a cell in Excel. For any kind of suggestions, ideas, and feedback you are most welcome. Feel free to comment down below.


Further Readings

Tags:

Shamima

Shamima

Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo