71.3k views
3 votes
The cell reference D$17 is an example of a _____.

User SamehDos
by
8.5k points

1 Answer

2 votes
The cell reference D$17 is an example of an "anchored or an absolute reference." It means that the row or cell or column is anchored. When you try to copy excel formulas, it will copy the cells referred in that formula relative to the position where they are being copied to.
User Ondrej Peterka
by
7.8k points