| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings
I just opened up an excel file and am surprised to see that my columns
now have number headings rather than letter headings. Has anyone else experienced this? If so, how did you rectify it? Please advise!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
toolsoptionsgeneralr1c1
Perhaps a macro changed it? -- Don Guillett SalesAid Software "Teri" wrote in message ups.com... I just opened up an excel file and am surprised to see that my columns now have number headings rather than letter headings. Has anyone else experienced this? If so, how did you rectify it? Please advise!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
Tools - Options - General Tab - R1C1 Reference Style
Make sure it's unchecked. Cheers, Jason Lepack Teri wrote: I just opened up an excel file and am surprised to see that my columns now have number headings rather than letter headings. Has anyone else experienced this? If so, how did you rectify it? Please advise!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
ToolsOptionsGeneral tab, uncheck R1C1 reference style
-- Kind regards, Niek Otten Microsoft MVP - Excel "Teri" wrote in message ups.com... |I just opened up an excel file and am surprised to see that my columns | now have number headings rather than letter headings. Has anyone else | experienced this? If so, how did you rectify it? Please advise!!! | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
Thank you, thank you, thank you!!!! Niek Otten wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Teri" wrote in message ups.com... |I just opened up an excel file and am surprised to see that my columns | now have number headings rather than letter headings. Has anyone else | experienced this? If so, how did you rectify it? Please advise!!! | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headings
You're welcome 1
-- Don Guillett SalesAid Software "Teri" wrote in message ps.com... Thank you, thank you, thank you!!!! Niek Otten wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Teri" wrote in message ups.com... |I just opened up an excel file and am surprised to see that my columns | now have number headings rather than letter headings. Has anyone else | experienced this? If so, how did you rectify it? Please advise!!! | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Linear Mode
