| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatically making formulas "Absolute" or "$ Relative"
If you were to type a formula in Cell A1 as follows:
=A2*A3 How do you automatically make this formula a relative formula (meaning add the $ before and after column and row so it reads $A$2*$A$3) without having to manually go into the cell and manually type the "$" sign each time? Is there a way to tell the sheet to make all formulas relative? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
| Trouble with making a 3D reference absolute | Excel Discussion (Misc queries) | |||
| stop automatically making email address | Excel Discussion (Misc queries) | |||
| how can i calculate formulas automatically | Excel Discussion (Misc queries) | |||
| Automatically 'incrementing' formulas for new rows. | New Users to Excel | |||
Threaded Mode
