Copying Excel Formula in different ranges
Closed
Khurrum Iqbal
TrowaD
- Posts
- 1
- Registration date
- Sunday May 19, 2013
- Status
- Member
- Last seen
- May 19, 2013
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Copying Excel Formula in different ranges
- Copying excel formulas from one sheet to another ✓ - Forum - Excel
- Excel formula for copying data from another sheet - Guide
- If formula for date range in excel - Guide
- Excel formula if range contains text ✓ - Forum - Excel
- Excel formula to find blank cells in range ✓ - Forum - Programming
1 reply
TrowaD
May 21, 2013 at 11:34 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
May 21, 2013 at 11:34 AM
Hi Khurrum,
To fix a cell reference in a formula you can use $ signs to make them absolute.
So dragging down A$1 won't change the cell reference.
Best regards,
Trowa
To fix a cell reference in a formula you can use $ signs to make them absolute.
So dragging down A$1 won't change the cell reference.
Best regards,
Trowa
