Setting a custom table style as the default table style is a little tricky.
Let’s walk through the process.
First, create a new blank workbook.
As a first step, I recommend that you highlight cell A1 in yellow.
Next, copy and paste a table with the custom style applied into the new workbook.
The moment you paste the table, the custom style will be added to the workbook.
Inside the Table Styles menu, right-click and set the custom style as the default style.
Next, we need to save the workbook to a known location.
you’re free to create a similar directory anywhere you like.
Now, before you save the file, see to it you copy the full path.
you’re able to do this in the file explorer.
Then save the file.
Back in Excel, navigate to Options in the File menu.
Paste the path to your templates directory here.
Then press OK to exit the options area.
To verify the template is working, quit and relaunch Excel.
To test the default table style, I’ll paste in some data and create a table.
Sure enough, my custom style is used by default.
