Excel No Color Fill: How to Remove a Cell’s Background

How-to basics · Updated November 19, 2026

To remove a cell background in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home > Fill Color ▼ in the Font group and select No Fill. This removes the cell’s fill formatting; it is different from applying a white fill, which remains a color and can hide worksheet gridlines.

What No Fill does in Excel

A fill is the background formatting applied to a cell. Choosing No Fill removes that background color or pattern from the selected cells, so the worksheet’s normal background shows through. It does not delete values, formulas, comments, or text, and it does not change the font color, borders, alignment, or number format.

When a cell has no fill, it may look white on a standard worksheet, but that appearance does not mean Excel has applied white. The distinction matters when you want gridlines to remain visible or when the workbook uses a background or another display setting. No Fill means there is no cell fill color assigned; white means an actual white fill has been assigned.

This command affects ordinary cell formatting. If a cell’s visible color comes from conditional formatting, a table style, or another feature, choosing No Fill may not make the color disappear. Identifying the source of the color is often the key to fixing a cell that seems to ignore the command.

Remove a fill from one cell or a range

For a single cell, click it. To clear several neighboring cells, drag across them or click the first cell and Shift-click the last. You can also select a range by entering its address in the Name Box to the left of the formula bar, such as B2:D12. Then use the Fill Color menu:

  1. Open the Home tab.
  2. In the Font group, click the arrow beside the paint-bucket Fill Color button. Clicking the main button applies the currently selected color instead.
  3. Choose No Fill from the menu.

To select separate cells or ranges, hold Ctrl while clicking or selecting each one on Windows, then choose No Fill once. On a Mac, hold Command while selecting separate cells. To select an entire worksheet, click the Select All button at the intersection of the row and column headings, then apply No Fill. Be cautious with whole-sheet changes: they can alter a workbook that intentionally uses colored cells as labels or input cues.

No Fill versus white fill

White fill is a specific background color. No Fill removes the background property. On a typical sheet with gridlines enabled, a white-filled cell can appear as a plain white block with no gridlines, while a cell with no fill displays the gridlines. If the gridlines are turned off, both may appear white, so appearance alone is not a reliable test.

To check, select the cell and open Home > Fill Color ▼. The menu indicates the current theme or standard color when a fill is applied; use No Fill to remove it. You can also open Format Cells with Ctrl+1 on Windows, select the Fill tab, and inspect or change the background settings. A white square selected in the palette is not the same setting as No Fill.

Gridlines are a worksheet display feature, not borders. On Windows, use View > Show > Gridlines to toggle their display. The Page Layout tab has separate gridline options for viewing and printing. A border is an explicit line around a cell and remains even after you remove its fill. If the goal is to see cell divisions, check both fill and gridline settings, and add borders only when you need defined lines in the workbook or printout.

Use Format Cells for more control

The ribbon menu is the quickest option, but Format Cells offers a second route. Select the cells, press Ctrl+1 on Windows, and open the Fill tab. Choose the option for no background color, then select OK. This dialog is useful when you are already adjusting several kinds of formatting or want to examine the fill settings closely.

Format Cells also helps distinguish a fill problem from other formatting. The Font, Border, Number, and Alignment tabs control different properties. For example, removing a fill will not remove a thick outline, bold text, or a date number format. Change only the setting you intend to change if the rest of the cell appearance should be preserved.

If your aim is to remove all direct formatting, rather than just the background, select the cells and choose Home > Clear > Clear Formats. This is broader than No Fill: it can remove font styling, borders, and number formatting as well as fills. It does not clear the cell contents, but it may remove useful presentation choices. Use it only when a full formatting reset is wanted, not as the first response to a colored background.

When No Fill does not remove the color

A color that remains after No Fill may be generated by a rule or style rather than by the cell’s ordinary fill setting. Check these likely sources before repeatedly applying the command:

  • Conditional formatting: A rule can apply a fill when a cell meets a condition, such as a value below zero or a duplicate entry. Select the affected cells and open Home > Conditional Formatting > Manage Rules. In the rules manager, inspect the rules that apply to the current selection and edit or delete the relevant rule. To remove rules from a selected range, use Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Clearing rules removes the conditional-formatting behavior for that selection, so check that the rule is not needed elsewhere.
  • Table formatting: Excel tables can show banded rows, a header color, or other style effects. Click a cell in the table and open the Table Design tab to review the selected table style and options such as Banded Rows. A style can make a cell look colored even when its direct fill is set to No Fill. Changing the table style or its options is usually more appropriate than trying to recolor individual cells. Converting a table to a range is a larger change and removes table behavior, so do not do it solely to hide one shade.
  • Worksheet display or objects: A shape placed over cells can look like a cell background, and a hidden gridline can make a white area seem filled. Click the cell and inspect its fill menu; if the object is the source, select and format or move the object instead. Also check whether gridlines are enabled in the View tab.

