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.

8ym3x1o.png


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.