Excel users can easily remove content from their spreadsheets using the Clear feature. The Clear feature deletes everything in the cell or removes the formatting contents, comments, and hyperlinks.

To clear all contents, formats, and comments in the selected cells, click Clear All. To clear only the formats that are applied to the selected cells, click Clear Formats.

How to Clear the Column List in an Excel Spreadsheet. Microsoft Excel is filled with a number of quick tricks that can be used to make fast changes to multiple cells in a spreadsheet.