Skip to main content

How to Use the Clear Functions in Excel

Learn how to use the clear functions in this Howcast Excel tutorial with expert Shir Moscovitz.


Hi, my name is Shir and I'm the founder and CEO of where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.

Alright, now let's talk about the Clear Function in EXCEL. There's a number of ways to do this. So the first way is to select the CELL you want to delete the contents from and then hit the DELETE key on the keyboard. Another option is to right click on the CELL you want and do Clear Contents. Yet a third option is to go to the Clear Function here on the Ribbon which is on the Home tab. You can do Clear All which gets rid of everything or you can just Clear the Format, the Contents or the Comments or Hyperlinks on its own. Let's try and see what that looks like. If we Clear the Format, we still get the same data which hasn't changed but the Formatting was lost.
We can also then Clear the Contents or we can do it all in one sweep like this with Clear All.

One thing to keep in mind is when you're selecting a lot of CELLS at once and you hit the BKSP, it will actually not work properly. It will only delete the contents from the first CELL. Instead, select all of them and then hit the DELETE key or use the other Clear Function on the RIBBON. You can Clear All or you can Clear just the items that you want. And that's how you use the Clear Function in EXCEL.

Popular Categories