Microsoft Excel Tutorial – Circle invalid data in Excel

This video shows a cool use for Data Validation: Circling Invalid Data.

Also: manually circling a cell in Excel using the drawing tools. This method creates a filled circle. This video shows you how to remove the fill so you have a circle that does not cover the data.

To download this workbook: https://www.mrexcel.com/youtube/OpVReJuDvWs/

Table of Contents
(0:00) Circle invalid data in Excel
(0:08) Define valid data in Data Validation first
(0:28) Manually drawing circles
(0:38) Making filled circle an outline
(0:46) Ctrl+Drag to copy circles in Excel
(0:52) Wrap-up

This video answers these search terms:
how do you circle invalid data in excel,
how do you circle something in excel,
how to circle on excel,
how to circle something in excel,
,how to circle something on excel,
how to make circle number excel,
how to put letters in a circle in excel,
how to type a with a circle on excel