How to edit a drop-down list in Excel based on a cell range 1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare ...

Excel’s data validation feature is underused because many users don’t realize how versatile it is, especially where dates are concerned. Dates seem to complicate things, but only in your head ...