What is absolute refrence

CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Kashish Dara 8 years, 2 months ago
- 2 answers
Naveen Sharma 8 years, 2 months ago
An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference.
Related Questions
Posted by Rishant Singhsolanki 1 year, 5 months ago
- 2 answers
Posted by Aarav Rana 1 year, 4 months ago
- 1 answers
Posted by Udai Singh 1 year, 6 months ago
- 2 answers
Posted by Siddhi Chikhalkar 1 year, 7 months ago
- 2 answers
Posted by Shahidul Islam Islam 1 year, 5 months ago
- 1 answers

myCBSEguide
Trusted by 1 Crore+ Students

Test Generator
Create papers online. It's FREE.

CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
myCBSEguide
Amar Kumar 8 years, 2 months ago
Absolute references in excel do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.
0Thank You