Limit Data in an Excel List

Want to limit the choices in a cell (or column)? Data validation does that (and so much more!)
1.     Create the list in the worksheet, sort according to your use (you can hide it later, if you want)
2.     Click the cell to format
3.     Choose Data Validation
4.     From Allow: choose List
5.     From Source: choose the list location
6.     The cell now has a drop down of options based on your list
7.     If you want, copy the formatted cell down the column.

Trainer Lori channel of FREE training!

 

 

Excel 2010 - Conditional Formatting

Make duplicates automagically change color in Excel! http://ow.ly/hLb1V

Office 2010 - Customizing the QAT

Learn to customize that little toolbar with the funny name, QAT (Quick Access Toolbar) that resides at the top of your Office programs.
Office 2010 - Customizing the QAT Tutorial

Power Search on Google

Do you search on Google and get 45 million hits, but still can’t find what you’re looking for? You are not alone! Registration is now open for my newest live webinar for ASAP on Power Search: Underused Google Features!  Sign up for Power Search Webinar

Access 2010 - Linking and Importing

This is the easiest way to create an Access database. See how! http://ow.ly/hLaCV

Excel - Custom Formatting

What is the difference between # and 0 in Excel custom formatting? We show you!
http://ow.ly/hys4T

Access 2010 - Relationship Settings

Access 2010 - Relationship Settings: I know it's Valentine's Day today.  See how to fix relationships! In Access, anyway!

 Access 2010 - Relationship Settings