In Microsoft Excel, there are numerous options that customers can use when it comes to formatting their spreadsheets. Excel customers can simply take away content material from their spreadsheets utilizing the Clear feature. The Clear feature deletes every thing in the cell or removes the formatting contents, feedback, and hyperlinks. The Clear menu consists of options reminiscent of Clear All, Clear Content material, Clear Codecs, Clear Feedback and Notes, Clear Hyperlinks, and Take away hyperlinks. On this tutorial, we are going to clarify how to use the Clear feature in Microsoft Excel.
How to use the Clear feature in Excel
We are going to present you ways to use the Clear feature in Microsoft Excel to:
- Clear Codecs.
- Clear Contents
- Clear Feedback and Notes.
- Clear Hyperlinks and Take away Hyperlink
1] Clear Codecs in Excel
- Launch Microsoft Excel.
- Enter knowledge into the spreadsheet or use present knowledge.
- Format knowledge in considered one of the cells.
- Choose the formatted knowledge.
- On the Residence tab, click on the Clear button and choose Clear Codecs from the menu. The Clear Format feature clears solely the method that’s utilized to the chosen cell.
- The format utilized to the knowledge shall be eliminated.
2] Clear Contents and Clear All in Excel
- Open Excel spreadsheet
- Choose a cell containing knowledge.
- On the Residence tab, click on the Clear button and choose Clear Contents from the menu.
- The Clear Contents feature clears solely the content material in the chosen cell.
- The content material in the chosen cell is eliminated.
- The Clear all feature does the identical motion as the Clear Content material feature.
3] Clear Feedback and Notes in Excel
- Open Excel sheet
- Choose the cell containing the remark or be aware.
- On the Residence tab, click on the Clear button and choose Clear Feedback and Notes from the menu.
- The Clear Feedback and Notes feature clears any remark or be aware connected to the chosen cell.
- The Remark is eliminated.
4] Clear Hyperlink and take away Hyperlink in Excel
- Open the Excel spreadsheet
- Choose the cell containing the hyperlink.
- On the Residence tab, click on the Clear button and choose Clear Hyperlink from the menu. The hyperlink feature clears the hyperlink from the chosen cell.
- A small clear button will seem beside the hyperlink; choose Clear Hyperlinks and Format.
- The Hyperlink shall be eliminated. You may also choose Take away Hyperlink to erase the hyperlink inside the cell.
We hope you perceive how to use the Clear feature in Excel.
What’s the shortcut for Clear contents?
If you need clear contents in your cells utilizing a shortcut, choose all the cells that you really want to clear by urgent the Ctrl + A button, then click on the Delete key to delete all contents in the cell.
READ: How to take away Areas between Characters and Numbers in Excel?
How do I clear contents in Excel however preserve the formulation?
To clear contents in Microsoft Excel however preserve the method inside the cell, comply with the steps under:
- Press the F5 key in your keyboard.
- The Go To dialog field will open.
- Click on the Particular button.
- The Go To Particular field will open.
- Choose the Fixed button. The checkboxes under System will grow to be obtainable. Guarantee all the packing containers under are checked.
- Then click on Okay.
- Press the Delete key on the keyboard.
- You’ll discover that every one the knowledge in the cells shall be deleted besides the method in the spreadsheet.
READ: How to add Hyperlinks to Excel sheet.
