突出显示单元格

注意:  我们希望能够尽快以你的语言为你提供最新的帮助内容。 本页面是自动翻译的,可能包含语法错误或不准确之处。我们的目的是使此内容能对你有所帮助。可以在本页面底部告诉我们此信息是否对你有帮助吗? 请在此处查看本文的 英文版本 以便参考。

Unlike other Office programs, such as Word, Excel does not provide a button that you can use to highlight all data or portions of data in a cell. However, you can mimic highlighting by filling the cell or cells with color alone or with a highlighting format that consists of a color and/or a pattern. You can also quickly copy the color or highlighting format to other cells.

If you want to make specific data or portions of data in a cell or a range of cells stand out, you can show that data in a different font color or format.

执行下列任一操作:

Fill cells with color

  1. Select the cells that you want to highlight.

  2. On the Home tab, in the Font group, click Fill Color.

    注意: To change the color of the fill, click the arrow next to Fill Color, and then click the color that you want.

Create a custom fill

  1. On the Home tab, in the Styles group, click Cell Styles, and then click New Cell Style.

  2. 在“样式名称”框中,键入新样式的名称。

  3. 单击“格式”。

  4. On the Fill tab, select the color, pattern, and style that you want, and then click OK.

  5. Click OK to close the New Cell Style dialog box.

  6. On the sheet, select the cells or range of cells that you want to highlight.

  7. 在“开始”选项卡上的“样式”组中,单击“单元格样式”。

  8. Under Custom, click the new style that you created.

Apply an existing color or highlighting format to other cells

  1. Select a cell that is formatted with the color or highlighting format that you want to use.

  2. On the Home tab, double-click “格式”按钮 , and then select the cells that you want to highlight.

  3. When you're done, click “格式”按钮 again.

Show data in a different font color or format

  1. Select the data that you want to show in a different color or format.

    注意: To select all the data in a cell, click the cell. To select part of the data, double-click the cell, and then select the data that you want.

  2. On the Home tab, in the Font group, do one or more of the following:

    若要

    执行此操作

    Apply the most recently selected text color

    Click Font Color.

    更改文本颜色

    Click the arrow next to Font Color, and then click the color that you want to use.

    Apply a color other than the available theme colors and standard colors

    Click the arrow next to Font Color, click More Colors, and then use tools in the Colors dialog box to define the color that you want to use.

    Change the format

    Click Bold, Italic, or Underline.

Fill cells with color

  1. Select the cells that you want to highlight.

  2. On the Home tab, under Font, click Fill Color.

    注意: To change the color of the fill, click the arrow next to Fill Color, and then click the color that you want.

Create a custom fill

  1. On the Home tab, under Format, click Styles.

  2. 单击“新建单元格样式”

  3. In the Style Name box, type a name for the new style.

  4. 单击“格式”。

  5. On the Fill tab, use the pop-up menus to configure the background and foreground colors and pattern that you want, and then click OK.

  6. Click OK to close the New Style dialog box.

  7. On the sheet, select the cells or range of cells that you want to highlight.

  8. On the Home tab, under Format, click Styles.

  9. Under Custom, click the new style that you created.

Apply an existing color or highlighting format to other cells

  1. Select a cell that is formatted with the color or highlighting format that you want to use.

  2. On the Standard toolbar, double-click “格式”按钮 , and then select the cells that you want to highlight.

  3. When you're done, click “格式”按钮 again.

Show data in a different font color or format

  1. Select the data that you want to show in a different color or format.

    注意: To select all the data in a cell, click the cell. To select part of the data, double-click the cell, and then select the data that you want.

  2. On the Home tab, under Font, do one or more of the following:

    若要

    执行此操作

    Apply the most recently selected text color

    Click Font Color.

    更改文本颜色

    Click the arrow next to Font Color, and then click the color that you want to use.

    Apply a color other than the available theme colors and standard colors

    Click the arrow next to Font Color, click More Colors, and then use the slider in the Colors dialog box to define the color that you want to use.

    Change the format

    Click Bold, Italic, or Underline.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×