![]() ![]() The cell references can change when you copy the formula to another cell as Excel looks at the cell address relative to the location of the formula. If you have B2 selected, then B3 can be described as the cell one row down. In our example, we want to reference cell E14 on the Menu Order worksheet. A relative reference allows you to describe a cell in terms of where it is relative to the current cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |