Copy Functions in Microsoft Excel  Step by Step Guide ▷ 2020

Microsoft Excel is a program that belongs to the Office package and with others softwares like Word, PowerPoint and Windows use the copy and paste functions.

But nevertheless, in the particular case of a spreadsheet, the result of using the already known combinations of the control buttons C and V can throw unwanted interpretations.

And is that Excel uses functions and formulas that link to other cells, and moving them can create a wrong result. That is why we offer you this content, so that you use these functions correctly.

What should I take into consideration before copying a function to another cell in Excel?

What should I take into consideration before copying a function to another cell in Excel?

It is important that you know that a cell can contain different types of information. They may be words, numbers, addition, subtraction, other operations, links and even colors. Therefore, it is important that you first know what the content of the element you want to copy is.

In this sense, it is essential that you observe the “Formula bar” which is located under the ribbon inside the window. For example, if you put a simple operation inside a box, like “= 2 + 3” and you press “Enter”, you will notice that the number in the cell is “5”However, the addition still continues on the bar.

In this first case, nothing unwanted will happen if you copy and paste in the traditional way. However, when performing cross-checkbox operations, such as “= A1 + A2” where the first contains the value 2 and the second 3, the result will still be 5. But this time, when trying to copy and paste to another location on the sheet, in the content of it will show us an incorrect result.

This is because the program moves the operation to a new cell and not the values ​​they represent. Since it uses different locations to do it.

Steps to copy any Excel function to another cell without errors

Fortunately, Excel gives us a series of alternatives when pasting content on a spreadsheet. To find out how these options work, follow these steps:

We will take the table in the image as an example. In which, the first two columns are completed with assorted numbers:

  • In cell “C1” perform the operation “= A1 + B1”.
  • Copy this last box with “Ctrl + C” or with the right mouse button. You will notice that some dotted lines appear, this means that you have done well.

Steps to copy any Excel function to another cell without errors Traditional

  • Select cell “C2” and use the paste function with “Ctrl + V”. You will see that what has happened is that the program takes the operation and applies it to the boxes that correspond to the destination row. That is, to A2 and B2. This will happen identically with all the remaining rows.
  • For cases where you need to paste only the value of the result of the operation, you should use a “Special paste”. It can be done with the right click on the destination cell.

Steps to copy any Excel function to another cell without errors Values

  • Then choose the button “Values” under “Paste special”. This can also be done from the section “Clipboard” by pressing the triangle below “Paste”. It is important to mention that, If you vary the values ​​of cells A1 and B1, the result will not change the pasted item.

Steps to copy any Excel function to another cell without errors Link

  • If you want the result of this variation is also applied to the destination cell, the type of special bonding should be that of “Link”. The same is found in the menus we mentioned before. It is important that you know that this function also applies to boxes on other sheets of the same document.

Steps to copy any Excel function to another cell without Formatting errors

  • In the event that you want to copy the format of one cell and apply it to another, what you should use is the paste mode “Format”. Access it, in the same way as before, only this time, choose the button that appears with a brush. This will not change the value of the destination cell.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment