Changing Excel's default Zoom setting

Discussion in 'Mac Applications and Mac App Store' started by obrien234, Feb 10, 2007.

  1. macrumors regular

    Joined:
    Apr 12, 2005
    Location:
    Brighton, MI
    #1
    Does anybody know of a way to have Excel automatically resize and zoom in on a document opened? I get a bunch of Excel files in my emails and everytime they open its at 75% zoom and is only taking up a quarter of my screen. I would just like a setting or script that has excel automatically put any file at a certain zoom and window size as it opens it.

    It's becoming a huge hassle to resize and rezoom them everytime I open them....

    Thanks
     
  2. macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #2
    I'm no Excel macro expert, but I imagine it would be relatively trivial to write one to do what you want, then assign it a button in your menu bar or shortcut keystroke. Maybe via the record macro option? Just an idea...
     
  3. macrumors G3

    clevin

    Joined:
    Aug 6, 2006
    #3
    i dont quite understand ur problem, do u mean

    1. excel's main windows is small?
    2. the charts inside excel does not occupy the whole main window of excel?

    or other?
     
  4. thread starter macrumors regular

    Joined:
    Apr 12, 2005
    Location:
    Brighton, MI
    #4
    In the attached pictures you can see what I mean. The first is of how files are opened, and the second is how I would like them to be opened. A majority of the files pop up so small that they are impossible to read without resizing.


    Is there anyway to have Excel to automatically set the files setting so my Excel files will open like the second picture?
     

    Attached Files:

  5. macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #5
    I don't know of a way to have it remember the window size, but as I said in my first post, I imagine that you could assign a keystroke combination to do this, using a macro. It would be very fast.
     
  6. thread starter macrumors regular

    Joined:
    Apr 12, 2005
    Location:
    Brighton, MI
    #6
    Yeah I'd never really done anything with Macros, but that definitely did the trick.

    Thanks!
     
  7. macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #7
    Good to hear that you had luck with the suggestion.

    :D
     
  8. macrumors 6502a

    KD7IWP

    Joined:
    Mar 8, 2004
    Location:
    American living in Canada
    #8
    Would you mind posting how you did it with a macro? (I obviously have not used macros before)
     
  9. macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #9
    The 'record macro' feature is really handy, because you just hit start and it follows your actions. So, hit 'record', then resize the window to your desired size. Then, stop recording. It'll save the macro, and you can assign a keyboard shortcut or button to run it. Easy as pie.
     

Share This Page