HomeApplicationOffice informationInstructions on how to copy formulas in Excel

Instructions on how to copy formulas in Excel

To be able to perform calculations in Excel, we will need to use formula functions. For example, to calculate the average value will need the AVERAGE function, the sum will use the SUM function. And if you need to work with spreadsheets of different numbers, columns and lines, copying the formula from one line to another is essential. You will not need to sit down to calculate each line, but you can get the results with just a few steps. Let's see how to copy and copy formulas in Excel in the following tutorial of Network Administrator.

In the following example, I will do the AVERAGE function and the SUM function in the score statistics table. We will proceed to copy the formula in cell E2 and F2 to the cells in the columns E and F.

Instructions on how to copy formulas in Excel Picture 1

Method 1: Use Copy and Paste operation:

Step 1:

First of all, you need to highlight two cells E2 and F2 , then right- click Copy or press Ctrl + C.

Instructions on how to copy formulas in Excel Picture 2

Step 2:

Continue to blacken the area from E3 to F6 and then right-click and select Paste or use the Ctrl + V. key combination. Excel will copy the formula and format of cell E2 and F2 to the remaining cells.

Instructions on how to copy formulas in Excel Picture 3

The result will be as shown below.

Instructions on how to copy formulas in Excel Picture 4

Method 2: Use Copy and Paste Special:

This usage will be different than the way to copy the entire formula and specify. We will use the Paste Special option to choose to copy each formula and keep it as it is.

Step 1:

You can also highlight cell E2 and F2 and click Copy.

Instructions on how to copy formulas in Excel Picture 5

Step 2:

You highlight the area from E3 to F6 and right-click, select Paste Special .

Instructions on how to copy formulas in Excel Picture 6

Step 3:

Appearing on the Paste Special dialog box, select the Formulas item and click OK .

Instructions on how to copy formulas in Excel Picture 7

The result is the same as in the first way but the format in cells E2 and F2 has not been copied to the remaining cells.

Above are 2 ways to copy formulas on Excel, copy them all and copy only formulas and no formatting. Depending on the calculation requirements in the Excel table, we choose the appropriate copy of the formula.

Refer to the following articles:

  1. Summary of expensive shortcuts in Microsoft Excel
  1. These are the most basic functions in Excel that you need to understand
  1. MS Excel - Lesson 4: Working with lines, columns, sheets

I wish you all success!

5 ★ | 1 Vote
Excel functionstotal calculation in ExcelExcel shortcuts

You should read it

May be interested

  • Fix error of Copy Paste command not working in Word, Excel (2007, 2010)Photo of Fix error of Copy Paste command not working in Word, Excel (2007, 2010)
    there are many causes of the copy paste command error that do not work on windows computers, such as your computer being attacked by viruses, the clipboard does not work, and so the copy (ctrl + c) and paste commands ( ctrl + v) does not work. so how to fix this error, please refer to the following article of network administrator.
  • How to set the default font and font size on ExcelPhoto of How to set the default font and font size on Excel
    on windows operating systems, excel uses the calibri font as the default font. however, if you want to use another font or simply change the default font size, you just need to adjust some settings on excel.
  • Instructions for cutting and rotating photos on Google DocsPhoto of Instructions for cutting and rotating photos on Google Docs
    google integrates some basic image editing features into google docs. users can now use google docs to edit photos, crop photos, rotate images and add borders to images instead of using other photo editors.
  • Instructions to turn off Protected View feature in Office 2013Photo of Instructions to turn off Protected View feature in Office 2013
    protected view feature in office 2013 will help document avoid malicious code, virus attack when opening content. however, this feature will be uncomfortable for users.
  • How does the word in Microsoft Word jump?Photo of How does the word in Microsoft Word jump?
    when you enter the content in word, there is a spelling error, although we do not press enter or adjust the vietnamese typing tool on the machine. this may be due to problematic auto-spacing in word.
  • Instructions on how to fix reverse dates in ExcelPhoto of Instructions on how to fix reverse dates in Excel
    when we install the english language on microsoft excel, you will have an english date error, the previous month and then the date and year. so how can i return to the correct format of day, month and year in excel?

Office information