relative cell reference
You use a mixed or an absolute reference. This is done by adding dollar symbols into a cell A1 is a relative reference and will change when copied. $A1 is a mixed reference, in which the row reference changes but the column reference does not. A$1 is a mixed reference, in which the column reference changes but the row reference does not. $A$1 is an absolute reference, so neither the column or row reference changes. In most cases only a mixed reference is needed, though it is common to use an absolute reference. You lock the column reference when copying a formula across a row and you lock the row reference when you are copying a formula down a column. It is only on the very rare occasion that a formula is being copied both down and across, into a block, that an absolute reference is needed.
It doesn't matter, but after it is entered, Excel will automatically convert it to uppercase.
A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.A relative reference will change. A mixed reference may change, depending on the way it is copied. If the column is locked and the formula is copied down, then it will change. If the row is locked and you copy across, then it will change.
If a formula is copied across the column references will change, but the row references will stay the same. So for example C3 would become D3, then E3, then F3 and so on. The column letter is changing, but the row number is not.
In most cases where people use an absolute reference, a mixed reference will do. A mixed reference will lock a column or row, but not both. Most formulas are copied either down or across, but rarely both. If a cell needs to be locked in a formula, then we lock the row when copying down or lock the column when copying across. See the related question below for more details on the different kinds of cell references.
It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245It would change the column reference by one column and become:=B245
A mixed reference has only one dollar symbol. An absolute reference has two dollar symbols: $A3 is mixed. A$3 is mixed. $A$3 is absolute. A3 is relative. A mixed reference only locks the column or only the row, when copying a formula. In most instances where people use an absolute reference, a mixed reference would work. Most formulas are either copied down or across, but rarely both down and across. If you were using A3 in a formula and wanted to make it absolute, then you consider these things: If a formula is copied down, then it is only necessary to lock the row, so A$3 is sufficient. If a formula is copied across, then it is only necessary to lock the column, so $A3 is sufficient. In both cases, $A$3 would work, but depending on which direction you are copying, you would only need one of the mixed forms. As most people don't know the way mixed references can be used, they just use an absolute. It is only if a formula is being copied into a block, so both down and across, that an absolute is needed.
Autofilled.
Most formulas are copied either down or across, but rarely both directions. If a cell needs to be made permanent in the formula it is usually made absolute, locking both the row and column reference like this: $A$2. However, if a formula is being copied down, then the column reference will not change anyway, so it is not absolutely necessary to lock it, but you would need to lock the row like this A$2. If copying across, then the opposite applies, it is the column reference that needs to be locked, but not the row, like this: $A2. For most formulas it is only necessary to lock one or the other. Depending on the way data is laid out sometimes locking just one element is useful. Like you may have something in a column that needs to multiplied by different fixed values, giving a formula that might be something like this:=$A2*B$2See the related question below for general information about using different reference types.
If you want to copy a formula from one cell to another (or fill down) without Excel changing the cell references automatically, you'll need to write the cell references with dollar signs included for absolute referencing. Eg: the reference '$D3' locks the reference to column 'D' but allows the row to change when the cell is copied. Eg: the reference 'D$3' locks the reference to row '3' but allows the column to change when the cell is copied. Eg: the reference '$D$3' locks the reference to column 'D' and row '3', so the cell reference cannot change at all when the cell is copied. While you are typing in a cell reference, pressing the 'F4' key will cycle through the combinations for you, so you don't need to type the dollar signs yourself.
Normally it would be a relative address, but depending on what you want to do with the formula, you could have it as an absolute or mixed cell reference. If the cell reference is the same as the cell that the formula is in, you will have a circular reference.
Assuming you want the percentage of the total, and that the numbers are organized in a column: you first calculate the total at the bottom of a column of numbers. Then, in the next column, you put a formula that divides the number by the total. (It helps to press F4 for the total - that way, its cell reference won't change when you copy the formula down.) Then you select the range and give it a percentage format. This will automatically multiply it by 100 for display purposes; for this reason, I didn't include the "*100" in the formula.