Excel drop down list ignore blank cells
Understanding the Ignore Blank checkboxThere is a checkbox on the right hand side of the Data Validation dialog box called Ignore blank. This checkbox has nothing to do with removing blanks when you are using a drop-down list. Restricting a Whole NumberTo try and illustrate how this checkbox works lets consider restricting the data to be any whole number in a particular range. Enter the CriteriaPress (Data > Validation) to display the Data Validation dialog box and select the Settings tab. Enter Some Numbers (Ignore Blank = False)Select cell "E2" and try and enter some whole numbers. Enter Some Numbers (Ignore Blank = True)Now lets repeat this but with the "Ignore blank checkbox ticked this time. Even though the Ignore blank checkbox has been ticked there is no impact on the data validation. Enter Some Numbers (C3 is blank)However if we introduce a blank cell into the validation criteria then we can get a different result. This option allows the data validation to be ignored if it encounters any blank cells in the validation criteria. © 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext |