Changing color inside a cell or range

Initially, all the cells in your worksheet are transparent (without a background color), and the color of all text and numbers you enter is black. You can change the background color and text color in a selected cell or range.

  1. Select the cell or range you want to change.

  2. In the action bar, click Lines & Colors.

  3. Click Background color and choose a background color for the selected range.

  4. Click Text color and choose a color for the selected text.

    Your changes take effect immediately.

  5. To close the pop-up panel, click Pop-up panel close button.



Keeping a selected cell or range transparent

If you have assigned a background color to a range, you can still keep a selected cell or range transparent (without a background color) within the colored area.

  1. Select the cell or range you want to keep transparent.

  2. In the action bar, click Lines & Colors.

  3. Click Transparent.

    A check mark appears in the box, and your change takes effect immediately.

  4. To close the pop-up panel, click Pop-up panel close button.



See also
Aligning data
Changing the appearance of text
Changing how range borders look
Inserting a background graphic for a worksheet