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 to cancel automatic payments in your PayPal Business account

If you have a PayPal business account, you might...

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.
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.