LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default R1C1 - how can I permanently undo this setting in Excel?

This relates to an issue I'm trying to figure out. In my case I have no
listing in the XLstart directory. Any idea why? Any other suggestions?

"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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro security DKS Setting up and Configuration of Excel 7 October 27th 06 11:57 PM
Why can't I undo forever in Excel like in Word? SamWL Excel Discussion (Misc queries) 4 January 2nd 06 11:14 PM
Excel 2003 Undo greys out after few minutes - Not saving laralea Excel Discussion (Misc queries) 1 June 30th 05 08:14 PM
Permanently visible colunm in an Excel chart Robin McInnes Excel Discussion (Misc queries) 4 April 5th 05 08:45 AM
How can I increas undo level in Microsoft EXCEL ? Sajid Siddique Excel Discussion (Misc queries) 2 November 27th 04 02:03 AM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"