Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
My column headers have changed from the usual letters to numbers (like the
row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
In Excel 2003 go to
Tool-Options-General Tab-Settings Group Clear the checkbox against 'R1 C1 reference style' "Flanker" wrote: My column headers have changed from the usual letters to numbers (like the row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
Tools/ Options/ General:
Uncheck R1C1 reference style. -- David Biddulph "Flanker" wrote in message ... My column headers have changed from the usual letters to numbers (like the row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
I need a solution for Excel 2007.
"Sheeloo" wrote: In Excel 2003 go to Tool-Options-General Tab-Settings Group Clear the checkbox against 'R1 C1 reference style' "Flanker" wrote: My column headers have changed from the usual letters to numbers (like the row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
In Excel 2007, I clicked on the Office Button then "Excel Options" then
"Formulas". In the "Working with formulas" section, I unchecked the box next to "R1 C1 reference style" Thanks Sheeloo! "Sheeloo" wrote: In Excel 2003 go to Tool-Options-General Tab-Settings Group Clear the checkbox against 'R1 C1 reference style' "Flanker" wrote: My column headers have changed from the usual letters to numbers (like the row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colunmn headers
If you still haven't found the 2003 to 2007 cross-reference guide, bookmark
http://office.microsoft.com/en-us/ex...491511033.aspx -- David Biddulph "Flanker" wrote in message ... I need a solution for Excel 2007. "Sheeloo" wrote: In Excel 2003 go to Tool-Options-General Tab-Settings Group Clear the checkbox against 'R1 C1 reference style' "Flanker" wrote: My column headers have changed from the usual letters to numbers (like the row headers). In any spreadsheet I open, the columns are now numbered. How do I get my column headers back to letters. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
& in headers | Excel Discussion (Misc queries) | |||
headers | Excel Worksheet Functions | |||
Headers | Excel Discussion (Misc queries) | |||
Headers | Excel Discussion (Misc queries) | |||
Row Headers | Excel Discussion (Misc queries) |