Have you ever tried switching characters in Excel columns and found no way to do it? Well, it is a simple task and can be done within five (5) minutes depending on your current knowledge of Microsoft Excel.
Excel 2010
1. Launch Microsoft Excel 2010.
2. Once it is ready, click on File in the Menu Bar.
3. Next, click on Options then scroll to Formulas.
4. Select or Deselect R1C1 checkbox then Save.
Once saved, you will notice the changes immediately in the columns. Save the Excel document to maintain the settings.
The following two tabs change content below.
Stephan Pringle
Technology Support Specialist at Sipylus
About The Author: Stephan Pringle is an Information Technology Support Specialist. He covers hardware and software and provides tips for you to troubleshoot and repair issues on your own. In his spare time, he writes articles about the State of New York on his Hackintosh and HackBook and that has helped him to become the top contributor of the New York City section of Yahoo! Answers.
Latest posts by Stephan Pringle (see all)
- Troubleshoot Fan Failures - Sunday, October 17, 2021
