Cell Refences

Hi Joe,
Look up Absolute and Relative references in HELP.

With the short example you gave this may be what you want, it will
fill across as you asked for, but you example does not show copying downward.

Use of Fill Handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joe" <[email protected]> wrote in message news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Lookup absolute and relative cell references in the Help files.

Also check out these links:

http://www.cpearson.com/excel/relative.htm

http://support.microsoft.com/default...b;en-us;820204

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Joe" <[email protected]> wrote in message
news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But
when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references
stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change
the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Thank you your answers were exactly what i needed.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Hi Joe-

I think that you have been directed correctly, and your final response
indicates that you have solved your problem, but I thought that maybe this
could clarify for you or anyone else who might be looking through here:

In order make a reference absolute, put a $ in front of the reference.
For example:

You want your reference in G5 copied to cell H5. You want the "C15" to
remain constant in both cells, in other words, you want to make C15 an
absolute reference. You must do this in two parts: 1) Make the column
reference absolute and 2) make the row reference absolute.

To make the column reference absolute, insert $ before the C, so that you
have displayed =$C15. To then make the row reference absolute, insert a $
before the 15, so that you have displayed =$C$15. You can mix and match
absolute and relative columns and rows, so that it is conceivable to have the
reference "=C$15" or "=$C15." But remember, unless the dollar sign is in
front of the portion of the cell address that you want to remain absolute,
Excel will automatically add/substract the distance of the copied cell to the
orginal cell to the relative cell reference, so that one row down, =$C15 will
be =$C16 or =C15 will be C16. I hope this makes sense for anyone else
looking for help in here.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Hi Joe,
Look up Absolute and Relative references in HELP.

With the short example you gave this may be what you want, it will
fill across as you asked for, but you example does not show copying downward.

Use of Fill Handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joe" <[email protected]> wrote in message news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Lookup absolute and relative cell references in the Help files.

Also check out these links:

http://www.cpearson.com/excel/relative.htm

http://support.microsoft.com/default...b;en-us;820204

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Joe" <[email protected]> wrote in message
news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But
when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references
stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change
the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Thank you your answers were exactly what i needed.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Hi Joe-

I think that you have been directed correctly, and your final response
indicates that you have solved your problem, but I thought that maybe this
could clarify for you or anyone else who might be looking through here:

In order make a reference absolute, put a $ in front of the reference.
For example:

You want your reference in G5 copied to cell H5. You want the "C15" to
remain constant in both cells, in other words, you want to make C15 an
absolute reference. You must do this in two parts: 1) Make the column
reference absolute and 2) make the row reference absolute.

To make the column reference absolute, insert $ before the C, so that you
have displayed =$C15. To then make the row reference absolute, insert a $
before the 15, so that you have displayed =$C$15. You can mix and match
absolute and relative columns and rows, so that it is conceivable to have the
reference "=C$15" or "=$C15." But remember, unless the dollar sign is in
front of the portion of the cell address that you want to remain absolute,
Excel will automatically add/substract the distance of the copied cell to the
orginal cell to the relative cell reference, so that one row down, =$C15 will
be =$C16 or =C15 will be C16. I hope this makes sense for anyone else
looking for help in here.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

I have a question?
When you are making a cell with a formula the references are set. But when
you copy the cell each cell reference changes relative to the position the
new cell is. My question is, is it possible to have to cell references stay
the same in all cells when i copy and the other cell reference change
relative to the new cell. I am wondering so that i dont have to change the 2
cell referance in all the new cells cells.
I am sorry if this question is hard to understand b/c i am having a hard
time explaning so here is an example.

Here is cell G5: =IF(C15=G14,+E15,0)
If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
But I want H5 to equal: =IF(C15=H14,+E15,0)

Can someone please help.
Thanks,
~Joe

Hi Joe,
Look up Absolute and Relative references in HELP.

With the short example you gave this may be what you want, it will
fill across as you asked for, but you example does not show copying downward.

Use of Fill Handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joe" <[email protected]> wrote in message news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Lookup absolute and relative cell references in the Help files.

Also check out these links:

http://www.cpearson.com/excel/relative.htm

http://support.microsoft.com/default...b;en-us;820204

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Joe" <[email protected]> wrote in message
news:[email protected]...
> I have a question?
> When you are making a cell with a formula the references are set. But
when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references
stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change
the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Thank you your answers were exactly what i needed.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Hi Joe-

I think that you have been directed correctly, and your final response
indicates that you have solved your problem, but I thought that maybe this
could clarify for you or anyone else who might be looking through here:

In order make a reference absolute, put a $ in front of the reference.
For example:

You want your reference in G5 copied to cell H5. You want the "C15" to
remain constant in both cells, in other words, you want to make C15 an
absolute reference. You must do this in two parts: 1) Make the column
reference absolute and 2) make the row reference absolute.

To make the column reference absolute, insert $ before the C, so that you
have displayed =$C15. To then make the row reference absolute, insert a $
before the 15, so that you have displayed =$C$15. You can mix and match
absolute and relative columns and rows, so that it is conceivable to have the
reference "=C$15" or "=$C15." But remember, unless the dollar sign is in
front of the portion of the cell address that you want to remain absolute,
Excel will automatically add/substract the distance of the copied cell to the
orginal cell to the relative cell reference, so that one row down, =$C15 will
be =$C16 or =C15 will be C16. I hope this makes sense for anyone else
looking for help in here.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe

Hi Joe-

I think that you have been directed correctly, and your final response
indicates that you have solved your problem, but I thought that maybe this
could clarify for you or anyone else who might be looking through here:

In order make a reference absolute, put a $ in front of the reference.
For example:

You want your reference in G5 copied to cell H5. You want the "C15" to
remain constant in both cells, in other words, you want to make C15 an
absolute reference. You must do this in two parts: 1) Make the column
reference absolute and 2) make the row reference absolute.

To make the column reference absolute, insert $ before the C, so that you
have displayed =$C15. To then make the row reference absolute, insert a $
before the 15, so that you have displayed =$C$15. You can mix and match
absolute and relative columns and rows, so that it is conceivable to have the
reference "=C$15" or "=$C15." But remember, unless the dollar sign is in
front of the portion of the cell address that you want to remain absolute,
Excel will automatically add/substract the distance of the copied cell to the
orginal cell to the relative cell reference, so that one row down, =$C15 will
be =$C16 or =C15 will be C16. I hope this makes sense for anyone else
looking for help in here.

"Joe" wrote:

> I have a question?
> When you are making a cell with a formula the references are set. But when
> you copy the cell each cell reference changes relative to the position the
> new cell is. My question is, is it possible to have to cell references stay
> the same in all cells when i copy and the other cell reference change
> relative to the new cell. I am wondering so that i dont have to change the 2
> cell referance in all the new cells cells.
> I am sorry if this question is hard to understand b/c i am having a hard
> time explaning so here is an example.
>
> Here is cell G5: =IF(C15=G14,+E15,0)
> If I copy to cell H5 i get this: =IF(D15=H14,+F15,0)
> But I want H5 to equal: =IF(C15=H14,+E15,0)
>
> Can someone please help.
> Thanks,
> ~Joe