1. Click "Data" in the top menu of the Excel window to open the Data menu ribbon. 2. Click on "Remove Duplicates." 3. A window will pop up.

What does External Data Connections have been disabled mean in Excel? Excel often needs to fetch data from other sources to perform or execute a certain function or show the data in the spreadsheet.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.