3 Replies Latest reply: Jan 2, 2013 7:52 AM by Klaus Blume
GARGAR Level 1 Level 1 (0 points)

How to get MSExcel to center the spreadsheet upon opening the application?

 

I have OS X 10.6.8 and when I open MS Excel the new spreasor saved file always opens off center and sometimes under the toolbars. Has anyone found a way to have the file or new file open in a maximized way without being off center or under the toolbars above? Thanks.


MacBook Pro, Mac OS X (10.6.8)
  • 1. Re: How to get MSExcel to center the spreadsheet upon opening the application?
    Klaus Blume Level 2 Level 2 (305 points)

    Mmm..., this is strange. Mine doesn’t. This may be a very stupid question, but you ARE clicking the green dot in the upper left corner?

  • 2. Re: How to get MSExcel to center the spreadsheet upon opening the application?
    GARGAR Level 1 Level 1 (0 points)

    No not a stupid question, but that's not the problem. The off centering occurs everytime on opening Excel.

  • 3. Re: How to get MSExcel to center the spreadsheet upon opening the application?
    Klaus Blume Level 2 Level 2 (305 points)

    Throw out the Excel Preference file, and let Excel rebuild a new one. Follow these instructions which come straight from the MS Office site. Before you start, make sure you quit ALL applications, not just the MS Office ones.

     

    Keep us posted, and good luck:

     

    Step 2: Remove the Excel Preferences

     

    To remove the Excel preferences, follow these steps.

    1. Quit all Microsoft Office for Mac applications.
    2. On the Go menu, click Home.
    3. Open Library.
      Note The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
    4. Open the Preferences folder. Click View, click Arrange by, and then select Name.
    5. Look for a file that is named com.microsoft.Excel.plist.
    6. If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
    7. If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
    8. Quit all Office for Mac applications.
    9. On the Go menu, click Home.
    10. Open Library.
      Note The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
    11. Open the Preferences folder.
    12. Open the Microsoft Folder.
    13. Look for a file that is named com.microsoft.Excel.prefs.plist.
    14. If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
    15. If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
    16. Close all Office applications.
    17. On the Go menu, click Home.
    18. Open Library.
      Note The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
    19. Open the Preferences folder.
    20. Open the Microsoft Folder.
    21. Open the Office 2008 or Office 2011 folder.
    22. Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
    23. If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.

    If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash. 

     

    Note If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.