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.

Related articles

How I got my first Fiverr clients by doing everything ‘wrong’

...or how I made my first few thousand dollars as a Fiverr copywriter without working almost for free!

Configure NEWS web parts in SHAREPOINT – complete tutorial

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

7 fantastic writing tools to supercharge your writing

As a writer, your main job is to produce lots of useful, accessible, easy to read content. Here are seven writing tools that will let you put lots of words on the page quickly, save time and improve your writing style.

Remove PowerPoint speaker notes in 30 seconds – from all slides at once

We show you how to remove PowerPoint speaker notes before sharing your presentation with others. This is super handy if you have notes in your presentation that you don't want your audience or boss (or cat) to see.
Marius
Mariushttps://pixamoo.com
I'm a copywriter, content creator and all-round creative. When I'm not writing or recording for Pixamoo, I film and edit OwnerDrive videos, do freelance copywriting, practice martial arts, build websites and intranets, and work for The Man.