Often you’ll have a big list that you want to filter duplicates out of. It could be because you’re copying content from a number of sources that may overlap, or you’re just rattling off a list of something as fast as you can and don’t want to go back to see if what you’re thinking of is already in the list. Either way, you’ll want a unique list of all the values. This is simple in Excel, and the tutorial below...

If you’re dealing with lists in Excel, sometimes you want to extend the column down. If you want to extend the column down to the last row you have content in with the same text: Type your text in the top cell. Double click on the bottom right hand corner of the top cell that you typed in. If you want to extend a series, ie 1,2,3,4: Type 1 into the top cell Type 2 into the cell under that. Repeat if you have a complex series. Highlight...