Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Enable Excel Dark Mode? 2 Easy Methods

How to Enable Excel Dark Mode? 2 Easy Methods

Note: This tutorial on Excel Dark Mode is suitable for Excel versions 2013 and later including Office 365. 

If you spend a lot of time staring at spreadsheets or at a computer screen in general, especially at night, it is advisable to turn on the dark mode.  In this tutorial, I’ll show you how to enable true dark mode in Excel in these three simple steps:

  • Method 1: Manually Set Excel Dark Mode Using a Dark Background
    • Step 1: Enable Excel Dark Mode via Office Theme
    • Step 2: Create a Dark Sheet Background in PowerPoint
    • Step 3: Add Dark Background in Excel Sheet
  • Method 2: Enable Excel Dark Mode Using VBA Code
    • Step 1: Enable the Dark Mode in the Office Theme
    • Step 2: Insert the Excel Dark Mode VBA Code
    • Step 3: Add a Quick Access Toolbar Shortcut for the Dark Mode

The dark mode is gentle on your vision, less straining and most importantly cool to use. 

Excel Dark Mode
Excel Dark Mode

Fortunately, most software designers have recognised this aspect and started including a dark theme as part of their default themes. 

Related:

How to Extract an Excel Substring? – 6 Best Methods

How to Superscript in Excel? (9 Best Methods)

How To Find Duplicates in Excel? (3 Easy Methods)

Microsoft Excel also has a built-in dark theme that you can try. But, it has one major problem. The cells are still coloured white, even if the dark mode is enabled. 

But, there is still a way to enable true dark mode in Excel. In this tutorial, I’ll take you through the steps to make it happen. 

Note: You can download a sample dark mode enabled Excel file, along with some ready-made dark background images by clicking here.

download-button-green-

Watch this short video tutorial on how to enable the dark mode in Excel

Method 1: Manually Set Excel Dark Mode Using a Dark Background

Step 1: Enable Excel Dark Mode via Office Theme

As the first step, you have to enable the in-built dark mode by changing the default office theme. 

To do this, just go to Files>Options>Office Theme and change it to Black or Dark Grey as per your requirements. You can also apply the system theme if you want. 

Change the Office Theme to Black or Dark Grey in Excel Options
Change the Office Theme to Black or Dark Grey in Excel Options

Once you do this, you’ll see that the dark theme is applied to everything inside the Excel window except the cells. At least, it’s better than nothing. 

In the default Excel Dark Mode, the cells have a light background
In the default Excel Dark Mode, the cells have a light background

Step 2: Create a Dark Sheet Background in PowerPoint

All we have to do now is create a suitable dark background for the Excel sheet. You are free to do this however you like. For example, you can do this by having a blank dark background taken from the internet or simply creating one with Photoshop. 

But, for the best results, I always recommend using Powerpoint for this. 

Open a blank presentation in Powerpoint, and go to Design>Format Background. Apply a suitable dark colour to your blank slide.

Now, I recommend you make similar slides with slightly different dark colour shades on each slide. You can totally skip this if you are sure about the exact colour you want to use 

Apply a suitable dark background to a blank slide in PowerPoint
Apply a suitable dark background to a blank slide in PowerPoint

Finally, save them as PNG images in an easy to locate folder location. 

Save the dark background slides as PNG images in an easily accessible folder
Save the dark background slides as PNG images in an easily accessible folder

Also Read:

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Autofit Excel Cells? 3 Best Methods

Step 3: Add Dark Background in Excel Sheet

Now that you have the background image ready, all you need to do now is go to Page Layout>Background in Excel and select the appropriate PNG images that you created.

Add the Dark Background Image
Add the dark background to the Excel sheet by going to Page Layout>Background. Now, locate and choose the appropriate dark background image, you just created using Powerpoint.

You can use trial and error and change the background to find out which shade of black suits you best. 

But, keep in mind that you have to change the font colour to white or any other contrasting colour for the entire sheet. 

Change the font colour to a suitable light colour after clicking Ctrl+A.
Change the font colour to a suitable light colour after clicking Ctrl+A.

Note: This added dark background only applies to that specific sheet you are working on. You have to add them separately to all sheets if needed. 

Method 2: Enable Excel Dark Mode Using VBA Code

If you find all of this a bit complicated, don’t worry. There is a much easier way to enable the dark mode in Excel, at the click of a button using a VBA code.

Let us see how to implement this using these simple steps:

Step 1: Enable the Dark Mode in the Office Theme

Repeat the same instructions provided above under the first method. That is, go to the Office Theme section under Files > Options and change it to Black or Dark Grey. This will first apply the dark mode to the Excel window and menu area.

Step 2: Insert the Excel Dark Mode VBA Code

Now that you have the basic dark mode ready, it is time to apply true dark mode in Excel. Hit Alt+F11 and open a new module in your Excel VBA editor. Now, copy and paste this dark mode VBA code inside the new module. Now, you can directly hit F5 and run this code to switch on/off true dark mode in Excel. This will automatically apply a dark background to all your cells in all your sheets in one go.

Paste the Dark Mode VBA code in the Module
Insert the Dark Mode VBA code in the Module

Step 3: Add a Quick Access Toolbar Shortcut for the Dark Mode

Manually running the VBA code every time you want to toggle ON/OFF the dark mode can be very frustrating. To avoid this, you can permanently add a Dark Mode shortcut to your Excel quick access toolbar. To do this, just go to any open Excel sheet while the VBA module window with the VBA code is still open.

Now, click on the Customize Quick Action Toolbar icon near the very top of your Excel window. In the drop-down list select More Commands.

Click on the Customize Quick Access Toolbar button
Click on the Customize Quick Access Toolbar button
Choose More Commands
Choose More Commands

Now, in the Excel Options window, click on the drop-down list below the text which says Choose Commands From and select Macros . This will display a list of all available Macros. In this list, locate and select our dark mode macro named ToggleDarkMode.

Locate ToggleDarkMode under Macros and click on the Add button to move it to the Quick Access Tool bar
Locate ToggleDarkMode under Macros and click on the Add button to move it to the Quick Access Tool bar

Now, click on the nearby Add button to add it to the Quick Access Toolbar (QAT).

That’s all folks. You are ready to experience the dark mode magic at the hit of a button.

Just click on the ToggleDarkMode button in the Quick Access Toolbar to instantly switch on/off true dark mode in Excel.

Toggle ON/OFF the Excel Dark Mode at the click of a button
Toggle ON/OFF the Excel Dark Mode at the click of a button

This is a hassle free method where you don’t have to deal with clumsy backgrounds or other color settings.

If needed, you can save this worksheet as a macro enabled Excel sheet (.xlsm) and keep using this shortcut whenever needed.

Suggested Reads:

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

FAQs

Is dark mode better for your eyes?

Using dark mode may reduce eye strain and eye drieness for people who stare at a digital screen for long hours. But, it reduces your devices' power consumption.

How do I change the office theme to dark?

To change the Office theme to dark just go to Files>Options>Office Theme and change it to Black or Dark Grey as per your requirements.

Closing Thoughts

That’s everything about how to enable Excel dark mode. Hereafter, implement this technique to all your spreadsheets. Your eyes will definitely thank you. If you have any questions regarding this or any other Excel feature please let us know in the comments. We are always happy to help. 

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Ready to dive deep into Excel? Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Import Task Lists in Microsoft Project

How to Calculate Mean in Excel? 2 Useful Ways.

How to Insert Image in Excel? 3 Easy Ways

How to Combine Two Columns in Excel? 2 Easy Methods

Getting Started with Power Pivot: Advanced Excel

Working with Page Breaks in Microsoft Word

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)