Here, we have selected Header Row, Total Row, Banded Rows, and Banded Columns. We have selected the table style from the ‘dark’ category highlighted in the below image. Now, let us explore the above options and see the changes after applying these features to your table. First & Last Column: Used to apply special formatting for the first and last column of the table.Banded Rows & Banded Columns: It is used to display the alternative shading to rows or columns or both together.Total Row: It is used to add the total rows at the end or bottom of the excel table, along with the list of functions for each total row cell.Header Row: It is used to display or hide the table headers.So let us see in brief what does the above ‘Table Style Options’ mean: These are grouped under the following categories:Īpart from the above table styles used for formatting our excel table, we also have another ‘Table Style Options’ as shown in below. Click the arrow as highlighted in the below image.Īs you can see in the below image, there are more than 55 table styles available. Let us explore the ‘systes’ option as mentioned in the below image. The below image shows how modification could be done to your table by clicking the design tab, selecting the ‘Table Styles’ option, and selecting your preferred style. In order to check different table styles, select the ‘Table Styles’ option from the ‘Design’ tab, as shown below.
The below image shows the data entered in the tabular form.Īfter creating the excel table, let us see how to apply different table styles to it. Make sure that the ‘My table has headers’ option is ticked. Step 3 – After selecting the table option or creating a table, you will get the ‘Create Table’ dialog in that dialog box, click on ‘OK.’ Step 2 – From the ‘Insert’ tab, select the option ‘Table,’ or else you can also press ‘Ctrl +T,’ which is a shortcut to create a table. Step 1 – Select the entire data in the excel sheet. Steps to create Table entered in the sheet are as follows:Ĭreating a table in Excel is easy.
You can download this Table styles Excel Template here – Table styles Excel TemplateĬonsider the below example, where any random data is entered in the excel sheet.