Explanation

AutoFormat option in excel is a unique way of formatting data quickly.

The first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.