Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column Header Problem
My column headers are 1,2,3,etc. and my row header is A,B,C,etc. If you
think about this - this is the exact opposite of the norm. How do you switch the column header to A,B,C,etc and the row header to 1,2,3,etc?? Please help...I can't seem to figure this out. Thanks!! |
#2
|
|||
|
|||
Hi
goto 'Tools - Options - International' and see if something is wrong there -- Regards Frank Kabel Frankfurt, Germany "Waylon" schrieb im Newsbeitrag ... My column headers are 1,2,3,etc. and my row header is A,B,C,etc. If you think about this - this is the exact opposite of the norm. How do you switch the column header to A,B,C,etc and the row header to 1,2,3,etc?? Please help...I can't seem to figure this out. Thanks!! |
#3
|
|||
|
|||
Frank-
Thanks...but no that was not it.....I've also seen where both the row and column header are both numerical. I would love to know how to fix this also. Only happened in one spreadsheet - when I open a new it's correct??? Thanks! "Frank Kabel" wrote: Hi goto 'Tools - Options - International' and see if something is wrong there -- Regards Frank Kabel Frankfurt, Germany "Waylon" schrieb im Newsbeitrag ... My column headers are 1,2,3,etc. and my row header is A,B,C,etc. If you think about this - this is the exact opposite of the norm. How do you switch the column header to A,B,C,etc and the row header to 1,2,3,etc?? Please help...I can't seem to figure this out. Thanks!! |
#4
|
|||
|
|||
Hi
if both are numeric goto 'tools - Options - General' and uncheck 'R1C1 Reference Style' -- Regards Frank Kabel Frankfurt, Germany "Waylon" schrieb im Newsbeitrag ... Frank- Thanks...but no that was not it.....I've also seen where both the row and column header are both numerical. I would love to know how to fix this also. Only happened in one spreadsheet - when I open a new it's correct??? Thanks! "Frank Kabel" wrote: Hi goto 'Tools - Options - International' and see if something is wrong there -- Regards Frank Kabel Frankfurt, Germany "Waylon" schrieb im Newsbeitrag ... My column headers are 1,2,3,etc. and my row header is A,B,C,etc. If you think about this - this is the exact opposite of the norm. How do you switch the column header to A,B,C,etc and the row header to 1,2,3,etc?? Please help...I can't seem to figure this out. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Column header, if row value is > X | Excel Discussion (Misc queries) | |||
Column searching problem | New Users to Excel | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |