You are currently viewing How to duplicate entries in excel

How to duplicate entries in excel

Excel uses worksheets to organize its data or information. Four types of data excel deals with texts, dates, values, and formulas. When we talk of entries in excel, we refer to the data entry. in this article, we will look at methods of doing this.

The three methods or options include; the use of keyboard shortcuts, the right-click menu, and the use of buttons on the ribbon. Normally anyone can duplicate any entry by the use of copy and paste.

Copy-paste method

This is the easiest way to duplicate entries in excel. Open your worksheet in excel with your data or key in any information in your cells. Select one or as many cells as you need; on the ribbon, tap on the copy button and move to the location you need your data entry to be, and click on the paste button on the ribbon.

Once you have copied the data, your data is copied to the clipboard, and you can duplicate it as many times as you need. All you have to do is click on the paste button on the ribbon, and you will get another copy of your data. Apart from the ribbon tab, you can also use the keyboard shortcuts that are CONTROL +C to copy and CONTROL +V to paste. Alternatively, on copy-paste, you can use your mouse, right-click on it and click on copy and paste.

How to duplicate entries in a cell range

A duplicate option in excel, e.g., excel 2016, allows excel users to duplicate data in a certain range of cells. Follow the following steps to achieve the duplication.

1. Select a range of cells you need to be duplicated

2. In the Home tab ribbon, click on styles and tap on the conditional formatting button. Next, click on highlight cell rules and then tap on duplicate values. A dialogue box appears with options of formatting the identical values in the cell range.

3. Tap on the custom format option and pick the custom formatting in the cells dialog box that appears.

4. Click on OK to close the duplicate values dialogue box. Your entry data is officially formatted after you have followed the steps mentioned above.


It is fundamental to note that some duplicate entries are here by mistake while others are there intentionally because they help when data analysis is done or needed. As discussed above, the easiest way to duplicate entries in excel is through the copy and paste method either by the use of a mouse, keyboard shortcuts or via the Home tab ribbon.

Duplicate entries can be good and harmful to your data most of the time. In managing your data, duplicate entries make it hard for you to understand your information or data. You should also know that duplicate entry give room for errors and entertain results that are exaggerated. The process of getting rid of such is very easy.