Clear Formats, Contents, Comments and Hyperlinks in Excel

Clear Formats: Used to remove each and every format like colour, size, and other from the selection in a worksheet.

Clear All: Used to remove all content and formats in an Excel Worksheet.

Clear Contents: Only removes contents in a Worksheet

Clear Comments: Removes comment in a Worksheet.

Clear Hyperlinks: Clears 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>>
See also  How to Show or Hide Ink in Excel, Word, and Ppt

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 Formatfrom 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
See also  Using Total Formula in Excel - 2022

Clear Comments in MS-Excel

To clear comments in the 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.
See also  How to Split Text to Columns in Excel - 2022

Important Articles: