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.

No Responses

Leave a Reply


x

Interesting BlogPosts to read

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...