Excel Worksheet Goes Black? Causes and Fixes

If an Excel worksheet goes black, first check whether Excel’s dark-mode sheet display is on; choose View > Switch Modes to change it back if that control is available. If only certain cells are black, inspect their fill color and conditional-formatting rules; if the whole Excel window is black or corrupted, investigate display drivers, add-ins, and the workbook itself.

What a black worksheet can mean

“Black worksheet” can describe several different problems, and the right fix depends on what is actually black. In Microsoft Excel for Microsoft 365 on Windows, the entire sheet may appear dark because of dark mode, while the ribbon and other Excel windows remain usable. Alternatively, a black area may be ordinary cell formatting, a conditional-formatting result, or a display-rendering fault. These situations can look similar but behave differently.

Start by noticing the scope. If every cell in the workbook looks dark, but menus and the ribbon display normally, check dark mode. If only a particular range, row, or column is black, check formatting and rules that affect that selection. If Excel’s ribbon, workbook tabs, and other interface elements are also black, flickering, or showing blocks, treat it as an application or graphics problem rather than a cell-color issue.

A black screen does not automatically mean the workbook’s data has been deleted. Formatting changes appearance, not the underlying cell values. Before changing a complicated workbook, save a copy so you can safely test fixes without losing the original layout.

Quick checks to identify the cause

Use a few simple comparisons before changing settings. Open a new blank workbook with Ctrl+N on Windows. If the new sheet is also dark, a workbook-specific fill or rule is less likely to be the cause. If the new workbook looks normal, the issue is probably tied to the affected file or its sheet settings.

Check another sheet: If one worksheet is black and the others are not, inspect that sheet’s formatting and conditional formatting.
Check another workbook: If every workbook has the same dark canvas, look at Excel’s display mode or Office theme.
Select a black cell: Look at the Fill Color and Font Color controls on the Home tab. A black fill, or black text on a black fill, can make cell contents appear missing.
Look at the window frame: A dark sheet with a normal ribbon points toward dark mode; visual corruption across the whole window points toward a rendering issue.
Check the browser or monitor: If using Excel for the web, compare it in another browser or a private window. If using a second monitor, move Excel to the laptop screen and see whether the display changes.

These checks are diagnostic, not a repair by themselves. For example, a new workbook may look normal even when the original workbook has a conditional-formatting rule that paints every cell black. That is why checking both the workbook and the Excel interface is useful.

Turn off Excel’s dark worksheet display

In supported Microsoft 365 versions of Excel for Windows, the worksheet canvas can use a dark appearance while you work. Select View > Switch Modes to switch the sheet between dark and light display. If you do not see Switch Modes, your Excel build or configuration may not include that control; use Office’s theme settings instead, or update Office if appropriate.

The Office theme controls the appearance of menus and other interface elements. To change it in Windows, open File > Account and select a lighter option from Office Theme, such as White or Colorful, if those choices are available. You can also find the Office Theme setting under File > Options > General. The exact choices can vary with the Microsoft 365 update and organization-managed settings.

Dark display is not the same as applying a black fill to every cell. A dark-mode view changes how Excel presents the sheet on screen; it does not necessarily change the workbook’s cell formatting. If a dark-looking sheet returns to white when you switch modes, the data was not erased. If the cells remain black, check their fills and rules separately.

On a Mac, Excel’s appearance can depend on macOS appearance settings and the Excel version. Check Excel’s View tab for a mode-switching control if available, and check the Mac’s appearance settings if the Office interface is following the system theme. Excel for the web has a different interface and may also be affected by browser themes or extensions, so compare in a browser without those extensions before changing the workbook.

Check cell fills, font colors, and gridlines

If only some cells are black, select one of them and inspect Home > Fill Color. A solid black fill can hide the normal gridlines and make the cell look like part of a large black area. If the fill was applied accidentally, open the Fill Color menu and choose No Fill. This removes the cell’s background fill without clearing its number format or other formatting.

Also inspect Home > Font Color. Black text on a black fill is present but unreadable. You can change the font color to Automatic or another readable color. If you need to restore a range to a plain appearance, select it and use Home > Clear > Clear Formats, but note that this removes more than fill color: it can also remove number formats, borders, and other styling. Use it only when that broader reset is intended.

Gridlines are separate from cell borders and fills. On Windows, use View > Gridlines to show or hide worksheet gridlines. A sheet with gridlines hidden can look like a uniform block, especially when the background is dark, but turning gridlines on will not remove a black cell fill. Gridlines are also not a substitute for borders when you need printed lines around selected cells.

Look for conditional formatting

Conditional formatting can apply a black fill automatically when a cell meets a rule. This is a common explanation when the black cells appear only for particular values, dates, or statuses, or when their appearance changes after editing data. The rule may also apply to a much larger range than intended, making an entire section or sheet appear black.

