How to do absolute/relative/mixed reference?

**Leanne07** · 04-14-2007, 03:57 PM

Hi All!
I'm having a really hard time with excel and the formulas. I don't know much about them..I've read around but I'm not getting anywhere. I have a few questions. This is what I need to be doing:

Write cell K5 as a relative reference, absolute reference, mixed reference with the row varying, and mixed reference with the column varying.

How do I do that??? Any help would be greatly appreciated.

**dominicb** · 04-14-2007, 06:27 PM

Good evening Leanne07

...and welcome to the forum.

All formulae are intially relative. To make them absolute add a $ sign before the row and number to make it absolute :
$A$1
To make just the row absolute ;
A$1
and to make just the column absolute :
$A1

The easiest way to insert these "$" signs, though is to just press F4 when editing a formula and Excel will cycle through all four states.

HTH

DominicB

**Beg9inner** · 04-19-2014, 07:55 AM

What to do if it does not work?

I get same values if a $b1 or $b$1. What do I do wrong?

I want to lock the row, not the colmun and it just do not work.

Best regards

**AliGW** · 04-19-2014, 07:57 AM

To lock the row, you need B$1. B is the column and 1 is the row.

**Beg9inner** · 04-19-2014, 08:01 AM

Originally Posted by AliGW

To lock the row, you need B$1. B is the column and 1 is the row.

Thank you, but it doesnt work. Please see the exceel sheet. Mixed references.xlsx

**alansidman** · 04-19-2014, 08:08 AM

@Beg9inner
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**alansidman** · 04-19-2014, 08:09 AM

@Beg9inner
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**Beg9inner** · 04-19-2014, 08:11 AM

Hi Moderator, my post is relevant to this thread.

**Richard Buttrey** · 04-19-2014, 08:30 AM

Originally Posted by Beg9inner

Hi Moderator, my post is relevant to this thread.

Hi,

Even if it is, did you read the bit about providing a link when you start your own thread. We certainly don't expect posters to upload their own files in a thread someone else has started.

Please follow Alan's request if you want specific help.