Using Excel, you can create your own formulas, whether simple or complex, depending on your skill and knowledge. However, if a formula has been created by default, then relative cell references would be found in your formula. Thus, copying a formula to other cells will allow the cell references to adjust themselves corresponding to the original. It is also possible to create a fixed reference instead of relative reference.
Fixed references are often selected for multiplying the values in one cell by those in another cell or store the result in another cell other than the two being employed. In case you want to clear any doubt about this multiplication, there is always Excel support available for you. Read the following instructions to learn how to use fixed references in Excel in creating formulas in your spreadsheet.
- First, open your Excel spreadsheet so that you can enter the formulas that you have created.
- Choose an empty cell for building your formulas in spreadsheet.
- Whatever the type of formula you are creating, you should put an equal sign before it. For instance, =A1*B1.
This formula will multiply the values in cell A with those in cell B. Keep in mind that here we are only talking about relative reference. Making a copy of this formula and pasting it to other cells will change the cell numbers.
- Navigate to the cell where the formula is created and click it. Select the formula bar. Enter “$” either in the column letter or row number or even both as per your need. For example, multiplying all the values in cell A in the front column by the values in cell B1 requires entering “$B$1” rather than the simple “B1” in the formula that you have created. One such example is shown here: =A1*$B$1.
- Now, make a copy of your formula and paste it to other cells. For instance, multiply the values in column A by those in cell B1 and store the result in another cell, say C. Then, copy the formulas and move to all the cells in column C. Using the fixed or absolute reference, the result will be displayed in cell C1 as A1*$B$1. Similarly, the result in C2 will be displayed as A2*$B$1 and so on.
These are some of the simple instructions for using fixed references instead of relative references in Excel. For more details, ask your friends who have experience in this field, or get assistance from the Excel support and help team.Google+