Benches macOS

9

Default Window Size Too Large

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I have just started using Numbers and am having trouble with the window size.

I have a laptop with a 14" screen and Numbers opens excel spreadsheets and it's own new spreadsheets too large for my screen.

My monitor is set to 1024 x 768 but the sheets are still at least 1/3 off the right side of the screen.

Is there a way to set the default window size?

Thanks

Chris

9 replies

Sign in or join Beachball Help to reply.

  1. 0

    Barry Fass-Holmes

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Chris,

    Welcome to Apple Discussions!

    Here are two possible workarounds.

    1. Configure a blank Numbers worksheet the way you want it, then save it as a template (File>Save as Template…), then select that template when you want to start with a blank Numbers worksheet instead of selecting the blank template that comes with Numbers.

    2. For existing spreadsheets, use an AppleScript that configures the window's dimension.

    +tell application "Numbers"+

    + activate+

    + set bounds of window 1 to {0, 0, 800, 700}+

    + activate+

    +end tell+

    Please ignore the plus signs in the above script.

    You'll need to experiment with the last two values in the third line above to meet your exact preference for the window's height and width.

    Save the resulting AppleScript (from Script Editor) as an application and save it to the Scripts folder that is in your user account's Library folder; if you create a "Numbers" folder (without the quote marks) in that Scripts folder, you will find a "Numbers" folder item in the Scripts menu in your menu bar, thus providing easy access to the above AppleScript while you're working in Numbers.

    Hope the above is helpful and makes sense. Otherwise, please post back with questions.

    Cheers!

  2. 0

    Peggy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Welcome to Apple Discussions Chris

    Yes, create your own template with the size, fonts, etc. you want & save it as a template, it will show up in the Template Chooser. You can then set this template as the default for all new Numbers documents in Preferences.

    User uploaded file

  3. 0

    cmaccreery

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks Barry and Peggy for the info.

    Good advice.

    I would have thought the applications would automatically check the resolution and size windows accordingly.

    Like when I open an application and it doesn't overun the dock or the Menu bar.

    It is irritating if you use multiple computers with different size monitors.

    I have opened documents on my iBook that were created on my desktop computer and have not been able to get to the resize handle in the lower right cornersince it is off the screen. However, I learned the resize button works for this.

    Numbers has no resize button on the window.

    Thanks Again

    Chris

  4. 0

    ninja9578

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I think they didn't worry about screen size because they're getting ready for Leopard. Correct me if I'm wrong, but isn't Leopard resolution independent?

  5. 0

    Ashka

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I have the same problem, 14" laptop with 1024 x 768.

    I just click the green button top left 🙂 and it resizes numbers to the screen. OK. it cuts off the last part of the format bar but all the options cut off are also available in the inspector or on the tool bar.

    Works fine that way for me, hope it helps you.

  6. 0

    Th.J.

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    This is from their own *_Human Interface Guidelines_*:

    +*Resizing and Zooming Windows*+

    +Your application determines the minimum and maximum window size. Base these sizes on the resolution of the display and on the constraints of your interface. For document windows, try to show as much of the content as possible, or a reasonable unit, such as a page.+

    +Before reopening a window, make sure that the size and state are feasible for the user’s current monitor setup, which may not be the same as the last time the document was open. Try to maintain the window’s previous location (the top-left corner of the window) and, if possible, its size. If you can’t replicate both, maintain the location and reduce the window’s size. If that is not possible, try to keep the window on the same monitor, open the window so that as much of the content as necessary is visible, and follow the guidelines for opening a new window, as described previously.+

    +For example, if a user opens a document to full size on a wide aspect-ratio display and then opens the file on a computer with a smaller display, the document should open in a window sized for the smaller display, not in the larger, saved size. +

    it's just a stupid bug... read along with next part:

    Displays

    +Avoid making assumptions about display size. Mac OS X can run on systems with a screen size as small as 800 x 600, but a user may have multiple high-resolution displays. Unless you know that your users will be using a specific display size, it is best to optimize your applications for display at 1024 x 768 pixels.+

    +
    Note: A resolution of 640 x 480 is also available for the iBook and for Classic applications, games, and other multimedia applications. This does not mean that you should assume this is the minimum system resolution, however. Design your user interface for a resolution of at least 800 x 600.+

    Apple just needs to fix it and i suggest post them on their feedback page

  7. 0

    cmaccreery

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Excellent info Th.J.

    I have an 14" iBook that runs 1024 x 768 and a Mac Pro that I run at 1680 x 105 since it has a 22" display.

    Now, if I open windows or an application on the iBook that is actually on the Mac Pro it should not open so large I can't see it. i.e. a finder window on my Mac Pro may be stretched as large as I can get so I can see all the files. When I open it on my iBook it is too large.

    As another poster pointed out you can use the green minimize / maximize button for this or you have to drag the window to the left so you can get to the bottom right corner and then shrink the window.

    That would be fine if it would remember I did that but it continues to open this way each time though not remembering that I resized it.

    A small irritant but nonetheless something I would expect on Windoze not on a Mac.

    Message was edited by: cmaccreery

  8. 0

    JPBLES

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Ashka,

    I can't thank you enough for this simple, but extremely useful information.

    I've been wondering how I could fix this problem, looking it up in the internet and your suggestion was the one that worked best for me.

    Thank you!!!!

  9. 0

    Terrell Smith

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    The above suggestions are good, especially about the green button.

    I also receive Numbers files from users who must have giant screens, because when I open them, the resize triangle is way below my screen, the green button is way off to the left off the screen, and since I cannot raise the sheet higher (it stops at the menu bar), I can't get to the resize triangle. So I drag the whole thing to the right until I can get to the green button and click it.