Format as Table

Format as Table You can quickly format your worksheet data by applying a predefined table style. However, when you apply a predefined table style, an Excel table is automatically created for the selected data. If you don't want to work with your data in a table, but keep the table style formatting, you can convert the table back to a regular range.

Short Key --> Alt + H + T (Using Alt Key Concept explained in Short Keys Section)

12KB

Format as a Table.xlsx

Example for Format as Table