Excel cell referencing RELATIVE ABSOLUTE and MIXED

1,068 views · Published 14 January 2016 · 7:25 · Indexed 11 October 2026

Channel: Krishna S · 2016 · Science & Technology

Watch on YouTube

If you are working with excel formula, you should know about these three types of cell references - Relative, absolute and Mixed.

In relative referencing, you referred address will  move when you drag the formula, but in case of absolute, it will not. In mixed type of referencing, you can specify either row or column to move when you drag. 

Use dollar sign to manipulate the referencing. Put a dollar sign before the column and row to make it absolute. For relative don't use it. In mixed either you put dollar sign before column reference of row reference but not both.


Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishnasr.blogspot.in/
Google Plus: https://plus.google.com/+KrishSanj/

More from this channel

• 5:15 How to get a list of files in folder in Excel

  Krishna S

  3,143 views · 30 June 2015

• 7:04 How to delete blank rows in Excel

  Krishna S

  3,455 views · 3 July 2015

• 7:38 How to create macro in Personal workbook

  Krishna S

  342 views · 16 August 2015

• 5:43 Copy of How to create your own Excel Add-in - Currency converter - number to text

  Krishna S

  113 views · 13 October 2015

• 3:03 How to format MS Excel cell comments

  Krishna S

  142 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 2

  Krishna S

  4,514 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 3

  Krishna S

  2,645 views · 20 November 2015

• 8:18 MS Excel user form

  Krishna S

  564 views · 9 April 2016