XL: How to Create Data Validation Circles for Printing (213773)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
This article was previously published under Q213773 For a Microsoft Excel 97 version of this article, see 159493.
SUMMARY
In Microsoft Excel, you can use the Circle Invalid Data button on the
Auditing toolbar to identify cells containing values that are outside
the data validation limits. A red circle is placed around each identified
cell. These circles are not printed when you print the worksheet.
This article provides a macro that you can use to display circles around
invalid data for printing purposes.
Modification Type: | Major | Last Reviewed: | 10/7/2003 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB213773 |
---|
|