GetHow

Your How to Guide

  • Business
  • Career & Education
  • Entertainment
  • Health & Fitness
  • Internet
  • Technology
  • Tutorials

Switch the Columns Heading to 123 or ABC in Excel

April 6, 2013 by Atul Kumar Pandey

In Microsoft Excel we have an option to change columns heading to numerical digits like 123 or alpha digit as ABC. This switch of columns heading are known as R1C1 reference style. Let’s see how to switch the columns heading by 123 or ABC in excel.

Excel

In This method you can change the way excel formula of refer cells. Instead of using letters for columns and numbers for rows, this option enables using numbers for both rows and columns.

A1 R1C1 Style

Here are the steps to changing reference style of excel columns. You just need to follow the steps properly to switch the style between A1 and R1C1.

Change Columns Head from ABC to 123

Open MS Excel » Click on Office Button » Click on Excel Option » Click on Formulas » Check R1C1 Reference Style Box.

By this method to can change the excel column heads to 123 from ABC.

Change Columns Head from 123 to ABC

Open MS Excel » Click on Office Button » Click on Excel Option » Click on Formulas » Uncheck R1C1 Reference Style Box.

By this method to can change the excel column heads to ABC from 123.

Conclusion : If you select the R1C1 Reference Style your excel rows and columns both become numerical and you unchecked it again then you will revert back to ABC from 123.

This reference style is useful for making macros and additional tasks. For normal humans like we simple A1 style is better than R1C1 style.

Filed Under: Tutorials Tagged: Excel, Microsoft Excel, Microsoft Office, MS Excel

About Atul Kumar Pandey

I'm Atul Kumar Pandey, a full time blogger at GetHow by passion and founder of this blog by profession. I write what makes me feel worthy enough to share.

Business News

Home Loan

Easy Home Loan Repayment Options to Be Debt-Free Faster

Gold

Dos and Don’ts of Buying Gold in India

Loan for Engineers

Step by Step Guide for Getting a Loan for Engineers

Conference Calls

Audio Conference Calls: The Pros and Cons of this Collaboration Method

Heath and Fitness

Biking

5 Ways to Stay Fit Outdoors

Aerobics

Use These Effective Tricks To Balance Both Exercises And Food Intake To Burn Off Excess Fat

Three Tips on How to Be Healthier in Mind, Body, and Soul

Unhealthy and Unsustainable Diets

3 Most Unhealthy and Unsustainable Diets You Should Never Try

About Us | Advertise | Affiliate Disclosure | Privacy Policy | Write for Us


Handcrafted with by Atul

Powered by GetHow