What copies a formula in excel?

Answer 1

If you need to do the same task repetitively, you copy a formula to do it. When working on a spreadsheet you commonly need to do this. You may be calculating wages for one person, and when their wage is calculated, you would copy the formulas used to do the calculations for other people. You could have a list of sales in a particular month. You may want to add all of them or get an average, and then do the same for other months. Once you have the first formula done, it can be copied to do the same for all of the other months, saving you having to do each month individually.

Answer 2

Yes, if they are relative addresses. When Excel looks at a cell address in a formula, it does not think of the cell references in themselves, but where they are in relation to the cell with the formula. This is known as relative addressing or referencing. So if a formula is in A3 and adding A1 to A2, Excel looks at that as the formula in A3 adding the two cells immediately above it. So when the formula gets copied, in its new locations it will continue to add together the values in the two cells immediately above it. That is one of the important features enabling you to do one formula which can be copied to do similar calculations on different cells.

If you want a cell reference to stay unchanged when the formula is copied then the reference needs to be made an absolute cell reference. Read the answer to the question in the related links below for more information on that.

relative cell address/relative reference
The formula adjusts itself to the same relative cell for example if your formula references a cell two above and one to the right where ever you copy the formula to it will reference a cell two above and one to the right of where it has been pasted to

Answer 3

Normally the cell reference will change, relative to where the formula has been copied to. If the formula is copied to a cell two cells below it for example, the row reference of the cells will change by two rows. The same will happen with column references. Cells can be referenced in other ways and this can change what happens. See the related question below.

Answer 4

If auto-calculation is turned on, it will calculate the formula and display the value. If the formula is composed of relative cell addresses, it will adjust the formula cell references relative to the current location.

Answer 5

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

Answer 6

You can use copy and paste. Ctrl-C to copy; for pasting, instead of the standard Ctrl-V, it's best to press Enter, unless you want to paste to several different places - but note that you can copy from a single cell and copy (with Enter) to a larger range. If you want to copy to adjacent cells, you can also drag the lower-right corner of the cell you want to copy.

Answer 7

brackets will come & a little comm-er so either one of those

Answer 8

Yes. You can either copy the entire cell contents (just copy and paste) or copy only the forumula (copy and special paste - formulas).

Answer 9

It will depend on the types of references. Relative references will change. Absolute addresses will not change. Mixed addresses may change, depending on how the formula is copied.

Answer 10

Yes. There are many ways to do so.