| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings
The column headings in an Excel spreadsheet switched from letters (A,B,C,
etc.) to numbers (1,2,3, etc.) This happened in only one of my spreadsheets. Why did this happen, and how can I change the columns back to letters? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
Tools/ Options/ General
Unset R1C1 reference style. -- David Biddulph "don" wrote in message ... The column headings in an Excel spreadsheet switched from letters (A,B,C, etc.) to numbers (1,2,3, etc.) This happened in only one of my spreadsheets. Why did this happen, and how can I change the columns back to letters? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
On the top menu of the worksheet :
TOOLS OPTIONS GENERAL UNcheck R1C1 reference style. -- Can''''t hear the Rain ? Then listen to it. "don" wrote: The column headings in an Excel spreadsheet switched from letters (A,B,C, etc.) to numbers (1,2,3, etc.) This happened in only one of my spreadsheets. Why did this happen, and how can I change the columns back to letters? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
| How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
| How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
| column headings | Excel Worksheet Functions | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
