What's up, everyone?
Today I'm going to write about the "Clear" option in excel. Here we can be managed which is the method we want to clear the data. You can see it on the ribbon under the Home.

Ok. Let’s try this. I will use the below details to explain this opinion.

Here, there are some data that I'm going to use with the "Clear" option. In this table, there are numbers, formulas, and hyperlinks. In column C, There are formulas. Next to the column C, there are hyperlinks. I will write a post about "Hyperlinks" in the future and I'm just using this to explain the "Clear" Option.

Let's select all the data to use the clear option. After selecting the data, just go to the Home and find the "Clear" Option on the right-hand side of the ribbon.

When you bring the mouse pointer on the clear option, you will be shown a helping menu describing the option.

According to that, We can be able to remove everything from the cell, or selectively remove the formatting, the contents, or the comments. So, let's see how it works.
When you click the clear option you will be shown an option list as below. Let's see the 1st option.

After selecting the whole data, Just go to the "Clear" option and select the 1st clear option named "Clear All". Then the result will be as below.

It will clear all of your data including the cell formats, comments, formulas, hyperlinks and all. You will not be able to find any data after use this option.

The next option is "Clear Formats"
In this option, all your data will be protected and all the formats you have already used will be removed from the selected area.