Relative and absolute references behave differently when copied and full of other ceases. But in online excel, it doesn't work correctly - the data from H12 always goes into the calculated cell - the reference doesn't move with the data. Press F4 again to create a mixed reference where the column is relative and the row is absolute.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |