Original subtitles

In excel by default a formula references the cell relative to the formula location not the absolute

position of the cell on the cheap.

When you paste a formula to a new location it references cells relative to the new location not the

original location.

For example consider a formula in cell D nine that adds the values in the cells D4 to D D7 let us learn

how Excel interprets the formula in cell D nine which is adding values in cells D for to D 7 to add

the values in cells D Ford to D 7 it still looks up in the cells 2 3 4 and 5 rose above and in the same

column as the current cell D 9 it adds to values and displays the result in the selected cell D 9.

Note that excel is not looking for values in cells default to D7 but is interpreting the references

to these cells in terms of the location from the current set.

This is called relative referencing Excel uses relative referencing by default which makes the formula

work in the new location.

If we copy the cell D nine and paste it in Cell B nine cell B nine displays the sum of cells B for to

be seven because formula in cell D nine uses relative referencing.

Notice that the formula in B nine is referencing cells before to be seven and not cells D or 287 Excel

can also use absolute referencing in that case Excel interprets it in terms of absolute location of

the referenced cells.

Select cell E4.

Notice that the cell contains formula to display sale of Apple as a percentage of total fruit sales

which is in cell D 9 for absolute referencing.

You need to put a dollar sign before the column and the raw identifiers in the same name.

That is why in the formula you see dollar D dollar 9 to copy the formula click copy select cell e 5

click the down arrow on the best tool Excel displays the paste gallery click the second option in the

first row of the gallery to paste the copied formula in cell e 5 cell e 5 now displays the seal of Orange

as a percentage of total fruit sales the formula in e 5 is referencing cell D 9 as it should due to

the use of absolute referencing let us again copy the formula from cell e 5 to cell E6

the cell E6 contains formula to display seal of mangle as a percentage of total food sales by default

Excel copies both formula and formatting to the destination set.