When creating a formula, you can blend relative and absolute references so the row modifications though the column won't, or vice versa. As spreadsheets grow extra elaborate, the formulation are inclined to get extra complex also. You might end up with cumbersome formulation that happen to be tricky to browse and retain, often due to duplication.