Skip to main content

Directly print data with circle invalid data in Excel

Author: Sun Last Modified: 2024-12-11

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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.
shot print invalid circle 1


Apply this utility by clicking Kutools Plus > Printing > Print Circle Invalid Data.
shot print invalid circle 2

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.
shot print invalid circle 3

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.
shot print invalid circle 4

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:
shot print invalid circle 5


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
Kutools for Excel RibbonKutools for Excel Ribbon