How to use mixed references in excel?

In the past tutorial I taught you about relative references. These are only really useful in very select occasions. The way that the reference will slide is valuable, but usually just in conjunction with an absolute reference mixed in. Hence a mixed reference. This is different in that you will put a $ in front of the reference that you do not want to move. This will help you make things like the basic multiplication tables that we are familiar with as well as multiplying entire rows by the same constraint.



Here you can see what I am talking about. This is similar to the chart from the last tutorial except for that I put a dollar sign in front of the B and in front of the 2. This has made it so that it will slide the reference down the column and across the row. This has made for the same multiplication table that we are used to from elementary school. This is valuable in financial spreadsheets because it is often that you will want to multiply one row to a column without the reference sliding both way. It is crucial that you put the dollar sign in front of the correct element or else it will make the reference slide in the wrong direction and mess up all your numbers. It is important to note that the majority of your references will be mixed. Whenever you are making tables or you are using lots of different fields of data you will be using mixed references because this is the best way to correlate lots of data without manually entering formulas for each portion.
 
Status
Not open for further replies.
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
FireFighter1215 Apps General Discussion 2
biankaa Apps General Discussion 2
A Apps General Discussion 1
N Apps General Discussion 1
Marshall Honorof Apps General Discussion 1
jbrown156 Apps General Discussion 16
C Apps General Discussion 3
J Apps General Discussion 3
viveknayyar007 Apps General Discussion 0
P Apps General Discussion 2
S Apps General Discussion 0
S Apps General Discussion 0
S Apps General Discussion 1
G Apps General Discussion 2
P Apps General Discussion 2
lilrex Apps General Discussion 3
moulderhere Apps General Discussion 2
G Apps General Discussion 1
kyeana Apps General Discussion 15
G Apps General Discussion 2

ASK THE COMMUNITY