Clear Formats, Contents, Comments and Hyperlinks in Excel

Clear Formats, Contents, Comments and Hyperlinks

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
Clear All Formats, Contents, Comments, Hyperlinks in Excel

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>>

Clear Format in MS-Excel

To clear formatting in Excel 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>>

Clear Contents in MS-Excel

To clear Contents MS-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

Clear Comments in MS-Excel

To clear comments in MS-Excel 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.

Clear Hyperlink in MS-Excel

To remove the hyperlink in MS-Excel 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.

Important Articles