| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Column reference got changed
Column references in my excel sheets which which usually show as A B C D
....... are now showing 1 2 3 4 5 Please help |
|
#2
|
|||
|
|||
|
willy wrote:
Column references in my excel sheets which which usually show as A B C D ...... are now showing 1 2 3 4 5 Please help Tools | Options, General tab. Untick R1C1 reference style. -- Message posted via http://www.officekb.com |
|
#3
|
|||
|
|||
|
Goto <Tools<Options<Settings and untick <R1C1 reference style.
Regards. Bill Ridgeway Computer Solutions "willy" wrote in message ... Column references in my excel sheets which which usually show as A B C D ...... are now showing 1 2 3 4 5 Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
