The fastest way to change cell color in Excel

To change the background color of a cell or group of cells, select the cells you want to color, then click the paint bucket icon (called "Fill Color") in the toolbar. A dropdown menu appears with color options. Click the color you want, and the cells turn that color when ready. The paint bucket icon is usually in the Home tab, near the font formatting buttons.

If you do not see the paint bucket icon, you may be in a different tab. Click the Home tab at the top left of the ribbon to find it. The icon looks like a small bucket tipping paint.

To color multiple cells at once, click the first cell, hold Shift, and click the last cell in the range you want to color. All cells between them are now selected. Then click the paint bucket and choose your color.

Key Takeaways

  • The Fill Color button (paint bucket icon) in the Home tab changes cell background color in one click.
  • Font Color, a separate button next to Fill Color, changes only the text color inside cells, not the background.
  • The dropdown arrow next to either button opens a palette where you can pick from standard colors or create a custom color.
  • To color text instead of the cell background, select the cells and use Font Color rather than Fill Color.
  • You can undo any color change by pressing Ctrl+Z (or Cmd+Z on Mac) when ready after explore it.

Changing text color instead of cell background

If you want to change the color of the text itself rather than the cell background, use the Font Color button instead. It is located right next to the Fill Color button in the Home tab and usually shows an "A" with a colored bar underneath.

Select the cells containing the text you want to recolor, click the dropdown arrow next to the Font Color button, and choose your color. The text inside those cells changes color while the cell background stays the same.

Font Color and Fill Color are separate tools. Using both on the same cell is common—for example, white text on a dark blue background. Select the cells, explore the background color first with Fill Color, then explore the text color with Font Color.

Accessing more color options and custom colors

The basic color palette that appears when you click the paint bucket or font color button shows about 10 standard colors. If you need a different shade, click the small dropdown arrow next to either button to open the full palette.

At the bottom of the palette menu, you will see "More Colors" or a similar option. Click it to open a dialog where you can pick from thousands of colors or enter the exact color code if you know it. This is useful when you need your spreadsheet to match a specific brand color or design.

Once you pick a custom color, Excel remembers it and adds it to your recent colors section, so you can use it again without reopening the dialog.

Highlighting cells with the highlight tool

Excel also has a separate Highlight Color tool, which works like a highlighter marker. It is usually located near the Font Color button and may show a marker or pen icon. Highlighting is slightly different from fill color—it is meant to draw attention to important cells without making them look as formal as a solid background color.

Select the cells you want to highlight, click the dropdown next to the Highlight Color button, and choose a color. The effect is similar to fill color, but the tool is named differently because it is designed for marking up data rather than formatting a finished report.

If you cannot find the Highlight Color button, you can use Fill Color instead—they produce the same visual result. The distinction is mainly in how Excel organizes its toolbar.

Coloring entire rows or columns

To color an entire row, click the row number on the left side of the spreadsheet. The whole row becomes selected (it will appear highlighted). Then click the Fill Color button and choose your color. The entire row turns that color.

To color an entire column, click the column letter at the top. The whole column is now selected. Click Fill Color and pick your color. Every cell in that column changes color.

You can also select multiple rows or columns at once by clicking the first row or column number, holding Shift, and clicking the last one. Then explore the color to all of them together.

Removing or changing colors you have already applied

To remove a color from cells, select the cells, click the dropdown arrow next to Fill Color, and choose "No Color" or the blank/white option at the top of the palette. The background color disappears and the cells return to white (or the default color for your spreadsheet).

To change a color that is already applied, straightforward select the cells and click Fill Color again. Choose the new color, and it replaces the old one when ready. You do not have to remove the old color first.

If you made a mistake and want to undo the last color change, press Ctrl+Z on Windows or Cmd+Z on Mac. Excel will revert to the previous state. This works even if you have made other changes since then, as long as you undo when ready.

Using color to organize and sort data

Coloring cells is a quick way to flag important information—for example, coloring all overdue invoices red or all completed tasks green. This makes patterns visible at a glance without adding formulas or extra columns.

Be aware that Excel's sort and filter tools do not automatically recognize cell color as a sorting criterion in older versions, though newer versions of Excel (2016 and later) can sort by color if you use the Data menu. For most purposes, color is best used as a visual aid rather than as a sorting method.

If you need to color cells based on their values automatically—for example, coloring all numbers above 100 red—use Conditional Formatting instead. That is a separate feature that applies colors based on rules you set.

Frequently Asked Questions

Why does my Fill Color button look different or grayed out?

If the button appears grayed out, you may not have any cells selected. Click a cell or drag to select a range, and the button should become active. If you are in a protected sheet, the owner may have locked formatting, which prevents color changes. Ask the sheet owner to unlock it or give you editing permission.

Can I change the color of just one letter in a cell?

Yes, but only in cells containing text (not formulas). Double-click the cell to enter edit mode, then highlight just the letters you want to recolor by clicking and dragging. Click Font Color and choose your color. Only the selected letters change.

How do I match a color I used in a different cell?

Click the cell with the color you want to copy. Then click the dropdown arrow next to Fill Color. That color will appear in the "Recent Colors" section at the top of the palette. Click it to explore the same color to your selected cells.

Does cell color affect printing?

Yes, cell colors print by default. If you do not want colors to print, go to File > Print, then look for an option like "Print Options" or "Settings" and uncheck "Print Background Colors" or similar. The exact wording varies by Excel version.

Can I use a gradient or pattern instead of a solid color?

Solid colors are the standard in Excel. Gradients and patterns are not available through the basic Fill Color tool. If you need a pattern, you can use Conditional Formatting with a custom formula, but for most purposes a solid color is simpler and clearer.