Saturday, January 28, 2017

Add a background color

Add a background color

If you'd like to highlight text or numbers to make the data more visible, try either changing the font color or add a background color to the cell or range of cells like this:

sample of text color and cell background fill applied

  1. Select the cell or range of cells for which you want to add a fill color.

  2. On the Home tab, click Fill Color, and pick the color you want.

    the fill button and options on the Ribbon

Note:  Pattern fill effects for background colors are not available for Excel Online. If you apply any from Excel on your desktop, it won't appear in the browser.

Remove fill color

If you decide that you don't want the fill color immediately after you added it, just click Undo.

The button to undo an action

To remove the fill color at a later time, select the cell or cell range you want to change, and click Clear > Clear Formats.

use the clear format button to remove formatting

No comments:

Post a Comment