Excel 2010 Using Absoloute reference
Closed
Mary
-
Jan 11, 2012 at 04:01 PM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Excel 2010 Using Absoloute reference
- Spellnumber in rupees in excel 2010 - Forum - Office Software
- Microsoft excel 2010 free download full version with product key - Download
- Convert number to spelling ✓ - Forum - Office Software
- Excel 2010/VB- Loop until no result is found - How-To - Download software
- How to take screenshot in excel 2010 - Guide
1 reply
TrowaD
Jan 19, 2012 at 10:13 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Jan 19, 2012 at 10:13 AM
Hi Mary,
The $ symbol makes it absolute, which means no change will be made when dragging a cell.
You want the row to remain the same, so put the $ symbol in front of the row number: = C$46.
Best regards,
Trowa
The $ symbol makes it absolute, which means no change will be made when dragging a cell.
You want the row to remain the same, so put the $ symbol in front of the row number: = C$46.
Best regards,
Trowa