Forum Discussion
JulienTheriault
Aug 03, 2022Copper 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, 2023Copper 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
JKPieterse
Jan 07, 2023Silver Contributor
AdrianParker thanks, but I would prefer a true black mode. I know we can fake it, but I don't want to change the cell formatting. I want a different display of the grid.
- JenniferZ950Jul 30, 2024Copper Contributordoesn't copy and paste correctly when needed when you need to use copy/paste features.
- AdrianParkerJan 08, 2023Copper Contributoras far as I can tell, using the template is just setting the defaults for everything, which is what they'd have to do for a 'default' dark mode, so I don't really see any difference.
- dktrjoyApr 04, 2024Copper Contributor
Then there's this lovely nugget! AdrianParker
- Adrian_ParkerApr 04, 2024Copper Contributor
dktrjoy is your bad request too long something to do with dark mode ?
- PaulW1990Feb 21, 2023Copper Contributor
AdrianParker Thanks for your solution. The issue is when opening and saving multiple shared workbooks in an institutional setting. Resaving/copying 10+ workbooks at the beginning and end of a working session (so as to no not share a dark version) is not really an option.