Menu

Clear Formats, Contents, Comments and Hyperlinks in Excel

0 Comments

Clear Formats, Contents, Comments and Hyperlinks in Excel:

Clear Formats, Contents, Comments, and Hyperlinks in Excel:  These commands are very useful to remove everything like Formats, Contents, Comments or Hyperlinks from the selection in a worksheet.

Clear All Formats, Contents, Comments, Hyperlinks in excel
To do so follow the steps given below:

1. Clear All Formats, Contents, Comments and Hyperlinks.

To clear all the Formats, Contents, Comments, and Hyperlinks from the selection. Follow the steps below to clear all.

    1. Select the content you want to remove all

    2. On the home tab, in the editing group, click on the Clear

    3. Then select the “Clear All” from the list of options. Click here to learn about Clear all the Formatting in MS-Word>>

2. Clear Format:

To clear only the formatting from the selection, follow the step below:

    1. Select the content you want to remove the Formatting

    2. On the home tab, in the editing group, click on the Clear

    3. Then select the “Clear Format” from the list of options. Click here to learn about Clear all the Formatting in MS-Word>>

3. Clear Contents:

To clear only Contents in an excel spreadsheet, follow the step below

    1. Select the content you want to Clear all the Contents except Formats and Comments

    2. On the home tab, in the editing group, click on the Clear

    3. Then select the “Clear Contents” from the list of options

4. Clear Comments:

To remove only comments in a worksheet, follow the steps below:

    1. Select the content you want to Clear the Comments

    2. On the home tab, in the editing group, click on the Clear

    3. Then select the “Clear Comments” from the list of options. Click here to learn how to insert comments.

5. Clear Hyperlink:

To remove the hyperlink from the selected text.

    1. Select the content you want to clear the Comments

    2. On the home tab, in the editing group, click on the Clear

    3. Then select the “Clear Hyperlink” from the list of options.

JOIN OUR NEWSLETTER
I agree to have my personal information transfered to MailChimp ( more information )
Join over 3.000 visitors who are receiving our newsletter.
We hate spam. Your email address will not be sold or shared with anyone else.

Leave a Reply

Your email address will not be published. Required fields are marked *