Select an affected cell and open Home > Conditional Formatting > Manage Rules. Review the rules and the range shown in the Applies to field. If the rule is unwanted, edit or delete that rule. To remove rules from a selected range, use Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Choose the option for the entire sheet only if you mean to remove its conditional formatting everywhere.

When a rule is necessary, inspect its formatting rather than deleting it. A rule intended to flag overdue tasks might have a black fill and dark font by mistake. Changing the rule’s format to a contrasting fill and readable font preserves the automatic behavior while making the values visible. If multiple rules apply, their order and stop-if-true behavior can affect which format appears.

When the whole Excel window looks black

If the ribbon, menus, and workbook all show black patches, flicker, or distorted graphics, changing cell formats is unlikely to help. First save if possible, close Excel, and reopen it. Then install available Office updates through File > Account > Update Options > Update Now, if that option is present. Also check Windows Update or the computer maker’s support site for a suitable graphics-driver update.

To check whether an add-in is involved, start Excel in Safe Mode on Windows. Press Windows key + R, type excel /safe, and press Enter. If the problem disappears in Safe Mode, an add-in or customization may be contributing. In normal Excel, open File > Options > Add-ins, select COM Add-ins in the Manage list, and choose Go. Disable add-ins selectively and restart Excel to identify a cause; avoid disabling workplace-required add-ins without checking with your administrator.

If the problem happens only with one workbook, make a copy before attempting repair. In Excel, choose File > Open > Browse, select the file, open the arrow beside the Open button, and choose Open and Repair if that option is available. Repair may help with file problems, but it is not a guaranteed fix and should not replace keeping an untouched backup. If the same visual corruption affects unrelated apps too, the issue may be at the display, driver, or monitor level rather than in Excel.

What changes on screen, in print, and in Excel for the web

A dark worksheet view should not be confused with a black background deliberately saved as cell formatting. The distinction matters when sharing the file: a display-mode preference may be local to the person viewing it, whereas cell fills and conditional-formatting rules are workbook formatting and can be seen by other people who open the file. If colleagues report black cells too, investigate the workbook’s formatting instead of assuming they can change your personal display preference.

Printing is another useful clue. A display-only dark mode does not mean the sheet is intended to print with a black page. However, actual black cell fills and some formatting can affect print output. Use File > Print to inspect the print preview before sending the file to a printer or creating a PDF. If the preview is black, check the affected cells’ formatting and page setup; do not assume that a dark screen will automatically print as a white sheet.

Excel for the web may look different from the Windows desktop app because it runs inside a browser. Browser dark-mode extensions, forced-color settings, or a browser display glitch can alter what you see. Compare the same workbook in the desktop app or another browser, and temporarily disable relevant extensions. If the black cells appear in both the web and desktop versions, workbook formatting is more likely than a browser-only display effect.

Prevent the problem from coming back

Once the worksheet is readable, identify the setting or rule that caused the appearance before making broad changes. If a dark display is comfortable for working, you can keep it and switch modes only when reviewing a file with custom fills. If a rule caused the problem, correct its Applies to range and format so it does not unintentionally cover unrelated cells.

Keep an original copy before repairing or resetting formatting in an important workbook.
Use No Fill to remove an unwanted background without wiping other cell formats.
Use clear font and fill contrast in shared workbooks, especially for status colors and warning cells.
Preview a printout or PDF when the workbook uses dark fills or customized page formatting.
When a display problem affects multiple workbooks, check Office updates, add-ins, and the graphics driver rather than editing each file.

Frequently Asked Questions

Why did my Excel sheet suddenly turn black?
It may be Excel’s dark worksheet display, a fill or conditional-formatting rule, or a graphics-rendering issue. Check whether a new workbook is also dark and whether the black area is limited to particular cells.

How do I change a black Excel sheet back to white?
For a dark-mode sheet, use View > Switch Modes if available. For black cells, select them and choose Home > Fill Color > No Fill, then check conditional formatting if the fill returns.

Will dark mode make my Excel worksheet print black?
A dark-mode display alone does not necessarily mean the worksheet will print with a black background. Actual cell fills can affect print output, so check File > Print preview before printing or saving as a PDF.

Why are only some cells black in Excel?
Those cells may have a black fill, unreadable font color, or a conditional-formatting rule. Inspect the Home tab’s color controls and open Home > Conditional Formatting > Manage Rules to review rules that apply to them.

What if Excel is black in every workbook?
Check the Office theme and worksheet display mode first. If the ribbon or menus are also distorted, restart Excel, check for Office and graphics-driver updates, and test whether the problem disappears when Excel starts in Safe Mode.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.