Forum Discussion
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...
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
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.
- doesn't copy and paste correctly when needed when you need to use copy/paste features.
- as 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.
Then there's this lovely nugget! AdrianParker
dktrjoy is your bad request too long something to do with dark mode ?
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.
