SmittyPro - Witticisms, Help, Tutorials and More

Automating Data Entry with Data Validation Lists

written by "Smitty"

Data Validation is one of Excel’s most underutilized tools from a data entry perspective, especially its ability to manage list type functions.  What is Data Validation?  Well it’s essentially a robust set of tools that allow you to define the parameters you want for certain data entry cells.  In other words, you can control what […]

Read More About - Automating Data Entry with Data Validation Lists »


Welcome to the World of Smitticisms

written by "Smitty"

A brief introduction to the Witticisms of Smitty (i.e. – Smitticisms), bringing help, instruction and inspiration to all levels of Microsoft Excel users and programmers.

Read More About - Welcome to the World of Smitticisms »

Microsoft MVP


Join In

Tag Cloud

Great Links


Welcome to, your one-stop for solutions concerning anything from beginner to extremely advanced Microsoft Excel issues and programming. Topics covered include Excel, Access, VBA, and (every now and then) some amazing observations or "Smitticisms" that might dumbfound you and send ripples of excitement or intrigue around the world.



RSS Top Stories from CNN

Vistor Counter for SmittyPro's Blog