If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when you copy a cell that has a drop-down list and press "Ctrl-V" to paste it into a new cell ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

Using just one formula, you can create an entire table, generate a filtered view, calculate a running total, or build a ...

For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of business processes. Over time, these Excel ...

If your Excel lists repeats values and you need help finding changes, try this easy conditional format. One of the most frequent requests I receive from readers is how to highlight list values when ...