Directly print data with circle invalid data in Excel

Sometimes, you apply the Circle Invalid Data function to identify the data which does not match the data validation criteria you use as below screenshot shown. However, there is no function that can print the data with validation circles in Excel. With Kutools for Excel, a professional Excel add-in, you can use its Print Circle Invalid Data utility to handle this job.

Apply this utility by clicking Kutools Plus > Printing > Print Circle Invalid Data.

1. Activate the worksheet you want to print the circle invalid data, and then click Kutools Plus > Printing > Print Circle Invalid Data.

2. A dialog pops out to remind you the data of active sheet will be copied into a new workbook for printing. Click OK to continue this operation.

3. Then you can preview the data including invalidate circles is displayed in Print Preview in a new workbook. Specify the printing settings as you need, then click Print to print the data.

After printing data, you can close the new workbook.

Note: If you need to print the circle invalid data in selection, please do as follows:

(1) Select the data with validation circle you will print, and apply this feature with clicking Kutools Plus > Printing > Print Circle Invalid Data.

(2) In the Print Preview of the new workbook, please select Print Selection from the first drop-down list in the Settings section, and then click the Print button. See screenshot:

Demo: Directly print data with circle invalid data in Excel

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

---

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages

✅ Trusted by 500,000+ users and 80,000+ businesses worldwide

🚀 Compatible with all modern Excel versions

🎁 30-day full-featured trial — no registration, no limitations

Try It Now!See PricingUnlock Full Features