How To Use Relative & Absolute Cell References In MS-Excel | Step-By-Step Tutorial | Neeraj Arora




About this tutorial:

Video duration: 00:05:37
#ExcelforBeginners #excelbyneerajarora #msexcel

Hi Guys! In this excel tutorial, we will discuss what is Relative reference & Absolute reference in MS-Excel.

There are two types of cell references in Excel one is relative reference and other absolute reference. Relative and absolute references behave differently when copied and filled to other cells.

Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.

By default, all cell references are relative references in MS-Excel. Relative…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads