Is there any way to use an existing table style in Excel as the basis for a new table style? Say I’ve e.g. created a table looking like this, using one of the default tables in Excel:
However, I want the second row stripes to be light green instead of white / blank.
Is there any way to do this without recreating the formatting for the entire table?
Answer
As far as I know, you can create and apply a new custom table style based on existing build-in table styles.
You can right-click an existing table style and select Duplicate.
Modify table style as you want and click OK:
Give it a name and click OK to save it. Apply it to your tables.
Reference:Format an Excel table.
Attribution
Source : Link , Question Author : eirikdaude , Answer Author : Herb Gu _ MSFT