How to change EXCEL column labels to numbers and back to letters again

In this quick one-minute tutorial, I show you how to switch between the R1C1 and A1 formats in Excel.

Sometimes you may get an Excel spreadsheet where the columns are labeled with numbers instead of letters, and the formula will look different as a result. Where columns are labeled with numbers, we call that the R1C1 reference style.

When columns are labeled with numbers, we call that the A1 reference style.

There’s no real difference in what you can do with either R1C1 or A1, but if you’re used to working with one format or the other, it’s good to know how to switch between them in case you get a spreadsheet set to the format you don’t normally work with.

GeekyBriefs

Pokémon-AI: 1-0, Apple Watch flirts with AI, Assassin’s Creed milestone, and more…

Browser Use raises $17M to help AI agents navigate...

NVIDIA troubles, crypto laundering, new iPad, Mickey 17 reviews, and more…

🤖 Artificial intelligence OpenAI launches $50M consortium to boost AI...

Read more

Configure NEWS web parts in SHAREPOINT – complete tutorial

This third video in our SharePoint news publishing masterclass...

Master your SharePoint news feed with category filters

We introduce you to a simple, step-by-step process for filtering and displaying SharePoint news posts by category. This way, you can set up news feeds on your site(s) to display specific types of news posts in specific locations.

Publish your first SharePoint news post | complete tutorial

In this first of four lessons, we will turn you into a total expert at SharePoint news publishing! This tutorial is particularly relevant for corporate communication professionals, but even if you're just looking to make the most of your team's SharePoint site you'll get a lot of value from this one.
Marius Berg
Marius Berghttps://goodgeeky.com
I'm a writer, content creator and all-round creative. When I'm not writing for GoodGeeky, I write books (which never seem to get finished), try to not fall apart physically (I just made it halfway to 90), play with AI tools, and work as a tech consultant for The Man.

Hi there! We want to share a few words on how we produce content for GoodGeeky: In short, YES, we do use generative AI to help speed up content production. NO, we never publish automatic, fully machine-generated content. Learn more about our publishing process here!