![]() Open MS Excel » Click on Office Button » Click on Excel Option » Click on Formulas » Check R1C1 Reference Style Box.īy this method to can change the excel column heads to 123 from ABC. You just need to follow the steps properly to switch the style between A1 and R1C1. Here are the steps to changing reference style of excel columns. Instead of using letters for columns and numbers for rows, this option enables using numbers for both rows and columns. In This method you can change the way excel formula of refer cells. ![]() Let’s see how to switch the columns heading by 123 or ABC in excel. This switch of columns heading are known as R1C1 reference style. In Microsoft Excel we have an option to change columns heading to numerical digits like 123 or alpha digit as ABC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |