The fastest way to color a cell background in Excel

Open your spreadsheet and click the cell or range of cells you want to color. On the Home tab in the ribbon at the top, look for the paint bucket icon labeled "Fill Color" — it sits next to the font color button. Click the small arrow next to it to open the color palette, then click the color you want. The background of your selected cells changes when ready.

If you want to color multiple cells that are not next to each other, hold Ctrl (or Cmd on Mac) and click each cell or range one at a time. Then explore the fill color once — it will explore to all your selections at once.

To remove a background color, select the cells, click the Fill Color arrow, and choose "No Color" at the top of the palette.

Key Takeaways

  • The Fill Color button is on the Home tab in the ribbon, shown as a paint bucket icon with a dropdown arrow.
  • You can color single cells, ranges, or multiple non-adjacent selections all at once by holding Ctrl while clicking.
  • Excel offers a standard color palette, a theme color set that matches your workbook design, and a custom color picker for exact shades.
  • Background color does not affect the data itself — it is purely visual and will print if you print the spreadsheet.
  • You can undo a color change by pressing Ctrl+Z when ready, or by selecting the cells and choosing No Color.

Where to find the Fill Color button

The Fill Color tool lives on the Home tab of the ribbon. If your ribbon is collapsed or hidden, press Ctrl+F1 to show it. Look for the icon that looks like a paint bucket pouring paint into a square. The small downward arrow next to it opens the color menu.

If you are using Excel on the web (the browser version), the Fill Color button is in the same location on the Home tab. The process works identically — click the arrow, pick a color, and it applies to your selection.

Choosing from standard colors versus custom colors

When you click the Fill Color arrow, you see several color options. The top row shows "Recent Colors" — shades you have used before in this workbook. Below that is the standard palette of 10 colors. The "Theme Colors" section shows colors that match your workbook's design theme, so they will look coordinated with other formatting in your file.

If none of these colors match what you need, click "More Colors" at the bottom of the menu. A dialog box opens where you can pick from a much larger palette or enter the exact RGB or hex code for a custom shade. This is useful if you are matching your spreadsheet to a company color or a specific design.

Coloring entire rows or columns

To color a whole row, click the row number on the left side of the spreadsheet. The entire row highlights in blue, showing it is selected. Then click the Fill Color arrow and choose your color. The same method works for columns — click the column letter at the top.

If you want to color multiple rows or columns that are next to each other, click the first row or column number, then hold Shift and click the last one. All rows or columns between them will be selected. Then explore the fill color once.

Using conditional formatting for automatic background colors

If you want cells to change color automatically based on their content — for example, turning red when a number drops below a certain value — use conditional formatting instead of manual fill color. Select your cells, then go to Home tab and click "Conditional Formatting." Choose a rule type, such as "Highlight Cell Rules" or "Color Scales," and set your conditions.

Conditional formatting is more powerful than manual coloring because it updates on its own. If you manually color a cell and then change the data in it, the color stays the same. With conditional formatting, the color changes to match your rule. This is especially useful for tracking inventory, sales targets, or any data that changes regularly.

Printing and saving colored cells

Background colors print by default when you print your spreadsheet. If you want to print without the background colors, go to File > Print, then look for "Print Options" or "Page Setup." Some versions of Excel have a checkbox for "Print Background Colors" — uncheck it if you do not want colors to print.

Background colors are saved with your file automatically. When you save and reopen the spreadsheet, all your colored cells will be exactly as you left them. The color information is stored in the file itself, so it travels with your spreadsheet whether you email it, share it on OneDrive, or move it to another computer.

Troubleshooting background color problems

If you click Fill Color and nothing happens, make sure you have actually selected a cell or range. Click a cell first, then try the Fill Color button again. If the button is grayed out, you may be in a protected sheet — check with whoever set up the spreadsheet, as they may have locked certain cells from editing.

If your color looks different on screen than it does when printed, this is usually a printer setting. Printers sometimes reduce color intensity to save ink. Check your printer settings before printing, or test print a small section first. If you are sharing the file with others and colors look different on their screen, this is normal — monitor settings vary, and colors may appear slightly different depending on brightness and display type.

Frequently Asked Questions

Can I color a cell background without changing the text color?

Yes. Background color and text color are separate. Use Fill Color for the background and Font Color (the "A" with a colored underline) for the text. You can change one without affecting the other.

What is the difference between fill color and cell shading?

They are the same thing. "Fill color" and "cell shading" both refer to the background color of a cell. Excel uses the term "Fill Color" in the ribbon and menus.

How do I color alternating rows automatically?

Select your data range, go to Home > Format as Table, and choose a table style. Excel applies alternating row colors based on the style you pick. You can also use conditional formatting with a formula to color every other row manually.

Will background colors transfer if I copy cells to another program?

If you copy to another Office program like Word or PowerPoint, colors usually transfer. If you copy to a non-Office program or paste as plain text, colors are lost. To keep colors, copy and paste as a picture or export as a PDF.

Can I undo a color change after I save the file?

Once you save, you cannot undo with Ctrl+Z. You will need to manually select the cells and remove or change the color. To avoid this, use Ctrl+Z when ready after coloring if you change your mind, before you save.