Forum Discussion
JulienTheriault
Aug 03, 2022Brass Contributor
Full Dark Mode in Excel
Currently you can set Office Theme to Black which acts as a dark mode. In Word, setting this to Black makes the page dark and the text white when it is set to “Automatic”. I was wondering if anyo...
AdrianParker
Jan 07, 2023Brass Contributor
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
jessicaroy
Jan 07, 2023Copper Contributor
Thanks! I also had to uncheck to "Show the Start screen..." in general settings to get the first sheet to appear properly.