Conditional formatting is especially easy to misdiagnose because the displayed color can change as values change. For example, if a rule colors overdue dates, removing the ordinary fill will not prevent the rule from coloring those dates again. Editing the rule or its applied range addresses the cause rather than only the current appearance.

Choose the least disruptive fix

Before changing a large area, decide whether the color is unwanted formatting or useful information. A workbook may use yellow for cells that need user input, green for approved values, or red for exceptions. Removing those colors can make the sheet harder to interpret even if it looks cleaner.

For a one-off background, use No Fill. If a whole column or range has inconsistent styling, inspect a few sample cells first and determine whether the fill is direct formatting, conditional formatting, or a table style. If only some cells should change, select those cells rather than the entire worksheet. If a standard visual system should remain consistent, change the responsible rule or style instead of overriding cells individually.

For important workbooks, save a copy before a broad cleanup. You can also test the change on a small range and confirm that values, formulas, gridlines, and rule-based highlights still behave as intended. This is particularly useful in shared templates where colors may communicate instructions that are not obvious from the cell contents alone.

Excel on Mac and Excel for the web

In Excel for Mac, select the cells and use the Home tab’s Fill Color menu, then choose No Fill. The ribbon layout can vary slightly by release or window size, but the paint-bucket control is in the Font area. The Format Cells dialog can be opened with Command+1 on many Mac keyboards; if that shortcut is intercepted by macOS or differs on your setup, open the cell-formatting dialog from Excel’s menus or ribbon.

Excel for the web also provides a fill-color menu on the Home tab, with a no-fill choice for selected cells. Some advanced formatting controls and dialog layouts differ from the Windows desktop app. If a color is caused by a complex conditional-formatting rule or table style and the web interface does not expose the setting you need, open the workbook in the desktop app and inspect the relevant rule or style there.

Shortcuts that open a formatting dialog are not the same as a shortcut that applies No Fill. On Windows, Ctrl+1 opens Format Cells; it does not itself remove a fill. Use the menu option or the Fill tab in the dialog to make that change. This avoids accidentally applying the last-used fill color by clicking the main paint-bucket button.

Common mistakes to avoid

  • Clicking the paint bucket instead of its arrow: The main button applies the currently displayed color. Open the menu arrow to choose No Fill.
  • Choosing white when you mean transparent: White is still a fill and may conceal gridlines. Choose No Fill for an unfilled cell.
  • Using Clear Formats for a fill-only issue: That command can remove number formats, fonts, and borders too. Use it only when a broader reset is intended.
  • Ignoring conditional formatting: A rule may reapply a color based on a value. Edit or clear the rule if the rule is the source.
  • Assuming a border is a fill: No Fill removes the background, not border lines. Adjust the Border settings separately if needed.

One useful diagnostic is to select the colored cell and inspect the Fill Color menu. If No Fill is already the active state but the cell still appears shaded, investigate conditional formatting, a table style, or an overlaid object before changing other formatting.

Frequently Asked Questions

How do I remove fill color from multiple cells in Excel?
Select the range, open Home > Fill Color ▼, and choose No Fill. For separate ranges, select them while holding Ctrl on Windows or Command on Mac, then choose No Fill.

Why is Excel still showing color after I choose No Fill?
The visible color may come from conditional formatting or a table style rather than a regular cell fill. Check Home > Conditional Formatting > Manage Rules, and inspect the table’s style on the Table Design tab if the cell belongs to a table.

Does No Fill delete the contents of a cell?
No. It changes the cell’s background formatting only. The value, formula, and other formatting—such as font, border, or number format—remain unless you change them separately.

What is the difference between No Fill and white?
No Fill removes the cell background color. White applies an actual white background. With gridlines enabled, a white fill can hide the gridlines while No Fill allows them to show.

How do I remove all formatting instead of just the fill?
Select the cells and choose Home > Clear > Clear Formats. This removes more than the background, including formatting such as fonts, borders, and number formats, so use it only when that broader reset is intended.

Related

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.