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: Excel - Circle Invalid Data - #shorts Sample Files - MrExcel Publishing
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
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: Excel - Circle Invalid Data - #shorts Sample Files - MrExcel Publishing
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
Transcript of the video:
How to circle invalid data in Excel. There's two ways to do this, the nerdy way.
Let's say that the rule is everything should be between 60 and 100. Come out here to data validation, and we're going to allow a whole number between 60 and 100, click okay.
Now that we have that rule set up, come back to data validation and say circle invalid data, and it'll circle the ones that don't match.
But sometimes you just need to draw a circle around someone.
Insert, shapes, choose the oval, draw the circle so it completely covers the person, and then here, shape fill, no fill. Change the color if you want.
Once you have that first circle drawn, I hold down the control key and just drag it around anyone else that I need to circle. Quick and easy.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
Let's say that the rule is everything should be between 60 and 100. Come out here to data validation, and we're going to allow a whole number between 60 and 100, click okay.
Now that we have that rule set up, come back to data validation and say circle invalid data, and it'll circle the ones that don't match.
But sometimes you just need to draw a circle around someone.
Insert, shapes, choose the oval, draw the circle so it completely covers the person, and then here, shape fill, no fill. Change the color if you want.
Once you have that first circle drawn, I hold down the control key and just drag it around anyone else that I need to circle. Quick and easy.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
