Pages

Friday, March 13, 2020

Clear the data in Excel - Part 3

Hi guys,

Today I'm going to write the last option of "Clear". The option is "Clear Hyperlinks". In here we can clear hyperlinks which are linked with Excel sheet. If we just click on this the hyperlinks will clear but the format will be not cleared.


I think you know about the hyperlinks. If not I will share a post about hyperlinks in future.
After we click on the "Clear Hyperlinks" you will be seen a option box on the bottom of the right corner in the selected area. In the option box, there are two options to select what we need to clear. The first option is "Clear Hyperlinks only".

The next option is "Clear Hyperlinks and Formats". In this option, we can clear the hyperlinks and the format of the selected area. And also the last option of "Clear" we can see an option named  "Remove Hyperlinks". This option is the same as the option of "Clear Hyperlinks and Format". The results of these two options are the same and as the below image. 


The options of the "Clear" is finished with these options and hope this will help you. Please do not forget to place a comment. Thank you.

No comments:

Post a Comment