If you want to remove a unit, you can do so from the Unit of Measure window. The window shows units from either the standard database or estimate, based on where you are working when you open it. The deleted unit no longer appears in the list, but remains in existing records and estimates.
To delete a unit:
There are unit fields in the spreadsheet and the Phase, Item, Assembly, WBS Value, Formula, and Variable windows.