Header Banner
WonderHowTo Logo
WonderHowTo
Microsoft Office
wonderhowto.mark.png
Gadget Hacks Next Reality Food Hacks Null Byte The Secret Yumiverse Invisiverse Macgyverisms Mind Hacks Mad Science Lock Picking Driverless

How to Create a data validation list in Microsoft Excel

Data validation settings in an Excel spreadsheet.

If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.

See how to:

1)Add drop down by typing values in

2)Add drop down by selecting range on worksheet

3)Add drop down by naming range on different worksheet

4)Add a warning message

5)Check to see if data is valid

6)VLOOKUP function

7)Name a range

8)Check the list of Names

Add Data Validation Drop-Down List To Cell List on Worksheet or Different Workshee

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!