There are three main cell references in Excel, viz. Relative, Absolute and Mixed. This article will help you understand what is relative cell reference in Excel.
New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.
In Excel, data is stored in a worksheet containing rows and columns and the intersection of a row and column is a cell. Rows are represented by numbers and columns by alphabets. A cell reference or cell address is a combination of the row number and column letter that identifies the cell, for e.g. A1, B2 etc. Cell references help to identify the data present in the specified cells. As shown in the figure below, A1 represents column A , row 1, and B2 represents column B, row 2.
Cell ReferenceWHAT IS RELATIVE CELL REFERENCE?
Relative cell reference is based on the relative position of the cell containing the formula and the cell/data it refers to. If the position of the cell containing the formula changes, its reference is also changed. If the formula is copied in rows or columns, the reference automatically changes. By default, all formulas use relative reference.
Let us understand relative cell reference with an example:
The spreadsheet below shows the marks of 5 students in 3 subjects. We need to calculate the total marks for each student.
To calculate the total mark for the first student, Mark, use the formula in cell E3 as
=B3+C3+D3
The following output is obtained
Since this calculation needs to be repeated for all other students, use autofill option on cell E3
Click on the formula tab in the ribbon and then on Show Formulas. You will see the following output which shows that cell references have changed acordingly:
Relative cell references are particularly useful when a calculation needs to be repeated across cells. We will learn Absolute cell reference in our next blog.
Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.
Explore more of his work on his Amazon Author Profile.
Post a Comment