×
英语
很抱歉。本文没有你的语言版本。

Display or hide circles around invalid data

Data validation is designed to display messages and prevent invalid entries only when you type data directly in a cell. However, validation messages won't appear and invalid data can be entered if you enter data in a cell by copying or filling, if a formula in the cell calculates a result that isn't valid, or if a macro enters invalid data in the cell.

You may want to use the data validation tools to check your worksheets for incorrect data that may cause inaccurate calculations or results. Cells that contain invalid data appear with a red circle around them so that you can easily find and correct any problems.

red circle around invalid data

Circle invalid cells

On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Circle Invalid Data.

Data Validation menu

Excel displays a red circle around any cells that contain invalid data.

All cells that don't meet their data validation criteria are circled, including values that were typed, copied, or filled in the cells, calculated by formulas, or entered by macros.

Hide validation circles

Do one of the following:

  • To remove the circle from a single cell, enter valid data in the cell.

  • On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Clear Validation Circles.

    Data Validation menu

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

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

此信息是否有帮助?

谢谢您的反馈!

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

×