adspace


What are absolute and relative cell references?

Answer Posted / Ravi Shekhar Rai

In Excel, a cell reference can be either absolute or relative. An absolute reference (denoted by $ before both column and row letters) remains constant when copied to other cells, while a relative reference adjusts to the cell where it is pasted. For example, if cell A1 is referred to as $A$1, it remains $A$1 regardless of where it is copied; but if referred to as A1, it changes to B1 when copied to cell B1.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why can't I see the tabs on my excel spreadsheet?

723


Image result for how do I compare two columns in excel

667


How much is excel for ipad?

713


What is left formula in excel?

683


Which is latest version of excel?

721


What is wrap text in excel?

720