Relative Referencing in Excel

Prev Tutorial Next Tutorial

Relative Referencing in Excel

The main benefit of relative referencing is no need to type formula separately for each calculation in a row or a column.

In below example first type formula in cell and hit enter key to get result after doing this use fill handle. Now you can see formula will auto apply on all respective cell. In below example value of List 1 will added with List 2 values.

relative referencing in excel

Using above method you can easily add List 1 data with List 2 but in case of, if you want to all all cells of List 1 with a single cell of List 2 such as B2 then it won't work.

Prev Tutorial Next Tutorial

Google Advertisements

Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain,, @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: WhatsApp no. 8882538826

Yahoo Advertisements