If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Method of viewing/naming columns or conversions for same
Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? |
#2
|
|||
|
|||
Method of viewing/naming columns or conversions for same
In EXCEL 2007:-
Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is a tick (check) in the box called:- R1C1 reference style It applies to the whole Workbook. If my comments have helped please hit Yes. Thanks. "Copacetic" wrote: Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? . |
#3
|
|||
|
|||
Method of viewing/naming columns or conversions for same
In EXCEL 2003 and earlier....
Tools/Options on menu bar... General tab... Settings section... "R1C1 reference style" checkbox. Setting is global for the entire workbook. -- Rick (MVP - Excel) "trip_to_tokyo" wrote in message news In EXCEL 2007:- Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is a tick (check) in the box called:- R1C1 reference style It applies to the whole Workbook. If my comments have helped please hit Yes. Thanks. "Copacetic" wrote: Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? . |
#4
|
|||
|
|||
Method of viewing/naming columns or conversions for same
On Sat, 8 May 2010 14:44:12 -0400, "Rick Rothstein"
wrote: In EXCEL 2003 and earlier.... Tools/Options on menu bar... General tab... Settings section... "R1C1 reference style" checkbox. Setting is global for the entire workbook. I think there is some key combination that allows one to see the numbering in the 'names' field. Not sure what it is though. |
Thread Tools | |
Display Modes | |
|
|