R1C1 Reference Style in Excel

The reference format that Excel uses by default is known as A1. This means that Columns are referred with the use of Letters, and Rows are referred with the use of Numbers. A Cell Reference therefore, is a combination of both the Column Letters and Row Numbers, creating a unique cell.

The other method of referring cells, is the R1C1 format. In this format both Rows and Columns are referred with the use of Numbers. In order for use to change the Reference Style in Excel, all you have to do is to continue reading.

As shown in the image below we can see the Names of the Columns and the Numbering of the Rows.

Reference Style

We have to select the File tab in order to move to Backstage View, and then from the drop down menu that appears from the left we select the command Options which is located at the bottom.

Backstage View - Options

Once the Options command is select the Excel Options dialog box appears as shown below. From this dialog box, from the left we select the category Formulas and then from the middle of the window we locate the area named Working With Formulas.

Excel Options - Working With Formulas

Right underneath the area Working With Formulas, is the command R1 C1 Reference Style. If we navigate above this command we are informed the following:

“Change The Way Excel Formulas Refer To Cells”

“Instead Of Using Letters For Columns And Numbers For Rows, This Option Enables Using Numbers For Both Rows And Columns. Cells Are Then Referred To In This Format R1 C1”

R1 C1 Reference Style

All we have to do is to activate the check box which is located at the left of the R1 C1 Reference Style and the press the OK button which is located at the bottom right corner of the Excel Options dialog box in order for the changes to take place.

R1 C1 Reference Style

That’s it! In the image below we can see how the Names of the Columns have changed into Numbers.

Reference Style

Below you can check out the video describing the feature R1 C1 Reference Style.

 

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 16, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on R1C1 Reference Style in Excel.

Comments are closed.