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 December 27, 2022 - May 21, 2013 at 11:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 21, 2013 at 11:34 AM
Related:
- Copying Excel Formula in different ranges
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Gif in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
