![]() For stopping this changing, you need to add $ to the cell reference and change the relative reference to absolute reference. For example, you apply the formula is =A1+B1 in Cell C1, and it will change to F12+G12 as you copy it to the Cell H12. ![]() In default, the cell references are relative, such as A1, and if the formula you use contains relative reference, the cell references will change when you copy it from one cell to another. ![]() How to quickly add $ into Excel formulas? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |