How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Eg. We are creating the ...