How to change columns heading from letters to Number in excel
Join this channel to get access to perks:
https://www.youtube.com/channel/UC3XH...
#ExcelTips #ExcelTipsAndTricks #ExcelColumnHeading
Hello my friend today I going to show you How to change columns heading from letters to Number in excel. I already show you one by one, If you not understand or need more video please drop comment below, I'll make the video for you. I hope my video tutorial is can help you, Please like and subscribe to get new video. Thank you for watching.
This is introduction :How to change columns heading from letters to Number in excel:
1- Go to File
2- Click on Option
3- Click on Formula
4- Scroll to "Working with formulas" block
5- Uncheck on R1C1 reference style ( If you would like to using Column heading is a number)
- Check on R1C1 reference style ( If you would like to using Column heading is a letters)
6- Click OK
7-Done.
In Microsoft Excel 2016, 2013 Excel spreadsheet has numbers for both rows and columns. How do I change the column headings back to letters such as A, B, C, D?
Traditionally, column headings are represented by letters such as A, B, C, D. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps.
In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.
For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ or https://bigboxsoftware.net/
Check out my previous video :
- How to show battery percent on iPhone : https://youtu.be/52cLHcZKKpw
- How to install Khmer keyboard completely on iPhone latest : https://youtu.be/89Ql_2HlkPg
- How to show easy touch on iPhone iOS 14 | iPhone tips : https://youtu.be/2VueM1XBQnU
- How to change youtube cover image | YoutubeTips & Tricks : https://youtu.be/kRttpDl0gm0
- How to customize widget and reset iOS 14 home screen : https://youtu.be/rpVZJ1IIjtM
- How to record screen on iPhone without any app : https://youtu.be/Ny5LDFV7RSI
- How to check duration of season ends on mobile legends : https://youtu.be/zwftOm3DsZU
- New Updated | How to turn on speed boost in Mobile Legends : https://youtu.be/QvYuzYUn_LE
- How to change youtube light mode to dark mode on phone : https://youtu.be/HOTK82ZpnDQ
- how to change language on mobile legends : https://www.youtube.com/watch?v=BkCWX...
- How to convert file PDF to image with adobe XI Pro : https://www.youtube.com/watch?v=0kdE3...
- How to merge PDF File With Adobe Acrobat XI Pro : https://youtu.be/UrPwppzlJls
- How to change profile photo in Mobile Legends : https://youtu.be/mMifRA6LtbU
- How to check season rewards on Mobile Legends : https://www.youtube.com/watch?v=o08uI...
- How to show This PC on desktop in window 10 : https://www.youtube.com/watch?v=Ik-Ak...
- How to change quick chat on mobile legends: https://www.youtube.com/watch?v=UgW6P...
- How to change position of skill control in mobile legends : https://www.youtube.com/watch?v=2OIE7...
Check out my popular playlist :
- Excel tutorials 2020 : https://www.youtube.com/playlist?list...
- Blogger tips and tricks : https://www.youtube.com/playlist?list...
- Google Form : https://www.youtube.com/playlist?list...
- General Knowledge: https://www.youtube.com/playlist?list...
- Technology tips and tricks: https://www.youtube.com/playlist?list...
- Game : https://www.youtube.com/playlist?list...
Computer tips and tricks : https://www.youtube.com/playlist?list...
If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app … My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week.
Thank you for your time, And hope all my video is helpful for you, Have a nice day !
