Copying Excel Formula in different ranges
Closed
Khurrum Iqbal
Posts
1
Registration date
Sunday May 19, 2013
Status
Member
Last seen
May 19, 2013
-
May 19, 2013 at 04:44 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 21, 2013 at 11:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 21, 2013 at 11:34 AM
Related:
- Copying Excel Formula in different ranges
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Mark sheet grade formula in excel download - Guide
- Formula bar in excel missing - Guide
- Screenshot in excel - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 21, 2013 at 11:34 AM
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
