Ctrl – Drag = Copy anything

image

Another simple but extremely useful action. Press Ctrl key and drag the item to copy it. Works in File Explorer, Desktop icons, Paragraphs, SmartArt, Charts, Pivots, Shapes, Pictures, Videos, Visio Shapes, selected cells, and so on across Office and Windows.

Exception: For PowerPoint thumbnail view (left side of Normal slide view), drag first and then press CTRL key.

Remove Duplicate Rows Instantly

Just one button to press. Data – Remove Duplicates.

Data should be a table (or like a table – column headings with data below). If it is a table choose Table Tools – Remove Duplicates.
By default, duplication is checked for ENTIRE ROW.
Remove checkboxes to check for duplicates for specific fields only.

image

Be careful. Duplicate rows are DELETED.

This is unlike Advanced Filter – Unique Rows only – where duplicates are HIDDEN.

For large data – Power Query – Remove Duplicates is infinitely more powerful and faster. We will cover it in a separate article.

***