+ Reply to Thread
Results 1 to 5 of 5

Screen formatting tips and tricks?

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    11

    Screen formatting tips and tricks?

    I'm building a workbook presentation on a 1920x1080 screen. I'm going to be giving this presentation on a 1024x768 projector, and I want to format my entire workbook to perfectly fit this resolution and fully utilize the entire screen. Most of the searches I've done on this topic have to do with running a VBA to assess different setups' screen resolution and adjust the zoom; I don't want this. I know what the target resolution is, I just want to know if any of you have any tricks to use as 'border guides' from worksheet to worksheet. I've tried manipulating page breaks, print areas, etc, but these are always beholden to edge of the last 'printable' column/row, which is itself dependent on the width/height of all the other cells in the printable space... and each worksheet is different.

    What do you all do to make sure the dimensions of each worksheet look perfectly flush, within the confines of a target screen resolution, when switching from sheet to sheet?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Screen formatting tips and tricks?

    can't you alter your screen resolution to match the target one while developing?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Screen formatting tips and tricks?

    I can, but (1) so much blurrier and difficult to use fine mouse movements, and (2) by default Windows stretches the screen instead of letterboxing it; so my eyes start bleeding. Is there any way to create virtual borders so that I can work at my screen's native resolution?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Screen formatting tips and tricks?

    I thought it might be hard to use as that's quite a difference in resolution.

    You could simply resize the application window using application.width and application.height - non-maximized window of course ;-)

  5. #5
    Registered User
    Join Date
    08-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Screen formatting tips and tricks?

    Quote Originally Posted by JosephP View Post
    You could simply resize the application window using application.width and application.height - non-maximized window of course ;-)
    I think I'll just do this. I'll work with a maximized window because I do a lot of noodling in the blank cells while building a sheet, but I'll create a VBA button that automatically re-sizes the application window down when I need to check it.

    Thanks for your help, Joseph.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1