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:
Why do my Excel formulas say “RC?!” Help!!
Last updated:
Feb 24th, 2025
Related resources:
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.
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.
You Might Like
Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.
Need some time-savers in Excel? Feel like all the formulas are taking forever? Learn how to clean, analyze, and tabulate your dataset.
Spreadsheets to Stories
Weekly Newsletter
You’ll receive:
how-to tutorials about data management, analysis, visualization, and storytelling;
spreadsheets to download so you can try it yourself; and
the latest info about our online courses.
Our weekly newsletter is shared with a community of 8,000 professionals.
Leave a Reply