Create a New Custom Table Style in Excel 2016

Excel 2016 lets you create your own custom styles to add to the Tables Styles gallery and use in formatting your worksheet tables. Once created, a custom Table Style not only applies just the kind of formatting you want for your worksheet tables but can also be reused on tables of data in any worksheet you create or edit in the future.
You can even designate one of the custom styles you create as the new Table Style default for your workbook so that it's automatically applied when you later format a data table in its worksheets with the Tables option on the Quick Analysis toolbar.
To create a custom Table Style, you follow these steps:

1. Format the data in your worksheet as a table using one of the existing styles.
2. On the Design contextual tab of the Tables Tool tab, click the Table Styles More drop-down button and then select the New Table Style option near the bottom of the gallery.
   The New Table Style dialog box shown in here appears.

   

   Use the options in the New Table Style dialog box to create a new custom table style to add to the Table Styles gallery.

   
   
   1. Replace the generic, table style name, Table Style 1, with a more descriptive name in the Name text box.
   2. Modify each of the individual table components in the Table Elements list box (from Whole Table through Last Total Cell) with the custom formatting you want included in your new custom table style.
      To customize the formatting for a table element, select its name in the Table Element list box. After you select the element, click the Format button to open the Format Cells dialog box where you can change that element's font style and/or color on its Font tab, the border style and/or color on its Border tab, or the fill effect and/or color on its Fill tab.
      Note that when customizing a First or Second Column or Row Stripe element (that controls the shading or banding of table's column or row), in addition to changing the fill for the banding on the Fill tab of the Format Cells dialog box, you can also increase how many columns or rows are banded by increasing the number in the Stripe Size drop-down list that appears when you select one of the Stripe elements.
      As you assign new formatting to a particular table element, Excel displays a description of the formatting change below the Element Formatting heading of New Table Style dialog box, as long as that table element remains selected in the Table Element list box. When you add a new fill color to a particular element, this color appears in the Preview area of this dialog box regardless of which component is selected in the Table Element list box.
   3. (Optional) If you want your new custom table style to become the default table style for all the data tables you format in your workbook, select the Set as Default Table Style for This Document check box.
   4. Click the OK button to save the settings for your new custom table style and close the New Table Style dialog box.