Forum Discussion
Full Dark Mode in Excel
Slightly more complex is how to set the dark template to be the default when you open either a new spreadsheet or just add a sheet.
In Excel, go to File > Options > Trust Center and click Trust Center Settings. Then select Trusted Locations on the left.
Double click the "Excel default location Excel Startup" and it will display the path so that you can copy it.
Now, the template you created for the dark theme with a single sheet on it, copy it to that folder and rename it to Book.xltx And also copy it and name it Sheet.xltx.
Now, whenever you create a new spreadsheet or even a new sheet, it will have the dark theme.
--
Adrian Parker
Don't know if it maters, but I'm running office 2019.. perhaps you're using a different version that needs different settings ?
It's worth checking your areas and filenames.. I don't know if the case of the filenames matter but I was careful to set them to Book.xltx and Sheet.xltx.. worth a check.- This step didn't work for me either (using the proper case), unfortunately. I'm using Office 365, so whatever their current release is. That said, USDA has so much extra stuff on these computers that strange conflicts sometimes happen.
But I am grateful to at least have the template that I can load, so thank you for that! - One other thing I've noticed that was annoying.. if you prefer to use the alphabetic columns instead of the R1C1 format, then you'll need to set that before saving the templates else it will always default to R1C1 format when you open excel.
AdrianParker You'll have to check all calculation settings as well, as they are also saved with the file.
The Sheet.xltx and Book.xltx names must be aligned with how your language version of Excel names a newly inserted workbook and worksheet. For Dutch Excel, the template names must be Map.xltx (or Map.xltm) and Blad.xltx respectively.
