Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More...Less Show You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), and any attached comments. The cleared cells remain as blank or unformatted cells on the worksheet.
Notes:
Need more help?How do I clear the content only from the selected cell?To clear all contents, formats, and comments that are contained in the selected cells, click Clear All. To clear only the formats that are applied to the selected cells, click Clear Formats. To clear only the contents in the selected cells, leaving any formats and comments in place, click Clear Contents.
How do I use single command to clear content and format in Excel?If you want to clear the contents of a cell or range in Microsoft Excel, you can use . ClearContents . If you also want to clear the formatting, you can use . ClearFormats .
|