100 Computer Tips in 100 Days
Tip #61 - Excel Data Validation
In Excel, Data Validation refers to a feature of the
program that allows you to limit the type of information that can be entered in
a cell. You can limit it to a specific list of words, a range of numbers, only
whole or decimal numbers, dates, time, etc. You even get to define the input
message that appears when a mouse hovers over the cell as well as the error
alert message that would appear if someone enters incorrect information.


My book, 100 Amazing Computer Tips - Shortcuts, Tricks, and Advice to Help Everyone from Novice to Professional, is available NOW at Amazon.com and Barnes & Noble in both print and ebook formats. There's also a handy link on top right side of this window.
Happy computing!
Diane
Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.
No comments:
Post a Comment