As we all know that excel sheet will have column headings using which we perform all mathematical operation, formulas etc. The headings can be A,B,C,...ZZ format or 1,2,3....etc. Depending on our requirement we can change these using excel settings. Mostly in case of performing mathematical calculations using formulas, we prefer to have column headings as characters instead of numbers. Here I will show you "How To Change The Column Heading(Identity) In MS Excel" from numbers to characters and characters to numbers.
You just need to follow the below steps to change your Microsoft Excel Column Headings from A,B,C... to 1,2,3... or vice versa.
How To Change The Column Heading(Identity) In MS Excel
1) Open Excel Sheet
2) Click on Excel Office Button (Top Left most) then
3) Click on "Excel Options" then
You will get an "Excel Options" Interface.
4) Click on "Formulas" (at left side) then
5) UnCheck "R1F1 reference style" then (For Alphabetic Rows)
OR
5) Check "RR1F1 reference style" then (For Numeric Rows)
6) Click on "Ok"
Thats it, you have successfully converted your Excel Sheet column Identity from 1,2,3.... to A,B,C...
Please refer the snapshots for the same.
Let me know if you have any queries in this regard
No comments:
Post a Comment