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.
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>>
Clear Format in MS-Excel
To clear formatting in Excel 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>>
Clear Contents in MS-Excel
To clear Contents MS-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
Clear Comments in MS-Excel
To clear comments in the MS-Excel 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.
Clear Hyperlink in MS-Excel
To remove the hyperlink in MS-Excel 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.
