Working With Excel

[Barquentine]

I have a database of addresses and emails in an Excel spreadsheet. I need to filter it so that all the emails are grouped together. I could go down copying and pasting each email but there are several hundred! Is there a way to get Excel to do it for me?

[Barquentine]

Not to worry - I've sorted it (so to speak)! I noticed all the email addresses are in blue and you can sort by colour!!

[Old_Geezer]

Select/highlight all, then you can just tell it to sort the data alphanumerically on the column that holds the e-mail addresses.

[boxtops]

As O_G says - I have a data tab on Excel spreadsheets, click that then take the Sort option, you can tell it to sort by whichever column you want.

[Maydup]

As the others have said, sort by column but be sure to select the whole document before you sort. otherwise you will only have the emails in order and they will not take the rest of the data with them or relate to the names and addresses