 | |
| Excel Hack: Copy Formula Without Changing Cell References (or Without File References) |
Would you like to copy your Excel formulas from one place to another without the cell references changing? In this video I show you a simple trick that does that.
Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell reference by using the dollar sign ($). A $ for the row number, fixes the row and a $ on the column number fixes the column.
You might however need to copy a set of formulas that have relative references from one location to another or from one file to another and keep the existing cell references. This video shows a very simple trick you can use.
Related topics:
Post a Comment