{"id":6185,"date":"2023-05-12T19:49:06","date_gmt":"2023-05-12T19:49:06","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=6185"},"modified":"2024-02-01T15:50:41","modified_gmt":"2024-02-01T15:50:41","slug":"how-to-set-data-validation-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-set-data-validation-in-excel\/","title":{"rendered":"How to Set Data Validation in Excel?"},"content":{"rendered":"<p>Setting Data Validation in Excel is a crucial skill that empowers you to maintain data accuracy and streamline information entry. By mastering how to set data validation in Excel, you gain control over the quality and integrity of your data. Whether it&#8217;s restricting entries to predefined options, ensuring dates fall within a specific range, or enforcing numeric limits, this feature enhances your ability to manage data effectively. Embrace the power of setting data validation in Excel to create error-free spreadsheets, improve user interaction, and make your Excel workbooks a hub of reliable information.<\/p>\n<p><strong>This Content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#what-is-data-validation?\"><strong> What is Data Validation?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-set-data-validation-in-excel?-(step-by-step-guide)\"><strong> How to set Data Validation in Excel? (Step-By-Step Guide) <\/strong><\/a><\/li>\n<li><a href=\"#different-validation-types-in-excel.\"><strong> Different Validation Types in Excel.<\/strong><\/a>\n<ul>\n<li><strong>Date Validation<\/strong><\/li>\n<li><strong>Time Validation<\/strong><\/li>\n<li><strong>Validation Based on Text Length<\/strong><\/li>\n<li><strong>Data Validation to Create Drop-Down List<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-edit-excel-validation-rules?\"><strong> How to Edit Excel Validation Rules?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-locate-cells-with-data-validation-in-excel?\"><strong> How to Locate Cells with Data Validation in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-duplicate-the-settings-for-excel-validation-to-other-cells?\"><strong> How to Duplicate the Settings for Excel Validation to Other Cells?<\/strong><\/a><\/li>\n<li><a href=\"#data-validation-removal-method.\"><strong> Data Validation Removal Method.<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"what-is-data-validation?\">1. What is Data Validation?<\/strong><\/h2>\n<p>A feature in Excel called Data Validation limits (validates) user input to a worksheet. Technically, the type of data that can be inserted into a particular cell is controlled by a validation rule that you design. In other words, allowing users to only input pre-defined values in the spreadsheet stops users from entering other sorts of data.<\/p>\n<h2><strong id=\"how-to-set-data-validation-in-excel?-(step-by-step-guide)\">2. How to set Data Validation in Excel? (Step-By-Step Guide) <\/strong><\/h2>\n<p>Follow the steps below to learn how to set data validation rules in your Excel worksheet.<\/p>\n<p><strong>Step 1: <\/strong>Select the cells that you wish to use as validated cells and go to <strong>Data&gt;&gt;Data Validation.<\/strong><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-6187\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-1.png\" alt=\"Set Data Validation\" width=\"654\" height=\"242\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-1.png 654w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-1-300x111.png 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/p>\n<p><strong>Step 2: <\/strong>The <strong>Data Validation<\/strong> dialogue box will open. Go to the <strong>Settings<\/strong> tab and set a validation rule as per your preferences. In this instance, I have chosen <strong>Whole Number<\/strong> from the <strong>Allow<\/strong> box and set a <strong>Minimum<\/strong> and <strong>Maximum<\/strong> number. If you click OK now, the data validation rules will be applied for those selected cells. The next steps are optional if you want to make the validation a bit more interesting.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-6188\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-2.png\" alt=\"Set Data Validation\" width=\"506\" height=\"412\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-2.png 506w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-2-300x244.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/p>\n<p><strong>Step 3: <\/strong>You can set an <strong>Input Message<\/strong> from this tab in the picture below. Just click on it and check the <strong>Show input message when the cell is selected<\/strong> box. Then insert a <strong>Title<\/strong> and an <strong>Input Message<\/strong> inside these boxes.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-6189\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-3.png\" alt=\"Set Data Validation\" width=\"407\" height=\"330\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-3.png 407w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-3-300x243.png 300w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/p>\n<p><strong>Step 4: <\/strong>You can also set an error alert for your validation rule and set a custom error text from this tab. Go to the <strong>Error Alert <\/strong>tab and check the <strong>Show error alert after invalid data is entered<\/strong> the box. Choose a style from the <strong>Style<\/strong> option and then insert a <strong>Title<\/strong> and an <strong>Error Message<\/strong> inside these boxes. Click OK, and your data validation rule is set.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6190\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-4.png\" alt=\"Set Data Validation\" width=\"420\" height=\"344\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-4.png 420w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-4-300x246.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p><strong>Step 5: <\/strong>Now when you click on any of the cells that are validated, this input message that you have set will pop-up.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6191\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-5.png\" alt=\"Set Data Validation\" width=\"606\" height=\"335\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-5.png 606w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-5-300x166.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/p>\n<p><strong>Step 6: <\/strong>If you insert anything that is not a number or outside the range of 1-100, this error text prompt will show in your worksheet because we have set the validation rule as a whole number and from 1-100.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6192\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-6.png\" alt=\"Set Data Validation \" width=\"637\" height=\"303\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-6.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-6-300x143.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<h2><strong id=\"different-validation-types-in-excel.\">3. Different Validation Types in Excel.<\/strong><\/h2>\n<p>Previously we have seen how to set data validation rule in our excel worksheet, now we will see some of the validation types and how to set them.<\/p>\n<p><strong>3.1 Date Validation<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Select the cells that you want to set validation rules into and go to <strong>Data&gt;&gt;Data Validation.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6193\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-7.png\" alt=\"Set Data Validation\" width=\"639\" height=\"272\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-7.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-7-300x128.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click on the drop-down button of <strong>Allow<\/strong> box and select <strong>Date.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6194\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-8.png\" alt=\"Set Data Validation\" width=\"440\" height=\"359\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-8.png 440w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-8-300x245.png 300w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Similarly choose <strong>Between<\/strong> from<strong> Data<\/strong> category. There are plenty of other options too for your selection based on what sort of validation you want to do. Play with all of them to learn more about them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6195\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-9.png\" alt=\"Set Data Validation\" width=\"432\" height=\"350\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-9.png 432w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-9-300x243.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Set a <strong>Start date<\/strong> and End <strong>date<\/strong> and click OK. You can also set <strong>Input Message<\/strong> and <strong>Error Alert<\/strong> as you have already seen how to do that.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6196\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-10.png\" alt=\"Set Data Validation\" width=\"438\" height=\"366\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-10.png 438w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-10-300x251.png 300w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/><\/p>\n<p><strong>Step 5: <\/strong>The validation rule is set, now if you type anything outside the rule will result in an error text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6197\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-11.png\" alt=\"Set Data Validation\" width=\"638\" height=\"220\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-11.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-11-300x103.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>3.2 Time Validation<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Time validation is the same as date validation. Select the cells, open the <strong>Data Validation<\/strong> dialogue box, set the validation rule, and click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6198\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-12.png\" alt=\"Set Data Validation\" width=\"509\" height=\"415\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-12.png 509w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-12-300x245.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/p>\n<p><strong>3.3 Validation Based on Text Length<\/strong><\/p>\n<p><strong>Step 1: <\/strong>This time select <strong>Text Length<\/strong> and set the other validation rules, then click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6199\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-13.png\" alt=\"Set Data Validation\" width=\"461\" height=\"378\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-13.png 461w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-13-300x246.png 300w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/p>\n<p><strong>Step 2: <\/strong>If you exceed the limit given by the validation rule, error messages will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6200\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-14.png\" alt=\"Set Data Validation \" width=\"639\" height=\"232\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-14.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-14-300x109.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>3.4 Data Validation to create Drop-Down List<\/strong><\/p>\n<p>Suppose now we want to create a drop-down list in our excel worksheet, how do we do that? There are many ways you can create a list in excel but using the <strong>List<\/strong> option from Data Validation dialogue box is one of the quickest and easiest ones. Let\u2019s learn how to do that.<\/p>\n<p><strong>Step 1: <\/strong>Select a cell which you want to use as a drop-down list search box and open the <strong>Data Validation<\/strong> dialogue box like before. Select <strong>List<\/strong> and type the month names inside <strong>Source<\/strong> box. Click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6201\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-15.png\" alt=\"Set Data Validation \" width=\"432\" height=\"354\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-15.png 432w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-15-300x246.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Now when you select that cell you will notice a drop-down button. Click on it to see the complete drop-down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6202\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-16.png\" alt=\"Set Data Validation\" width=\"460\" height=\"360\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-16.png 460w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-16-300x235.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/p>\n<h2><strong id=\"how-to-edit-excel-validation-rules?\">4. How to Edit Excel Validation Rules?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>To edit or make changes to the previously made data validation rule, simply click on any of the cells that are validated and open the <strong>Data Validation<\/strong> dialogue box. Then make the necessary changes and before you click OK, make sure to check <strong>Apply these changes to all other cells with the same settings<\/strong> box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6203 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-17.png\" alt=\"Set Data Validation in Excel\" width=\"629\" height=\"511\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-17.png 629w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-17-300x244.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<h2><strong id=\"how-to-locate-cells-with-data-validation-in-excel?\">5. How to Locate Cells with Data Validation in Excel?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Go to <strong>Home&gt;&gt;Find &amp; Select<\/strong> and select <strong>Data Validation<\/strong> from the drop-down list. This will select and highlight all the cells with data validation applied to them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6204 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-18.png\" alt=\"Set Data Validation in Excel\" width=\"500\" height=\"520\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-18.png 500w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-18-288x300.png 288w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n<h2><strong id=\"how-to-duplicate-the-settings-for-excel-validation-to-other-cells?\">6. How to Duplicate the Settings for Excel Validation to Other Cells?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Select a cell that has a data validation rule applied to it and copy it using <strong>CTRL+C<\/strong> shortcut. Then select the cell\/cells in which you want to paste the validation rule and press <strong>CTRL+ALT+V<\/strong> shortcut to open the <strong>Paste Special<\/strong> dialogue box. Select the <strong>Validation<\/strong> option and click OK. The data validation rule will be pasted in those selected cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6205 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-19.png\" alt=\"Set Data Validation in Excel\" width=\"486\" height=\"355\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-19.png 486w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-19-300x219.png 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/p>\n<h2><strong id=\"data-validation-removal-method.\">7. Data Validation Removal Method.<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Select the cells with data validation and open the Data Validation dialogue box. Then click on <strong>Clear All<\/strong> option and press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6206\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-20.png\" alt=\"Set Data Validation\" width=\"481\" height=\"391\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-20.png 481w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Set-Data-Validation-20-300x244.png 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><\/p>\n<h2><strong>Application of Set Data Validation in Excel<\/strong><\/h2>\n<ol>\n<li><strong>Data Accuracy<\/strong>:\n<ul>\n<li>Ensure data accuracy by limiting input to specific values or ranges, preventing errors.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Drop-Down Menus<\/strong>:\n<ul>\n<li>Create user-friendly forms with drop-down menus, allowing users to select from predefined options.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Date Validation<\/strong>:\n<ul>\n<li>Validate dates to ensure they fall within a certain range or adhere to a specific format.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Numeric Limits<\/strong>:\n<ul>\n<li>Control numeric data entry by setting minimum and maximum values or step increments.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Text Length<\/strong>:\n<ul>\n<li>Restrict the length of text entries to meet specific criteria, such as character limits.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Custom Messages<\/strong>:\n<ul>\n<li>Provide custom error messages to guide users when invalid data is entered.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Setting data validation rules in Excel not only improves data quality but also enhances user experience and simplifies data entry tasks.<\/p>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Setting Data Validation in Excel is a crucial skill that empowers you to maintain data accuracy and streamline information entry. By mastering how to set data validation in Excel, you gain control over the quality and integrity of your data. Whether it&#8217;s restricting entries to predefined options, ensuring dates fall within a specific range, or &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-set-data-validation-in-excel\/\"> <span class=\"screen-reader-text\">How to Set Data Validation in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[720],"tags":[721],"class_list":["post-6185","post","type-post","status-publish","format-standard","hentry","category-data-validation-in-excel","tag-data-validation-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=6185"}],"version-history":[{"count":5,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6185\/revisions"}],"predecessor-version":[{"id":8354,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6185\/revisions\/8354"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=6185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=6185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=6185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}