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

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...
How to copy multiple sheets in Excel?
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Micr...