AutoFormat (Format menu)Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. ...

AutoFormat (Format menu)Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the autoformat to that range. If the selection is part of a PivotTable, the entire table, except for the page fields, is selected and formatted. This command is not available if the sheet is protected.