Every few months Bill receives a call or an email from someone stating that their Formulas are 'changed' and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? "R1C1" is the answer. Follow along with Bill in Episode #1467 to find out what happened and how to correct it.
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1467: column letters are numbers.
Today's question is sent in by Alex.
“This happens every six months or so.
All my formulas are bizarre and hey, column A is now 1 and B is 2.
What is this?
How did this happen?
What did I do?” This is called R1C1 style.
This is how Microsoft's started doing spreadsheets all the way back in the days of multi plan, but when Lotus 123 became dominant and they used A1 style, well, Microsoft switched over to the new style.
To get back, go to file and then down to options and then formula.
Right there, R1C1 reference style, uncheck that.
You might have accidentally checked it or maybe a co-worker did it as a practical joke.
Click OK and everything is back to and normal.
Well, hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast, episode 1467: column letters are numbers.
Today's question is sent in by Alex.
“This happens every six months or so.
All my formulas are bizarre and hey, column A is now 1 and B is 2.
What is this?
How did this happen?
What did I do?” This is called R1C1 style.
This is how Microsoft's started doing spreadsheets all the way back in the days of multi plan, but when Lotus 123 became dominant and they used A1 style, well, Microsoft switched over to the new style.
To get back, go to file and then down to options and then formula.
Right there, R1C1 reference style, uncheck that.
You might have accidentally checked it or maybe a co-worker did it as a practical joke.
Click OK and everything is back to and normal.
Well, hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
