How to Copy Paste in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Copy Paste in Excel



In this tutorial, you will learn how to copy paste in excel. How to copy and paste in excel is important to understand. This importance is especially reflected if you want to finish your data processing fast in a spreadsheet file.


Why do We Need to Learn How to Copy and Paste Cells in Excel?


In the data processing process on a spreadsheet, especially when the processing has gone complex, often we need a duplication process. The need for this process becomes important since usually data processing is repeated. The processing need for one entry most probably is the same as other entries. When this is the situation, then surely we need to know how to copy paste in excel. This can ensure that we become much more productive in our data processing. The impact is we can finish our works much faster compared to when we cannot do the duplication process.

As an example of this process need at work, imagine we process data for daily transaction records for a shop branch. In the daily data processing, probably we need to sum the number of products sold and the sales value. If the daily transaction data entries are hundreds or even thousands in amount, then imagine if we process each entry individually. It will take a very long time and it will be troublesome. This problem is something that we can easily avoid.

The avoidance possibility is because we have the way of how to copy paste in excel. Having the understanding on how to use it will make your work much easier in a spreadsheet file. If you often use this software, then make it your priority to understand how to do this process.


What is How to Copy Paste in Excel?


How to copy paste in excel is a function to duplicate the content of cells to other cells. This can be done by several methods available in this software.


How to Copy and Paste Data in Excel?


The following will explain how to copy paste in excel using three methods. The last method will enable you to determine what are the aspects that you want to duplicate from the cells’ content. This might be needed if you only want to duplicate some parts of your cells’ content.


Method 1 - Drag

  1. Select all the cells which content you want to duplicate

    How to Copy Paste in Excel - Screenshot of Step 1-1

  2. Move your pointer to the most right bottom position of your cell selection. Move it until the pointer changes its symbol to become a plus sign ( + )
  3. Click and do a drag until the tip of the cell range where you want to put the result
  4. Let go of your drag
  5. Done!

    How to Copy Paste in Excel - Screenshot of Step 1-5




Method 2 - Shortcut Buttons

  1. Select all the cells which content you want to duplicate

    How to Copy Paste in Excel - Screenshot of Step 2-1

  2. Right-click and select Copy/click the Copy button in the Home Tab/press Ctrl + C (Command + C on Mac) simultaneously

    How to Copy Paste in Excel - Screenshot of Step 2-2

  3. Select the most top left part of the cell range where you want to put the result

    How to Copy Paste in Excel - Screenshot of Step 2-3

  4. Right-click and select Paste/click the Paste button in the Home Tab/press Ctrl + V (Command + V on Mac) simultaneously

    How to Copy Paste in Excel - Screenshot of Step 2-4

  5. Done!

    How to Copy Paste in Excel - Screenshot of Step 2-5




Method 3 - Paste Special

  1. Select all the cells which content you want to duplicate

    How to Copy Paste in Excel - Screenshot of Step 3-1

  2. Right-click and select Copy/click the Copy button in the Home Tab/press Ctrl + C (Command + C on Mac) simultaneously

    How to Copy Paste in Excel - Screenshot of Step 3-2

  3. Select the most top left part of the cell range where you want to put the result

    How to Copy Paste in Excel - Screenshot of Step 3-3

  4. Click the dropdown symbol on the Paste in the Home Tab button and choose Paste Special

    How to Copy Paste in Excel - Screenshot of Step 3-4

  5. Manage the setting as you prefer it

    How to Copy Paste in Excel - Screenshot of Step 3-5

  6. Click OK

    How to Copy Paste in Excel - Screenshot of Step 3-6

  7. Done!

    How to Copy Paste in Excel - Screenshot of Step 3-7



Exercise


After you have learned how to copy paste in excel from above, now is the time you do an exercise. This exercise is done so you can deepen your understanding of the methods.

Download the exercise file and do the instruction.

Link of the exercise file:
Download here

Instruction:

Try to duplicate the data on the left to the empty cells on the right. Do it by considering the following details:
  • In the number 1 data, duplicate by using the drag method
  • In the number 2 data, duplicate by using the shortcut buttons method
  • In the number 3 data, duplicate the value only from the formula



Additional Note


If you want to duplicate a formula writing and want the coordinates inside to not move, there is a way. You need to understand the function of the F4 button. Please learn this function if you haven’t understood it in another Compute Expert’s tutorial!



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert