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

  • Using What-If Analysis Excel 2010   Introduction Let's say you're trying to solve a complicated problem with Excel, like calculating an unknown value. You could try solving it on your own, ...
  • Getting Started with Excel 2010  Introduction Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your way around th ...
  • Modifying Columns, Rows, and Cells Excel 2016 Introduction By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in differen ...
  • Merging Copies of a Shared Workbook Excel 2010 Merging copies of a shared workbook Turning on the Track Changes feature automatically shares your workbook. When multiple users collaborate on the same shared wo ...
  • Creating Complex Formulas Excel 2010   Creating complex formulas Excel is a spreadsheet application that can help you calculate and analyze numerical information for household budgets, compan ...