| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel is showing numbers as headers for both rows and columns??
How do I change the column headers back to letters? Formulas will still work
if I use r1c1 format, but why did it change from letter headers on columns? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel is showing numbers as headers for both rows and columns??
Tools|Options|General Tab
Uncheck the R1C1 reference style button. Excel will pick this setting from the first workbook that it opens in that session. rrgyoung wrote: How do I change the column headers back to letters? Formulas will still work if I use r1c1 format, but why did it change from letter headers on columns? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel is showing numbers as headers for both rows and columns??
Try this... Under Tools, open Options, then select the "General" tab. Under
Settings, see if R1C1 reference style is checked. If it is, clear it. That should fix your problem. Good luck! "rrgyoung" wrote: How do I change the column headers back to letters? Formulas will still work if I use r1c1 format, but why did it change from letter headers on columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set rows to Alpha and columns to numbers? | Setting up and Configuration of Excel | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Excel - Columns into rows | New Users to Excel | |||
| Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Linear Mode
