What are Reference Styles? Excel 2010

What are reference styles?

Every Excel spreadsheet contains rows and columns. Most of the time, columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). In Excel, this is known as the A1 reference style. However, some prefer to use a different method in which columns are also identified by numbers. This is known as the R1C1 reference style.
Screenshot of Excel 2010
While the R1C1 reference style is helpful for certain situations, you'll probably want to use the A1 reference style most of the time. This tutorial will use the A1 reference style. If you're currently using the R1C1 reference style, you'll need to turn it off.

To turn off the R1C1 reference style:

    Screenshot of Excel 2010
  1. Click the File tab to access Backstage view.
  2. Click Options.
    Screenshot of Excel 2010
  3. The Excel Options dialog box will appear. Click Formulas, uncheck the box next to R1C1 reference style, then click OK. Excel will now use the A1 reference style.

Related : What are Reference Styles? Excel 2010

  • Formatting Cells Excel 2010   Introduction Spreadsheets that have not been formatted can be difficult to read. Formatted text and cells can draw attention to specific parts of the s ...
  • Printing Excel 2010 Introduction There are many choices you can make when printing an Excel workbook. You can choose what parts of a workbook to print and how the data fits on th ...
  • Outlining Data Excel 2010 Introduction If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data ...
  • Cell Basics Cell Basics Excel 2010 Introduction You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyze, and organize d ...
  • Reviewing and Sharing Workbooks Excel 2010  Introduction Let's say someone asked you to proofread a worksheet. If you had a hard copy, you might use a red pen to cross out cell data, mark misspelli ...