Clear Contents in Excel (All Things You Should Know)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will show you how you can clear contents in Excel easily. Working with large datasets may require you to clear the contents of datasets quite often. It can be quite tiresome if you don’t know how to clear certain contents.

You may need to clear contents from a single cell or multiple cells. Clearing the contents of multiple cells one by one is time-consuming and tedious. In such cases, you can use the features in Excel to clear content.

You can also use VBA to clear contents automatically.


Download Practice Workbook

You can practice on your own by downloading the free Excel worksheet.


How to Clear Contents in Excel

1. Clear Contents Using Keyboard Shortcut

The easiest and quickest way to clear contents is by using the keyboard shortcut: Del / Delete.

Note: This will not clear any formatting.

1.1 Clear Content of a Single Cell

  • Select the cell that you want to clear contents from and, press the Del / Delete key on your keyboard.

select single cell and press Delete to clear content

  • You can see that the content of that cell is cleared.

content of the single cell is cleared


1.2 Clear Contents from a Range of Cells

  • If you want to clear contents from multiple cells, select the range of cells and press the Del/Delete key on your keyboard.

select range and press Delete to clear contents

  • You can see that the contents of that range of cells are cleared.

Contents of range are deleted


1.3 Clearing Contents from an Entire Row or Column

  • Select the row or column that you want to clear contents from and, press the Del / Delete key on your keyboard.

Select row and press Delete

  • You can see that the contents of that row or column are cleared.

Contents of row are deleted


1.4 Clear Contents from a Whole Worksheet

  • Click on the Select All button on the top left corner of the worksheet to remove contents and press the Del / Delete key.

select entire sheet and press Delete

  • This removes all the contents from the worksheet.

contents of the sheet are deleted


2. Utilizing Clear Button from Editing Option

2.1 Clear All Contents

You can use the Clear button from editing options to Clear Contents, Formattings, Comments and Notes, Hyperlinks, and All Contents.

  • Select the cells or range of cells that you want to clear contents from and go to Home > Editing > Clear.
  • We want to clear all the contents from the selected cells so we select Clear All.

Select cells and go to Editing and then Clear All to clear all contents

  • You can see that all the contents are cleared.

All contents are cleared

Note: You can also access the Clear Contents option in the context menu by right-clicking on your mouse over a range of data.

2.2 Clear Formatting from Cells

  • Select the cells from where you want to clear the formatting and go to Home > Editing > Clear > Clear Formats.

Select Clear Formats to clear formatting

  • The formatting will be removed without the contents.

Formattings are cleared


3. Applying Go To Special Tool to Clear Contents

  • Press the F5 function key on your keyboard.
  • The Go To window appears. Click on Special.

Go to Special Tool to clear contents

  • The Go To Special window appears.
  • Now, select Constants option from the Select group and click on OK.

Select Constants and click on OK

  • Press the Del / Delete key on your keyboard to delete the selected contents.

Press Delete to clear selected contents


4. Using VBA to Clear Contents

  • Select the cells that you want to clear contents from and go to the Developer tab >> Visual Basic.

Select cells and go to Visual Basic to clear contents

  • Insert a new module by going to Insert > Module and insert the following code:
Sub Clear_Cells_from_Selection()
Selection.Clear
End Sub
  • Save the workbook as .xlsm file and Run the code.

Insert code and click on Run to clear contents using VBA

  • Selected cells are cleared.

Cells are cleared using VBA


Things to Remember


Frequently Asked Questions

1. What is the difference between clearing contents and deleting cells?

Ans: There is a huge difference between deleting and clearing contents in Excel. Clearing a cell will remove the value from that cell. If you delete a cell the cell with all its formatting will be removed.

2. Which keyboard shortcut can I use to clear the contents of selected cells in Excel?

Ans: You can use the Del / Delete key on your keyboard to clear the contents of selected cells.

3. If I clear the contents of a cell, will the formatting remain?

Ans: Yes, clearing contents will not remove any formatting from a cell.


Conclusion

In this article, we have shown you some quick and effective ways to clear content in Excel. Clearing particular contents can be difficult if you do not know how to clear them. We suggest you go through the full article carefully to understand it better and apply the knowledge afterward according to your needs.


Clear Contents in Excel: Knowledge Hub


<< Go Back to Entering and Editing Data in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Maruf Niaz
Maruf Niaz

Md. Maruf Niaz, BSc, Textile Engineering, Bangladesh University of Textiles, has worked with the ExcelDemy project for 11 months. He works as an Excel and VBA Content Developer who provides easy solutions to Excel-related problems and regularly writes fantastic content articles. He has published almost 20 articles in ExcelDemy. As an Excel & VBA Content Developer for ExcelDemy, he offers solutions to complex issues. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo