A variation of this reference is to make row or column references absolute by preceding them with a dollar sign ($). ![]() If you add rows above the referenced cell or columns above the referenced cell, the cell's reference will change to reflect its new position adding a row above Cell A1 and a column to its left will change its reference to B2 in any formula the cell is referenced in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |