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 create data bars in Excel to help others visualize your spreadsheet's numbers

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