This article will guide you to create Styles for the table in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Table Styles
This article will show you how to use table styles and customize it.
1. Click any cell in the table
2. On the Home tab, click Format as Table.
3. Choose a style for your table
Note: click New Table Style to create your own style, or right-click the table style and click Duplicate to create a new style similar to the existing table style.
4. Excel automatically selects the data for you. Select ‘My table has headers’ and click OK.
Result
To convert this table back to a normal cell (and keep the format intact), perform the following steps.
5. First, select a cell inside the table. Next, on the Design tab, click Convert to Range.
Result
In addition, you can also view many other excel articles here.