Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
r1c1 reference style - how to make it default
Yo,
I like using the R1C1 reference style, because I am used to writing formulas this way, etc. The one with the letters gives me the poops. Even though I keep changing it back to R1C1 style every time I open excel it defaults to the stupid letter format. How do I make the rows and columns stay as numbers (make this the default) Thanks, Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
r1c1 reference style - how to make it default
Hello Captain
Toolsoptionsgeneral in that check R1C1 style with regards Sreedhar "Captain_Awesome" wrote: Yo, I like using the R1C1 reference style, because I am used to writing formulas this way, etc. The one with the letters gives me the poops. Even though I keep changing it back to R1C1 style every time I open excel it defaults to the stupid letter format. How do I make the rows and columns stay as numbers (make this the default) Thanks, Scott |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
r1c1 reference style - how to make it default
Thanks yshridar,
I have done that many times. Many, many, many times. However it never stays as the default, each time I open Excel it defaults back to the stupid A format. Damn the A's. Regards, Scott "yshridhar" wrote: Hello Captain Toolsoptionsgeneral in that check R1C1 style with regards Sreedhar "Captain_Awesome" wrote: Yo, I like using the R1C1 reference style, because I am used to writing formulas this way, etc. The one with the letters gives me the poops. Even though I keep changing it back to R1C1 style every time I open excel it defaults to the stupid letter format. How do I make the rows and columns stay as numbers (make this the default) Thanks, Scott |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
r1c1 reference style - how to make it default
You can't make it the default.
Excel picks this setting up from the first workbook it opens in that session. So if you're good, you could always open a workbook that uses this setting. If you're not so good, maybe you could add a workbook to your XLStart workbook that changes the setting and then closes itself. Option Explicit Sub Auto_Open() Workbooks.Add Application.ReferenceStyle = xlR1C1 ThisWorkbook.Close savechanges:=False End Sub Captain_Awesome wrote: Yo, I like using the R1C1 reference style, because I am used to writing formulas this way, etc. The one with the letters gives me the poops. Even though I keep changing it back to R1C1 style every time I open excel it defaults to the stupid letter format. How do I make the rows and columns stay as numbers (make this the default) Thanks, Scott -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
r1c1 reference style - how to make it default
If you're not so good, maybe you could add a workbook to your XLStart *FOLDER*
that changes the setting and then closes itself. Dave Peterson wrote: You can't make it the default. Excel picks this setting up from the first workbook it opens in that session. So if you're good, you could always open a workbook that uses this setting. If you're not so good, maybe you could add a workbook to your XLStart workbook that changes the setting and then closes itself. Option Explicit Sub Auto_Open() Workbooks.Add Application.ReferenceStyle = xlR1C1 ThisWorkbook.Close savechanges:=False End Sub Captain_Awesome wrote: Yo, I like using the R1C1 reference style, because I am used to writing formulas this way, etc. The one with the letters gives me the poops. Even though I keep changing it back to R1C1 style every time I open excel it defaults to the stupid letter format. How do I make the rows and columns stay as numbers (make this the default) Thanks, Scott -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 Reference Style won't STAY gone? | Excel Discussion (Misc queries) | |||
I switched on the R1C1 reference style but I can't switch it off a | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) |