How to create a drop-down list in Excel to manage data and prevent mistakes

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up ...

How to lock cells in Microsoft Excel, so you need a password to change or erase data

You can lock cells in Excel by heading into the program's "Protection" tab. There, you can set a password, and protect your ...
How-To Geek on MSN

Everything You Need to Know About Data Validation in Microsoft Excel

To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
Hosted on MSN

I Always Name Ranges in Excel, and You Should Too

You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever you need to. Microsoft Excel's alternative to ...