Why do my Excel formulas say “RC?!” Help!!

Ann K. Emery

Updated on: Feb 24th, 2025

Data Analysis

Formulas and Functions, Microsoft Excel, YouTube Videos

Do your formulas look weird?

Maybe they say “RC[-1]” or some other jargon.

The solution:

Go to File
Options
Formulas
Uncheck the “R1C1 reference style” box

Here’s a video tutorial:

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Soar Beyond the Dusty Shelf Report

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

Re-Sorting Categories in Pivot Tables

With this technique, we can re-sort Agree, Disagree, Neutral, Strongly Agree, Strongly Disagree…. into Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree.

Simple Spreadsheets

Need some time-savers in Excel? Feel like all the formulas are taking forever? Learn how to clean, analyze, and tabulate your dataset.

Enroll

Weekly Newsletter

Data visualization time-savers in everyday software, like Excel.

Our weekly newsletter is shared with a community of 8,000 researchers, evaluators, and scientists.

Leave a Reply Cancel reply