75 Essential Excel tips - CBS Interactive

41. What is it called when it is necessary to keep a certain position that is not relative to the new cell location? This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). The dollar signs Lock s the cell location to a FIXED position. When it is copied and pasted it remains EXACTLY the same (not ... ................
................