| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column 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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column grid is numeric I want letters - A B C D etc.,
"Elaine" wrote in message
... 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.... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column grid is numeric I want letters - A B C D etc.,
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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Elaine" wrote in message ... Have 2007 Excel cannot figure out how to change top of columns to letters rather than numbers. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column grid is numeric I want letters - A B C D etc.,
"Chip Pearson" wrote in message
... 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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column grid is numeric I want letters - A B C D etc.,
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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Gordon" wrote in message ... "Chip Pearson" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| letters drive a numeric result | Excel Worksheet Functions | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| How do I change the grid axes to #'s and letters? | Excel Discussion (Misc queries) | |||
| How do I change the grid axes to #'s and letters? | Excel Discussion (Misc queries) | |||
| Sepearting Numeric Data from Letters | Excel Discussion (Misc queries) | |||
Linear Mode
