Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 10, 03:49 PM posted to microsoft.public.excel.setup
m m is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 64
Default change excel sheet defaults

When I first open Excel '07, the page defaults to r1c1 reference style and
manual calculations. I change it back to "normal" everyday, but it's so
frustrating! How can I change this permanently? I could do it in earlier
versions of Excel, but haven't found a way here.

  #2   Report Post  
Old March 12th 10, 05:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 345
Default change excel sheet defaults

Try this:
Click on The Office Button (the big round circle next to the Home tab on the
ribbon).
Click on the 'Excel Options' button (along the bottom).
Click on 'Formulas' in the left hand column.
and uncheck the R1C1 option in the 'working with formulas' section
Then click on OK to close the window.
Hope this helps

"M" wrote:

When I first open Excel '07, the page defaults to r1c1 reference style and
manual calculations. I change it back to "normal" everyday, but it's so
frustrating! How can I change this permanently? I could do it in earlier
versions of Excel, but haven't found a way here.

  #3   Report Post  
Old March 12th 10, 06:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default change excel sheet defaults

The first workbook opened will govern the settings for all subsequent
workbooks.

Do you have a Book1.xlsx in your XLSTART folder? Remove it.

Have you altered the default Excel workbook by creating a new Template
Book.xltx or similar?

Make changes to that Template.


Gord Dibben MS Excel MVP


On Thu, 11 Mar 2010 07:49:01 -0800, M wrote:

When I first open Excel '07, the page defaults to r1c1 reference style and
manual calculations. I change it back to "normal" everyday, but it's so
frustrating! How can I change this permanently? I could do it in earlier
versions of Excel, but haven't found a way here.




Reply
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
Change Excel Defaults Regarding the Clipboard BECoggins Excel Discussion (Misc queries) 0 September 15th 09 07:26 PM
How do I change the defaults for Page Setup in Excel? Val Excel Discussion (Misc queries) 2 June 15th 06 08:59 PM
Change Excel Find & Replace Options Defaults Rocky Lane Excel Discussion (Misc queries) 1 March 29th 06 03:39 PM
how can I change edit-find defaults in excel? kenschm Excel Discussion (Misc queries) 1 November 25th 05 02:57 AM
Can you change the defaults for Excel ? Nino Richards Excel Discussion (Misc queries) 1 December 15th 04 04:35 PM


All times are GMT +1. The time now is 02:00 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017