Format as Table turn the area into a Table also. "When you have a data range that is not formatted as a table, Excel will automatically convert it to a table w

Format as Table turn the area into a Table also. "When you have a data range that is not formatted as a table, Excel will automatically convert it to a table when you select a table style." https://support.office.com/en-us/article/Format-an-Excel-table-6789619f-c889-495c-99c2-2f971c0e2370 https://support.office.com/en-us/article/Format-an-Excel-tab...