How to Change Background from Black to White in Excel (3 Ways)

If you have ever found yourself working in Excel with a black background and wished it were white instead, you are in luck. You can easily change the background color of an Excel spreadsheet from black to white. If you want to change your Excel background from black to white, there are a few things you need to do. In this article, I will show you 3 easy ways to change the Excel background from black to white with ease. So without having any further discussion, let’s get straight into the topic.


3 Methods to Change Background from Black to White in Excel

1. Change Black Background to White from Account Settings

To change the Excel background color from black to white from the Account setting,

❶ Go to the File tab in the ribbon.

❷ Then click on Account.

Change Excel Background from Black to White from Account Settings

❸ From the Office Theme drop-down, select White.

Change Excel Background from Black to White from Account Settings

Now you will see that the background of Excel has been changed from black to white.

Read More: How to Change Background Color Based on Value in Excel


2. Switch Background Using Excel Options Dialog Box

You can also switch the background of Excel from black to white using the Excel Options dialog box.

Now follow the steps below to do that.

❶ First, click on the File tab in the ribbon.

❷ Then click on the Options command to open the Excel Options dialog box.

Change Excel Background from Black to White Using Excel Options Dialog Box

The Excel Options dialog box will open.

❸ Then click on the General tab in the Excel Options dialog box.

❹ Now scroll down to the ‘Personalize your copy of Microsoft Office’ section.

❺ Then choose Black from the Office Theme drop-down.

Change Excel Background from Black to White Using Excel Options Dialog Box

❻ With the White option selected in the Office Theme drop-down hit the OK button in the Excel Options dialog box.

Change Excel Background from Black to White Using Excel Options Dialog Box

Finally, the dark theme will go away. The default theme of Microsoft Excel will restore itself. Thus, the background of Microsoft Excel will switch from black to white just like the picture below.

Read More: How to Change Worksheet Tab Color in Excel (5 Handy Methods)


Similar Readings


3. Using Ribbon to Change Excel Background

If your Excel sheet’s background is black like in the following picture, you can follow along with this method.

Microsoft Excel has no built-in option to toggle a sheet’s background from black to white or vice versa. You need to manually change the background of an Excel sheet from black to white.

To change the background of a sheet’s color  from black to white,

❶ Click on the triangle icon at the top-left corner of your Excel sheet.

This icon is used to select all the cells of an Excel sheet.

❷ Then go to the Home tab in the main ribbon.

❸ Now click on the Fill Color drop-down in the Font group.

❹ Now choose the White color from the Theme Colors section.

Using Ribbon to Change Excel Background from Black to White

❺ Now click on the All Borders drop-down in the Font group of the Home tab.

❻ Select the Line Color option from the Draw Borders section. Now choose the color Black from the Theme Colors section.

Using Ribbon to Change Excel Background from Black to White

❼ Now click on the All Borders drop-down again in the Font group of the Home tab.

❽ This time choose the All Borders option in the Borders section.

Using Ribbon to Change Excel Background from Black to White

Finally, the background of the Excel sheet has been changed from black to white which is the default color of an Excel sheet’s background.

Still, the borders of the Excel sheet are black. This is because the theme of Excel is set to dark. To change it to white, follow any one of the above two methods to change the Office Theme from dark to white.

Then you will see that your Excel looks like the default Excel theme color.

Read More: [Fixed!] Background Color Not Changing in Excel (6 Solutions)


Conclusion

To sum up, we have discussed 3 ways to change the Excel background from black to white. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website ExcelDemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo