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.

In the screenshot below, when the first and last initials of the names in columns A and B are typed into cells C2, C3, and C4 ...

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