How to Create and Format the Table Styles in Excel?

Below, we have used examples to create an excel tableCreate An Excel TableIn excel, tables are a range with data in rows and columns, and they expand when new data is inserted in the range in any new row or column in the table. To use a table, click on the table and select the data range.read more and format the table styles.

Example #1 – Creating the Table

Let us start the process by creating the table. We have had a simple sales table for ten years.

We must first place a cursor inside the data and press the “Ctrl + T” (shortcut key to create tables). We may see a “Create Table” box. Next, check the box “My data has headers.”

Now, we have our table created. It looks like this.

Example #2 – Change the Default Format of Table Style in Excel

Excel applied one of the default table styles in Excel. In Excel, we have many inbuilt table styles to select. We can change the existing table style to Excel at any time.

Example #3 – Create Your Own Table Format Style in Excel

We are not restricted from working with in-built table styles. Rather, we create our table style to satisfy ourselves. Under the “New Table Style,” we can design our new table style.

  • We must first place a cursor inside the table. As soon as we select one table cell, the “Design” tab will activate in the ribbon. Under the “Design” tab, we have many inbuilt table styles to select. Then, we need to click on the “Table Styles” drop-down list. We can see three categories: “Light,” “Medium,” and “Dark.” We can select any one of them to change the existing table style. If we move over a specific table, Excel may show its preview immediately.

Now, we must click on “New Table Style.” We may see the window shown below.

The first thing we need to do is to give a table name. Therefore, we have provided the name “My Table Style.”

Under the “Table Element,” we must select the topic we want to modify. Firstly, we have chosen “Header Row.”

Then, click on Format in excelFormat In ExcelFormatting is a useful feature in Excel that allows you to change the appearance of the data in a worksheet. Formatting can be done in a variety of ways. For example, we can use the styles and format tab on the home tab to change the font of a cell or a table.read more and give the formatting. For example, for “Font,” we have provided “yellow” color, “Font Style,” “Bold,” and  in “Underline,” “Double.”

Now, we must go to the “Fill” and select the background color.

Next, we must click on “OK” to complete. Finally, we have created a style for our “Header Row,” and we can see the preview.

Under “Table Element,” select the “First Column.”

Again click on “Format.” Then, go to “Font” and choose the color “back,” and in “Font Style,” “Bold.”

We need to go to “Fill” and select the “Background Color” as the “light red” ascent.

Click on “OK.” See the preview.

We have created our table format in Excel. Next, we must apply and see the table style in Excel. Then, under the “Design” tab, click on the drop-down list of “Table Styles.” Firstly, we may see the “Custom” table created and select that table style.

Now, we have applied our table format style in Excel.

Things to Remember

  • We need to ensure that the “My data has headers” checkbox is ticked while creating a table.While designing our table style, we need to prepare each section separately.We can play with many formulas by applying the “Total Row” option.We must always give a table a name because it is easy to find which tables are working on.

This article has been a guide to Excel Table Format and Styles. Here, we discuss creating, formatting, and changing the table style in Excel, practical examples, and downloadable Excel templates. You may also look at these useful functions in Excel: –

  • Excel Comma StyleFormatting Numbers to Millions in ExcelHow to Sort Pivot Table Data in Excel?Use AutoFormat Excel