Forum Discussion

TimmyRay0910's avatar
TimmyRay0910
Copper Contributor
Jan 22, 2023

Column reference address

Template using numeric column reference. Want to change to alphabetical in current and future worksheets. Example A1 not R1C1

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jan 22, 2023

    TimmyRay0910 

    Columns and rows are labeled numerically in Excel

    To change this behavior, follow these steps:

    1. Start Microsoft Excel.
    2. On the Tools menu, click Options.
    3. Click the Formulas tab.
    4. Under Working with formulas, click to clear the R1C1 reference style check box (upper-left corner), and then click OK.

    If you select the R1C1 reference style check box, Excel changes the reference style of both row and column headings, and cell references from the A1 style to the R1C1 style.

     

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources