A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
The Switch Modes worksheet control is not included in the perpetual Excel Home 2024 feature set, so setting Office Theme to Black can darken the ribbon and menus but cannot add a dark worksheet canvas.
Microsoft documents the same missing-button behavior for Excel Home Edition 2024 perpetual ^1^. The published Excel 2024 feature list also does not include worksheet Dark Mode or Switch Modes ^2^.
Confirm the installed edition
In Excel, select File → Account and look under Product Information:
- If it says Office Home 2024, the missing button is expected. Updating or repairing that installation is not documented as a way to add it.
- If it says Microsoft 365, close this answer’s Office 2024 branch: that product receives continuing feature updates, unlike Office 2024, which contains a fixed subset of Microsoft 365 features and remains locked in time ^3^.
To obtain the dark worksheet canvas
Use a Microsoft 365 edition of Excel for Windows that includes the feature. In a supported build:
- Open a workbook.
- Select File → Account → Office Theme.
- Choose Black or Use system setting.
- Select View → Switch Modes.
Microsoft’s Dark Mode instructions specify those exact controls ^4^. The dark background is only a personal display preference: worksheets still print with a light page color, and collaborators retain their own view settings.
There is no need to repeat the Black-theme setting you already applied; it is a prerequisite where worksheet Dark Mode is available, but it cannot enable a control absent from Excel Home 2024.
References
- In Excel Home Edition 2024 (perpetual version), after switching to dark mode, there’s no option to change modes in the view, and the work area can’t switch to dark mode either, but Word can. - Microsoft Q&A
- What's new in Excel 2024 for Windows and Mac | Microsoft Support
- Office 2024 and Office LTSC 2024 FAQ
- Dark Mode in Excel