Change Excel from a Dark Theme to the Colorful Theme
Question details
The user wants to replace Excel’s gray or charcoal interface with the traditional Colorful Office 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.
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.
Select the Colorful Office theme in Excel for Windows
Use Excel Options to change the Office interface from a dark theme to Colorful.
In Excel, select File > Options, then choose General if it is not already selected.
Under Personalize your copy of Microsoft Office, open the Office Theme list and select Colorful.
Click OK to apply the theme.

Change Excel’s appearance on a Mac
Check Excel’s General preferences for a Colorful theme or an option to turn off Dark Mode.
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.

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.




