Clear Formats, Contents, Comments and Hyperlinks in Excel
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.
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.
Select the content you want to remove all
On the home tab, in the editing group, click on the Clear
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:
Select the content you want to remove the Formatting
On the home tab, in the editing group, click on the Clear
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
Select the content you want to Clear all the Contents except Formats and Comments
On the home tab, in the editing group, click on the Clear
Then select the “Clear Contents” from the list of options
4. Clear Comments:
To remove only comments in a worksheet, follow the steps below:
Select the content you want to Clear the Comments
On the home tab, in the editing group, click on the Clear
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.
Select the content you want to clear the Comments
On the home tab, in the editing group, click on the Clear
Then select the “Clear Hyperlink” from the list of options.
