Formula Excel

With this feature you can easily delete things.

Before you press Okay, you first have to choose what area that will effect:

• Selected Range
• Active Sheet
• Active Book

Then select from the available options:

1. Conditional formatting: remove conditional formats
2. Data Validation: delete data validation
3. Formulas: delete the formula and change the formula into value
4. Values: delete the value (become empty cells)
5. Format: deleting formats
6. Hyperlinks: remove hyperlinks and turn it into value
7. Names: Clear Names definition