Office Settings & Configuration

Change Excel from a Dark Theme to the Colorful Theme

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

The user wants to replace Excel’s gray or charcoal interface with the traditional Colorful Office theme.

Change Excel from a Dark Theme to the Colorful Theme
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants a more colorful Excel interface instead of a dark theme.
Observed behavior
Excel’s interface appears gray or charcoal rather than colorful.
Before you start

Open Excel and check whether you are using Windows or Mac, because the appearance settings are in different menus. Available theme options can vary by Office version.

Solution 1Recommended

Select the Colorful Office theme in Excel for Windows

Use Excel Options to change the Office interface from a dark theme to Colorful.

1
Open Excel Options

In Excel, select File > Options, then choose General if it is not already selected.

2
Choose Colorful

Under Personalize your copy of Microsoft Office, open the Office Theme list and select Colorful.

3
Apply the setting

Click OK to apply the theme.

Select the Colorful Office theme in Excel for Windows
Office-wide appearance: The Office Theme setting may also change the appearance of other Office apps.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files, although it does not change Excel’s own theme.

Use WPS Spreadsheets as an alternative spreadsheet editorOpen and edit Microsoft Excel XLS and XLSX filesNavigate a familiar interface when moving from Microsoft OfficeUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Office Theme setting in Excel for Windows?

Go to File > Options > General and find Office Theme under Personalize your copy of Microsoft Office.

Will changing the Excel theme affect other Office apps?

It may. The Office Theme setting can apply across Office apps, so Word or PowerPoint may also change appearance.

What if Colorful is not available in Excel for Mac?

Open Excel > Preferences or Settings > General and look for an option to turn off Dark Mode. If Excel follows macOS appearance, select Light under Apple menu > System Settings > Appearance.

Does changing the Office theme alter my spreadsheet data?

No. The Office Theme changes the application’s appearance, not the data stored in your workbook.