How to enable dark mode for cells
To make the cells in your spreadsheet dark, you need to set the background to a dark color.
First, you need to prepare a solid black background image to be inserted into your spreadsheet. You can create an image or download one 😊
Once your dark background image is ready…
- Go to Page Layout.
- Click Background from the Page Set up group.
Now, you’re going to insert a dark-colored picture for your spreadsheet to have a dark background.
- In the Insert Pictures dialog box, you have three (3) options.
- Insert Picture from a file
- Insert Picture through Search Image Bing.
- Insert Picture from your Personal OneDrive
Given that we already have a picture to use, let’s insert a picture from a file.
The Sheet Background dialog box will appear.
- Locate the background image in your computer then select.
- Click Insert.
All the cells’ color is now solid black. The dark background of the spreadsheet matches the dark interface of Excel 👍
You can of course change the background color to other dark themes like solid gray, depending on your preference 😀
It’s important to note that when you enter data into Excel, it is written and seen in the default black text color. Now that the entire spreadsheet is black, any data you enter in the cells will not be readable.
So, you might need to change the text color. To change the text color,
- Press Ctrl + A to select the entire spreadsheet.
- Click the Home Tab.
- Click the Font color dropdown in the Font group.
- Choose White as the font color.
Now, whenever you type your data into your cells, it will be readable against the dark background color👀
You have fully enabled Excel dark mode. Mostly everything in Excel is now in a dark color palette as you like 😀
If the background or text color isn’t exactly what you’re looking for, you can try again and find the right dark color palette that you want.