Clear Formatting | Contents | Comments |  in MS Excel 2016
Channel: Clarah's Tech Hub
Date: 2020-09-09

When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. 



In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first.


Manually changing cell color, font, borders, alignment and other formats would be tiresome and time-consuming. 



Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet. 



Moreover, there is a way to remove only specific formatting, and I you will learn all these techniques in a moment