Data Validation - Free Excel Tutorial

This post will guide you how to prevent duplicate entries in one or multiple columns in Excel. How do I use Data Validation feature to prevent duplicate values in columns in Excel. Prevent Duplicate Values If you want to prevent duplicate values when entering data into your cells or columns in Excel, you can use… read more »

This post will guide you how to create a dynamic drop down list in Excel. How do I quickly create a dynamic drop down list in Excel. Create Dynamic Drop Down List Assuming that you want to create two drop down list in your current worksheet, and when choose a value in one drop down… read more »