Ignore Blank Problems in Excel Data Validation

http://www.contextures.com/xlDataVal02.html With Excel data validation, you can select an item from an Excel drop down list, and see related items in the next drop down list. To do this, you set up Excel named ranges and use the INDIRECT function, to create dependent data validation lists. In some cases though, uses will be able to enter invalid data in the dependent cell, if the first cell is empty. To prevent invalid entries, you can change the Ignore Blank setting. That can cause problems later, if you use the Circle Invalid Data command. Watch this video to see the details.

Category:

Science & Technology

Tags:

• Excel
• Excel tips
• data validation
• Excel data validation
• drop down arrows
• Excel ignore blank
• ignore blank
• circle invalid data
• Excel Video tutorial
• Contextures