27

Is there an easy way to apply a dark theme to my excel windows: black or gray background on all cells, light text.

Ideally, this would be just a theme/view that could be applied, rather than actually changing the colors in the document itself.

10

Yes there is. This can be done in both Excel 2007 & 2010. I have 2010, so to change it go to

FILE > OPTIONS > GENERAL

These options are available there;

enter image description here

| improve this answer | |
  • 8
    Hi Charlie, I am on 2007 but I found the exact same menu you describe. Unfortunately, it only changes the color scheme of the surrounding window (frame, menu, tool ribbon), not the color scheme of the cells themselves. Thus I am still looking at a white screen. The goal is something easier on the eyes, the excel equivalent of the dark themes prevalent in many popular text editors, like this one for vim: hans.fugal.net/vim/colors/desert.html – Jonah May 11 '12 at 17:56
  • Have you tried Quick Styles? You should be able to modify and save one to your liking. Apply, create, or remove a cell style. – CharlieRB May 14 '12 at 1:34
  • Looks like this isn't possible with Excel 2016 :( – Raunak Thomas Nov 7 at 14:49
17

I would do as @CharlieRB suggests and additionally set a small background image, any color, or image that works for you. You can make this a default template as well if you like. Not sure how printing will work for you, but you could set a custom view to deal with printing, if that is an issue.

Page Layout>Background enter image description here

Create and select a small image

enter image description here

enter image description here

| improve this answer | |
  • 2
    datatoo, yeah something like that would be fine. how do i set the background image as you suggest? i want to do it at the theme, rather than the document, level. thanks. – Jonah May 13 '12 at 6:48
  • Well it doesn't appear the theme level will allow that. It does seem like themes are limited in that way. But setting a default template with a small dark image for the background works. Just not the way you want I guess. Why they would allow altering of everything but the base background is beyond me. – datatoo May 13 '12 at 20:57
4

ok so i just figured out a solution, but it comes with drawbacks. you can use windows aero to change the default color of all programs which will do exactly what you're asking for, but will affect most standard programs as well. so here's what you do:

  1. right click on desktop
  2. select 'personalize'
  3. select 'window color' button
  4. select 'advanced appearance settings'
  5. in the box that opens look for a box that says 'active window'
  6. click in the white space of that box
  7. just below said box it will have a drop-down menu titled 'Color 1'
  8. select this drop-down menu and choose any color you'd like

This will change the background color of excel, word, etc. Hope this helps.

| improve this answer | |
  • This is assuming everyone using the Office suite is on Windows... – Matt Fletcher Dec 21 '17 at 18:26
2

So, this is not my answer and I found this 'workaround' from a reddit user u/towndown8. He posted this image, and I am posting the link. Hopefully, it helps people as it helped me.

https://imgur.com/nSekHZX

this is the original thread I got it from: https://www.reddit.com/r/excel/comments/b9fo97/dark_mode_question_how_to_get_the_worksheet_to/

| improve this answer | |
1

Office 365 now has dark mode for Mojave OS on Mac. It just came out today for the Insiders Fast track updates. I've been looking forward to this for years.

I don't prefer the insider's updates, because I don't want to test Excel for Microsoft. Also, the updates come too often, disrupting my work flow.

Can't wait!

| improve this answer | |
0

I have managed to get my Excel, Word and Notepad to all show light gray background by default by changing the Windows Theme, which works well for me. I have windows 10 and Office 2016 and have been struggling with this for a long time. I had to create a new theme and change the Window Color to gray.

| improve this answer | |
-2

Yes, you can change the color from the theme. Go to File and click below "option" and general seetings.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.