How to circle a number in Microsoft Excel 2007?

This article will explain how to circle a number in Microsoft Excel 2007 http://viagracanadausa.com/ Worksheet. or any item helps the user to mark the invalid data so that it can corrected.

How to circle a number in Microsoft Excel 2007?

Here is how you can do it,

How to circle a number in Microsoft Excel 2007?
How to circle a number in Microsoft Excel 2007?
  • Navigate to “Data” tab in menu bar and select “”.

    How to circle a number in Microsoft Excel 2007?
    How to circle a number in Microsoft Excel 2007?
     
  • In “Data validation” navigate to “Settings” tab select “Text Length” from the list.

How to circle a number in Microsoft Excel 2007?
How to circle a number in Microsoft Excel 2007?
  • When you select “Text length” in “Data” select “equal to” and in “Length” enter the value as “8”.

     

  • Navigate “Data” tab in menu bar and select “Data validation” and select “Circle invalid data”.

How to circle a number in Microsoft Excel 2007?
How to circle a number in Microsoft Excel 2007?
  • Now you must be able to view the circle on “television” as its length is more than 8.

How to circle a number in Microsoft Excel 2007?
How to circle a number in Microsoft Excel 2007?
  • To remove the circle you can follow the same steps and select “Clear Validation Circles”.
How to circle a number in Microsoft Excel 2007?
How to circle a number in Microsoft Excel 2007?
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

1 Response

Leave a Reply