Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 10, 2007, 05:08 PM   #1
obrien234
macrumors regular
 
Join Date: Apr 2005
Location: Brighton, MI
Changing Excel's default Zoom setting

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
obrien234 is offline   0 Reply With Quote
Old Feb 10, 2007, 05:17 PM   #2
gauchogolfer
macrumors 601
 
gauchogolfer's Avatar
 
Join Date: Jan 2005
Location: American Riviera
Send a message via AIM to gauchogolfer Send a message via Yahoo to gauchogolfer Send a message via Skype™ to 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...
__________________
Victoria Concordia Crescit
gauchogolfer is offline   0 Reply With Quote
Old Feb 10, 2007, 05:28 PM   #3
clevin
macrumors G3
 
clevin's Avatar
 
Join Date: Aug 2006
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?
clevin is offline   0 Reply With Quote
Old Feb 10, 2007, 07:18 PM   #4
obrien234
Thread Starter
macrumors regular
 
Join Date: Apr 2005
Location: Brighton, MI
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 Thumbnails
Click image for larger version

Name:	before.jpg
Views:	131
Size:	188.5 KB
ID:	68071   Click image for larger version

Name:	after.jpg
Views:	125
Size:	218.7 KB
ID:	68072  
obrien234 is offline   0 Reply With Quote
Old Feb 10, 2007, 11:30 PM   #5
gauchogolfer
macrumors 601
 
gauchogolfer's Avatar
 
Join Date: Jan 2005
Location: American Riviera
Send a message via AIM to gauchogolfer Send a message via Yahoo to gauchogolfer Send a message via Skype™ to gauchogolfer
Quote:
Originally Posted by obrien234 View Post
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.
__________________
Victoria Concordia Crescit
gauchogolfer is offline   0 Reply With Quote
Old Feb 12, 2007, 12:08 AM   #6
obrien234
Thread Starter
macrumors regular
 
Join Date: Apr 2005
Location: Brighton, MI
Yeah I'd never really done anything with Macros, but that definitely did the trick.

Thanks!
obrien234 is offline   0 Reply With Quote
Old Feb 12, 2007, 12:15 AM   #7
gauchogolfer
macrumors 601
 
gauchogolfer's Avatar
 
Join Date: Jan 2005
Location: American Riviera
Send a message via AIM to gauchogolfer Send a message via Yahoo to gauchogolfer Send a message via Skype™ to gauchogolfer
Quote:
Originally Posted by obrien234 View Post
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.

__________________
Victoria Concordia Crescit
gauchogolfer is offline   0 Reply With Quote
Old Feb 12, 2007, 12:23 AM   #8
KD7IWP
macrumors 6502a
 
KD7IWP's Avatar
 
Join Date: Mar 2004
Location: American living in Canada
Send a message via AIM to KD7IWP
Would you mind posting how you did it with a macro? (I obviously have not used macros before)
__________________
2.66Ghz Quad Nehalem Mac Pro; 16gb iPhone 4; 30GB 5G iPod; 512mb iPod Shuffle.
KD7IWP is offline   0 Reply With Quote
Old Feb 12, 2007, 12:37 AM   #9
gauchogolfer
macrumors 601
 
gauchogolfer's Avatar
 
Join Date: Jan 2005
Location: American Riviera
Send a message via AIM to gauchogolfer Send a message via Yahoo to gauchogolfer Send a message via Skype™ to gauchogolfer
Quote:
Originally Posted by KD7IWP View Post
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.
__________________
Victoria Concordia Crescit
gauchogolfer is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Set Default Zoom in Apple Mail app? RedCroissant Mac Applications and Mac App Store 0 Jul 1, 2013 02:34 AM
Default mail setting orangecrushv iPhone Tips, Help and Troubleshooting 1 Dec 20, 2012 01:32 PM
MS Word 2011 - another default zoom possible? kylera Mac Applications and Mac App Store 1 Dec 17, 2012 05:14 PM
Excel changing to .dat file from Mac to PC sara.leonard Mac OS X 10.7 Lion 3 Aug 29, 2012 09:07 PM
Set default zoom level on mail preview pane rainman7 Mac Applications and Mac App Store 7 Aug 9, 2012 08:10 PM

Forum Jump

All times are GMT -5. The time now is 05:46 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC