| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column designations (A, B, C,..) are now numbers-how do I change
For my column headings that are normally A, B, C, etc. somehow they have
changed to 1, 2, 3, etc. They are now the same as my row designations. How do I change them back? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column designations (A, B, C,..) are now numbers-how do I change
In the tools menu, select Options. In the Options dialogue box, click on the General tab at the top. Uncheck the box next to R1C1 reference style. Click okay, and you should be good to go. -- schall ------------------------------------------------------------------------ schall's Profile: http://www.excelforum.com/member.php...o&userid=30913 View this thread: http://www.excelforum.com/showthread...hreadid=505890 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column designations (A, B, C,..) are now numbers-how do I change
Tools Options General and clear the R1C1 checkbox
-- Gary''s Student "LM" wrote: For my column headings that are normally A, B, C, etc. somehow they have changed to 1, 2, 3, etc. They are now the same as my row designations. How do I change them back? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column designations (A, B, C,..) are now numbers-how do I change
Tools options general R1C1 uncheck
HTH Regards, Howard "LM" wrote in message ... For my column headings that are normally A, B, C, etc. somehow they have changed to 1, 2, 3, etc. They are now the same as my row designations. How do I change them back? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
