Excel Custom Styles available to all workbooks, new or existing

Hi RustyCT1 

unfortunately, it's a bit complicated...  😉 

First of all, whatever Workbooks you store in the XLSTART directory in your users directory will be opened when you launch Excel:

C:\Users\(username)\AppData\Roaming\Microsoft\Excel\XLSTART

If you just want a "customized" workbook with your own cell styles, you create these formats in a blank workbook and store it as a template (*.xltx) in XLSTART. The name must be Book.xltx (not Book1.xltx, so you are right with your assumption).

And whatever you have stored in that template (cell styles, fonts etc.) will be available the new blank workbook, when

- you launch Excel

- you create a new workbook using Ctrl+N

- you create a new workbook by clicking the "New File" icon in the "Quick Access Toolbar", if you use that:

The new styles are NOT available, if you create a new workbook using the menu "File | New | Blank workbook":

This seems to be a different template an I have no idea if this "Blank workbook" in the file menu can also be changed somewhere.

In any case, the adjusted cell style will be available only in new workbooks, but not in existing ones And I'm not aware of a method to make them available to already existing workbooks (but of course I'm willing to be convinced of the opposite 🙂 .