 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Column grid is numeric I want letters - A B C D etc.,
Have 2007 Excel cannot figure out how to change top of columns to letters rather than numbers. > Have 2007 Excel cannot figure out how to change top of columns to letters > rather than numbers. the Columns are letters by default....so I don't know what you've done to turn them to numbers.... Click on the Office button (the big round button in the upper left), and click "Excel Options" at the bottom of dialog. There, choose "Formulas" on the left and then uncheck the "R1C1 Reference Style" setting.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) > Have 2007 Excel cannot figure out how to change top of columns to letters > rather than numbers. > Click on the Office button (the big round button in the upper left), and > click "Excel Options" at the bottom of dialog. There, choose "Formulas" on > the left and then uncheck the "R1C1 Reference Style" setting. No wonder no-one can find that! What on earth possessed the developers to put it under FORMULAS? > No wonder no-one can find that! What on earth possessed the developers to > put it under FORMULAS? It makes perfect sense, to me at least, to put it in the Formulas section. Not only does the R1C1 setting control how column headers are displayed, but it more importantly controls how you must enter cell reference in formulas. If R1C1 is enabled, you would use a formula like =SUM(R1C1:R3C2) rather than =SUM(A1:B3) to sum a range. The setting's biggest impact is on formula entry so it quite rightly belongs in the Formula section of the Options dialog. SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) >> Click on the Office button (the big round button in the upper left), and >> click "Excel Options" at the bottom of dialog. There, choose "Formulas" >> on the left and then uncheck the "R1C1 Reference Style" setting. > > No wonder no-one can find that! What on earth possessed the developers to > put it under FORMULAS? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.