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 anyone had an idea if Microsoft is planning to release this same thing for Excel too?
Right now Excel when using the dark theme makes everything dark except the cells. Which kind of makes no sense to me. This is where your eyes are most of the time. It needs to be a proper fully dark theme.
Is there a way to get a full dark mode without manually setting the background color of the cells dark and the text white? Can a plugin be made to do that while keeping the actual cell background “empty” and the text “Automatic”? Is there already a plugin that does that?
Thanks!
Microsoft you're such a disappointment. In 2023 you cant enable dark mode with the click of a button? People have to be jumping through hoops to get this stuff done? C'mon get your act together and give people what they want. Even Google Sheets is better at this.
- This is a one-click solution https://github.com/stu0292/ExcelDarkMode
vanbang9710 This macro solution is awesome, thanks. It's more flexible than using a dark template because those who prefer light background during the day and dark at night can toggle any sheet back and forth with one-click! 🥳
Microsoft should add this as a standard feature.
vanbang9710 Thank you so much for this link. I've followed the instructions and the macro is a game changer for me. Amazing!
This was super helpful. I love the simplicity of being able to toggle on and off. I'm not a fan of a full black spreadsheet though and wondered how to replace the black in 'dark' mode with #BFBFBF or R=191,G=191,B=191. I messed around with it a bit but couldn't figure out what I was doing. I suspect it may have to do with the 'Colors' setting under 'Page Layout'.
- The easiest workaround is to use Microsoft Paint to create a full-on Black photo.
Then Insert that photo from:-
Page Layout -> Background -> select that black image.
Now change the text color from Black to white.
Happy to help!abhishekolympics I have previously used the same method of inserting a black background and changing the text to white, and it works very well. I think there is also a setting where the grid line colour can be changed as well. The problem is that, in a work environment, most people continue to use the normal spreadsheet view. Having a button, as in MS Word, to change to a black background with light coloured text, would be ideal.
The easiest way to do this is to use templates.
Firstly, you have to declare where you want personal templates to be saved.. Using file explorer, create a folder under Documents called Personal Templates, go into that folder and click the location bar so that you can copy that full path.. you'll need it in the next bit..
Now back in Excel go to File > Options > Save and paste the path value in the 'Default Personal Templates Location', and press ok.. this is where any templates you create will be stored.
Create a brand new spreadsheet so everything is completely empty and only a single sheet1.
Press CTRL-A to select all of the sheet and set the background colour, font colour, and border colour
To set the background colour, press the arrow next to the Fill Colour option and choose More Colours > Custom Tab, and set the background to #101010 which is RGB(16,16,16), and press Ok.
Ensuring all of the sheet is still selected, set the font colour to white in the usual way.
Finally set the border colour. For the border, press the arrow and choose More Borders (at the bottom of the border list). Set the Color to the bottom left of the grey cells "White, Background 1, Darker 50%", then press the Outline and Inside buttons to select all cell borders and press ok.
So now we have a dark background sheet with visible cell lines and white font.
Ensure you clear an test text before the next step..
To save it choose File - Save As and use Browse to select the folder you set in the first part for personal templates. Change the Save as Type dropdown to 'Excel Template (XLTX)', and give the file a meaningful name such as Blank Dark.xltx and press ok. Now when you do a file New, you can choose that template to start by looking in the personal tab.. once you've used it once, it will appear in the top of the screen to make it easier to select.
If you need to create multiple sheets, then simply highlight sheet1 and Copy, insert a new sheet and then Paste, the new sheet will then be dark too. If you regularly use multiple sheets, you can always add a 2nd sheet and save it as another template "Blank Dark 2Sheet.xltx" for example.
Hope this helps someone.. As a developer, I do everything I can to avoid looking at white screens all day.
--
Adrian Parker
JulienTheriault The easiest workaround I can think of, is to open Excel files in the web browser, while using a dark mode extension.
I'm using Chrome with a dark mode extension called "Dark Reader". I use Office365 or Google Sheets to view Excel sheets in the browser, & I automatically have them viewed in dark mode.
I'm also using this method to view PDFs in dark mode, as I couldn't find an app that views PDFs in dark mode natively.
- The only way I know how to get this is by turning on High contrast in Windows. I expect that is not what you want to do 🙂
- I have the same interest as JulienTheriault, having recently lost part of my vision I found that activating the Windows “dark mode” has been helpful in continuing my work as an engineer. Like wise I am perplexed why the dark mode is not applied to worksheets in Excel. The band-aid fix of using contrast themes is not useful. Using contrast themes reduces the worksheet to two colors, obliterating any highlighted (color filled) cells, colored text and colored boarders. I have found that using an inverted color filter to be more useful, colored text and cells are still visible. Unfortunately, if you have set Windows to “Dark Mode” inverting the colors will bleach out the ribbons, tabs and commands above the worksheet and you will need to toggle back-and-forth to access commands and the worksheet. But this is just a better band-aid, the worksheet not changing to a full dark mode is the problem that needs to be addressed. Repeating JulienTheriault questions:
Is there a way to get a full dark mode?
Is there already a plugin that does that?
Can a plugin be made?
Window settings referenced:
Dark mode:
Settings > Personalization > Colors, choose your mode, Dark (a key board short cut is not available)
Contrast Themes:
Settings > Accessibility > Contrast Themes
Keyboard shortcut: left Alt + Left Shift + Print Screen to toggle between the previously sleeted theme and “none”.
Note: contrast theme’s are different than “Themes” that are a submenu of “Personalization”
Inverted Color Filter:
Settings > Accessibility > Color Filters >
The inverted filter has worked best for me
Keyboard shortcut: Window Logo Key + Ctrl + C (The Keyboard shortcut needs to be turned ON in the settings menu) - That is in fact not what I want to do. I don't want to have to switch the High contrast option on & off all the time just to get a black worksheet. I want it to work like Word does, show the page black and text white but in reality it's a white page with black text.
- Thank you, I know. That's why I want this option on Excel too! It is not there currently on Excel.
- You can vote for the suggestions other people have already posted in this area here:
https://feedbackportal.microsoft.com/feedback/search/c23f3b77-f01b-ec11-b6e7-0022481f8472?q=dark
Voting these up increases the chance Excel is updated to get a true dark mode!
I'd like to knwo how to get the DARK THEME turned off
Some how it appeared when I launched excel other day and now I cant get back to the regular WHITE background even when I change theme or theme colors
I NEVER requested a change at all, why am I being force to see the dark background that is VERY annoying and hard to read for me- Apparently some CRAZY programmer thought it would be cool to AUTOMATICALLY CHANGE a setting for you to show off a new theme
But the popup is slightly delayed and I started typing as soon as excel opened and accepted the new theme with out even knowing I did
Ridiculous that ANY SETTING should automatically be changed -- give me a popup telling me about the NEW setting BUT
** DO ** NOT ** AUTO ** CHANGE ** ANY ** SETTING **Excel doesn't have a dark theme. Have a look at this page, perhaps you can solve the issue with the pointers there https://jkp-ads.com/articles/startupproblems.asp
- Select the top left corner of the spreedsheet (all cells)
- Home section:
- select fill color black
- select text color white
- Enjoy
JulienTheriault I found a solution! Using Libre Calc solves this issue. Sorry MS has failed you.
