How to Enable Dark Mode in Excel (The Ultimate Guide)

This video tutorial is about how to enable dark mode in Excel. You’ll see how to switch to dark mode and use the ribbon, all the bars and headers or even the whole worksheet in dark colours.

Let’s have a look then!

How to Change Excel Theme

If you’d like to enable dark mode on the ribbon, row and column headers and other interface components of Excel, first click on ‘File’ up here and then click on ‘Account’ in the bottom left-hand corner.

How to Enable Dark Mode in Excel - click on File
How to Enable Dark Mode in Excel - click on ‘Account’

Here in the field ‘Office Theme’ you can choose from multiple themes to apply to your Excel.

How to Enable Dark Mode in Excel - you can choose from multiple themes

If you’d like to enable dark mode, go for the option ‘Black’, which will show the Excel interface in dark colours.

How to Enable Dark Mode in Excel - go for the option ‘Black’
How to Enable Dark Mode in Excel - Excel interface in dark colours

You can also pick ‘Dark Gray’, which will make your Excel interface look like this.

How to Enable Dark Mode in Excel - Excel interface in dark grey

And of course, if you opt for ‘White’, the interface will appear all in white.

How to Enable Dark Mode in Excel - Excel interface in white

If you select ‘Colorful’, Excel will become more colourful.

How to Enable Dark Mode in Excel - Excel interface in colorful

Let’s now switch to black again and let me tell you two important things.

First, if you change the interface this way, the same theme will apply to all other Microsoft applications in your computer, like Word, PowerPoint and others.

Also, changing the Office theme does not mean the worksheet will appear in dark colours. If you need to change the colour of the worksheet, it’ll involve a few more clicks.

How to Enable Dark Mode in Excel - does not mean the worksheet will appear in dark colours

So, let’s have a look at a little trick on how you can change the worksheet background to black.

How to Change the Colour of the Worksheet

Click on ‘Page Layout’ up here, now go to ‘Background’.

How to Enable Dark Mode in Excel - go to ‘Background’.

You’ll see a window where you can choose a picture to load as the background. If we want a black worksheet, we need to find a plain black picture. But if you want to, you can load a photograph as the background, too.

Now we want to load just a plain black picture, so we can look it up in our computer, on our OneDrive or we can use Bing to search for it. Here, we’ll use the third option, so we click in the search field and type in ‘black’. We press Enter and here we’ve got some plain black images ready to be used!

How to Enable Dark Mode in Excel - click in the search field
plain black images

Let’s click on the first one, press ‘Insert’ and that’s done!

How to Enable Dark Mode in Excel - press Insert

The worksheet background has changed to black. Again, you can use the same way to load any image or a photograph as the background.

How to Enable Dark Mode in Excel - The worksheet background has changed to black

But there are some things to keep in mind here.

If you type anything into a cell now, you won’t be able to see it. That’s because the font colour in Excel is automatically set to black, which is now the colour of the worksheet, too. So, the text blends with the background.

How to Enable Dark Mode in Excel - type into a cell
How to Enable Dark Mode in Excel - the font colour is the same black as the worksheet

Therefore, you need to change the font colour to white.

Let’s click into the upper left-hand corner to select all the cells in the spreadsheet. Then go to the Home tab and in the section ‘Font’, change the font colour to white.

How to Enable Dark Mode in Excel - click into the upper left-hand corner
How to Enable Dark Mode in Excel - change the font colour to white

And here comes our ‘Hello’!

How to Enable Dark Mode in Excel - white font colour on the dark background

How to Change the Background Colour Back to White

If you’d like to change the background colour back to white, go to Page Layout again and click on ‘Delete Background’.

How to Enable Dark Mode in Excel - click on ‘Delete Background’

The theme can also be changed back to the default one the way we saw a while ago.

And remember to change the font colour to the automatic black, to see the text written in cells, too.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.