How do i get rid of duplicate cells in excel?

Have a look at the filter function that you'll find under 'Data', 'Filter' - then select 'Advanced Filter'. There's a facility to select unique records. That should do it.

Basically you need to select all records and then filter them, selecting unique records only. Make sure you use the 'copy to another location' so you don't destroy your original data!

UP to data, sort so that your duplicates will be together, then it will be easier to delete by right clicking on row address, delete or as someone has suggested, using advanced filter and unique items. Bear in mind though doing it this way will delete the duplicates automatically so if there was any other data referring to the duplicates different to the data referring to the originals, it might do funny things to the spreadsheet as a whole.

Is it all numerical data?

Is only 1 duplicate of each row or multiple duplicates?

If multiples, in the last column, for each row, total the row;

Sort the rows into numerical order;

In the column next to the total insert a formula to show the difference between that row's total and the total of the row above it;

Add a filter to the whole row, including the "difference" column;

Show all of the rows that have a difference of zero.

Delete as appropriate.

Hope this helps.

Highlight all data, then up to Data, Sort and sort by whatever field you want, i.e. surname. All duplicates will therefore be together and you can easily delete them. However, presumably as you have so many addresses you are using Excel as a database but when you get to this size, then you really need to export to Access where you can create queries and reports etc much more easily.

What Office version you use? In Excel 2007, just go to Data -> Remove Duplication

Highlight the rows you want to delete. Right click then select delete rows.

You can also highlight the area and click on edit, then click on delte.

You can highlit the area by

clicking on the corrispoding letter to the far left

or the corrisponding nuber on top

or you can left click and drag the mouse over the area you want to delete.

just delete them