R1C1 - how can I permanently undo this setting in Excel?
Of course, I should have thought about Personal.xls as well.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Sheila" wrote in message
...
Hi Bob
Thankx for your suggestion. I found a file called "personal.xls" in that
folder (not book.xlt) and I opened it and then made the change and saved
it
and my problem is solved!!!!
You pointed me in the right direction and I thank you for that.
Cheers
Sheila
"Bob Phillips" wrote:
Could it be that you have the workbook template setup in R1C1, it is
Book.xlt in the XLStart directory.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Dave Peterson" wrote in message
...
Excel picks up this setting from the first workbook you open in that
session.
If you're unlucky enough that your first workbook opened is in R1C1
reference
style, you'll have to make the change.
Do you save the workbook after you make the change to A1 reference
style?
Do you have a coworker who likes R1C1 and saves it that way? (Could
mean
a
fight!)
Sheila wrote:
Despite changing the setting under Options/General where I uncheck
the
box
"R1C1" every time I open Excel, it does not seem to store my setting
permanently. How can I permanently undo this setting so that I
work in
"A1"
mode?
Thankx
Sheila
--
Dave Peterson
|