How to remove duplicate values in an Excel tab

If you have a long list of data and you want to reuse it in another application.

It's handy that you can just copy the list, but what if many have the same value?

Then it is handy that you can quickly remove the duplicate value.

In this video we will look at this with a list of names and years.

The shortcuts are also briefly presented and their advantages.

​

Video chapters

​

00:00 Introduction

00:29 Create a new tab

00:56 Select and copy values with hot keys.

01:41 Using Paste Special with hotkeys ⌨️ ALT+CTRL+V

02:23 Method to adjust column width.

03:52 Why use keyboard shortcuts?

04:50 How to center a value vertically and horizontally with hotkeys? ➡️ ⌨️ALT+R+J ➡️ ⌨️ALT+R+ER

06:20 How to rid a single column selection of duplicate value

07:33 What's the difference in checking more than 1 column for duplicate values?

​

Good luck and keep practicing.

​

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.