Скачать или смотреть Excel cell referencing RELATIVE ABSOLUTE and MIXED

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/krishnaye...
YouTube Channel:    / krishnayess  
My Blog: http://krishnasr.blogspot.in/
Google Plus: https://plus.google.com/+KrishSanj/