| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change numeric column designations to alpha?
Sometimes Excel opens with numeric designators on columns and row. I want
alpha on the columns and numeric on the rows. Can I set that in preferences? If now, how do I change it when it happens (seemingly at random)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change numeric column designations to alpha?
Tools - Options - General - Uncheck R1C1
Excel however remebers the setting from the last workbook opened so don't be surprised if it changes back. Any help? Mike "Sarah" wrote: Sometimes Excel opens with numeric designators on columns and row. I want alpha on the columns and numeric on the rows. Can I set that in preferences? If now, how do I change it when it happens (seemingly at random)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change my column references from Alpha to Numeric? | Excel Worksheet Functions | |||
| Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
| Change the column designation from a numeric to an alpha | Excel Discussion (Misc queries) | |||
| change excel auto column headers from numeric to alpha | Excel Discussion (Misc queries) | |||
| Column designations (A, B, C,..) are now numbers-how do I change | Excel Discussion (Misc queries) | |||
Linear Mode
