In Excel, "clear formatting" or deleting formatting refers to the process of removing all of the formatting applied to a cell or range of cells. This includes formatting such as font type and size, text color, cell borders, and fill color. br br When you clear formatting from a cell or range of cells, the cells will be returned to their default formatting, which is determined by the worksheet's theme and the settings in the "Normal" style. The cells will also lose any conditional formatting or data validation rules that were applied to them. br br Clearing formatting can be useful in a number of situations, such as when you've applied formatting to a cell or range of cells by mistake, or when you want to change the formatting of a group of cells but don't want to manually remove the existing formatting. br br To clear formatting, follow these steps. br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear Formatting br br br Essentially, there area 5 type of clearing cell properties and data. They are listed below. br br Clear All br Deletes everything from the selected cell(s). br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear All br br Clear Formatting br Delete all formatting from the selected cell(s). br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear Formatting br br Clear Content br Deletes the content of the cell from the selected cell(s). br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear Content br br Clear Comment br Deletes cell comments from the selected cell(s). br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear Comments br br Clear Hyperlinks br Deletes hyperlinks from the selected cell(s). br 1) Ctrl + A br 2) Home --- Editing --- Clear br 3) Clear Hyperlinks br br Remove Hyperlinks br Deletes hyperlinks and formats the cell from the selected cell(s).