Skip to main content

Excel Tips: Edit > Delete and Clear

Clear Cell Content

How to clear cells if they appear blank but are not in Excel?

How to clear contents and formatting at the same time in cells in Excel?

How to clear contents of named range in Excel?

How to clear entire sheet or specified range in Excel?

How to clear specified cell contents if value of another cell changes in Excel?

How to clear specified cell contents on open and exit in Excel workbook?

How to clear the contents of multiple merged cells in Excel?

How to delete string after nth character in Excel?

How to prevent specific cell contents from being deleted in Excel?

How to quickly delete all contents of unlocked / unprotected cells in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Clear Cell Formatting

How to clear contents and formatting at the same time in cells in Excel?

How to clear table formatting style without losing table data in Excel?

How to quickly clear or remove all formatting of cells in Excel?

How to quickly remove conditional formatting in Excel?

How to remove bold font of pivot table in Excel?

How to remove bold font of pivot table in Excel?

How to remove conditional formatting but keep format in Excel?

How to remove conditional formatting from blank cells in Excel?

How to remove fill color from cells in Excel?

Clear Content of Objects

How to clear contents of combo box with VBA code in Excel?

How to clear contents of textbox when clicked in Excel?