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 the "Data Validation" icon if you're using a wide screen, or the left half ...
MUO on MSN

This Excel feature helps me make better decisions (and avoid regrets)

You’ll find three of them — Goal Seek, Scenario Manager, and Data Tables — under the Data tab, within the Forecast group, labeled What-If Analysis. Each one offers a way to visualize potential ...

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 freeze a row in Excel so it always stays on the screen, even when you scroll away

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...