Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
My columsn are numbered. They are no longer alphabetized. I am using excel
2007 and I have no idea why this has happened. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
hi
your reference notation has switched from A1 to R1C1. Why? no clue. to change back..... chick the office button then excel options. on the left side click formulas uncheck R1C1 reference style. regards FSt1 "Marco" wrote: My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
I'm not sure about XL2007, but I'm sure it's similar. Go to
Tools|Options|General (Tab). Uncheck 'R1C1 reference style'. HTH, Paul -- "Marco" wrote in message ... My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
Excel optionsformulasworking with formulasuncheck r1c1
-- Don Guillett Microsoft MVP Excel SalesAid Software "Marco" wrote in message ... My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
In Excel 2003 it's Tools/ Options/ General
Unset R1C1 reference style According to the 2003 to 2007 translation guide (http://office.microsoft.com/en-us/ex...91511033.aspx), in Excel 2007 the equivalent of Tools/ Options is Office button/ Excel Options. -- David Biddulph "Marco" wrote in message ... My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
why my columns in excel are no longer alphabetized?
another 2003 to 2007 conversion...
http://www.rondebruin.nl/0307commands.htm regards FSt1 "David Biddulph" wrote: In Excel 2003 it's Tools/ Options/ General Unset R1C1 reference style According to the 2003 to 2007 translation guide (http://office.microsoft.com/en-us/ex...91511033.aspx), in Excel 2007 the equivalent of Tools/ Options is Office button/ Excel Options. -- David Biddulph "Marco" wrote in message ... My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alphabetized reference to a list | Excel Discussion (Misc queries) | |||
Why are my Excel columns numbered and not alphabetized (A..ZZ)? | Excel Discussion (Misc queries) | |||
Why are my Excel columns numbered and not alphabetized (A..ZZ)? | Excel Discussion (Misc queries) | |||
can no longer insert new columns & unhide hidden columns | Excel Worksheet Functions | |||
Items in drop-down list alphabetized | Excel Worksheet Functions |