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.

How to Change Background from Black to White in Excel: 3 Methods

1. Change the 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.

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

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

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.

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.

❻ With the White option selected in the Office Theme drop-down hit the OK button in the 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.

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.

❺ 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.

❼ 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.

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.

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.

<< Go Back to Excel Background | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!