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 ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

If your arrow keys are not working in Excel, there are a few simple ways to troubleshoot and solve this problem.