Copy and Clear Format
Excel’s Format Painter feature to copy format is one of the most underutilised features of Excel. Format Painter is used to copy formatting from a cell or range of cells and apply it to another in the same spreadsheet or another sheet in the same workbook. With our Format Painter video tutorial, you will learn to match the formatting on the new data with that of the old with one click, rather than trying to duplicate the formatting applied from scratch. In the Clear Cell Format video, you will be able to clear cells formats, contents, and comments.