Sometimes you might require to know how many columns have your speadsheet covered or how many cells are you highlighting. It gets a bit challenging especially when the column labeling goes past AA. All of us have been there. There is a way in Excel to convert column letters to numbers using the R1C1 Referencing Style. Instead of using letters for columns and numbers for rows, the R1C1 Reference Style option enables using numbers for both rows and columns. After which cells are then referenced to in this format as R1C1.

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.