Changing Excel's default Zoom setting

[obrien234]

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

 

[gauchogolfer]

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...

 

[clevin]

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?

 

[obrien234]

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?

 

[gauchogolfer]

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?

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.

 

[obrien234]

Yeah I'd never really done anything with Macros, but that definitely did the trick.

Thanks!

 

[gauchogolfer]

Yeah I'd never really done anything with Macros, but that definitely did the trick.

Thanks!

Good to hear that you had luck with the suggestion.

 

[KD7IWP]

Would you mind posting how you did it with a macro? (I obviously have not used macros before)

 

[gauchogolfer]

Would you mind posting how you did it with a macro? (I obviously have not used macros before)

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.