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
|
|||
|
|||
How do I change sheet notation from R1C1 style to A1 style in XL 2
Since the configuration system is different in Excel 2007 from previous
versions, I am unable to determine how to change the sheet notation from the R1C1 style (default) to the A1 style (preferred). Thanks in advance. |
#2
|
|||
|
|||
How do I change sheet notation from R1C1 style to A1 style in XL 2
Office ButtonExcel optionsformulasunder 'working with formulas' section,
un-check R1C1 reference style -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Sherlock1506" wrote in message ... Since the configuration system is different in Excel 2007 from previous versions, I am unable to determine how to change the sheet notation from the R1C1 style (default) to the A1 style (preferred). Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|