Delete a Row (MDS Add-in for Excel)
In the Master Data Services Add-in for Excel, delete a row of data (a member) from the MDS repository when you no longer want it to be available to users.
Administrators can reactivate deleted members. For more information, see Reactivate a Member or Collection (Master Data Services).
To delete a MDS-managed row of data
Select the entire row you want to delete by clicking the row heading.
In the Publish and Validate group, click Delete.
On the confirmation dialog box, click Yes.