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 Geek on MSN

I Use the Arrow Keys More Than Any Other Keys in Excel

Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...