+ Reply to Thread
Results 1 to 2 of 2

Row Size changes with changes in Screen Display Settings

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Row Size changes with changes in Screen Display Settings

    Background Info
    Excel 2010
    MS Windows 7 Enterprise
    Monitor Resolution 1600 X 900


    The attached workbook is a 2 page extract of a photo report. In practice, such report would comprise of several pages (typically between 30 to 50, depends on the number of photos in the report). The template is designed to have 2 photos on each page, with a photo number and description under each image. The remaining rows are blank, just to provide spacing; and this comes to a round 10 rows per A4 page. The report is populated by a macro that inserts these images from a directory location and copies description text from elsewhere in the workbook. The macro resizes the image height to match the row height, the image width is changes automatically as it maintains the aspect ratio.


    Observations
    When I change the screen display settings under Control Panel\Appearance and Personalization\Display, I observe:
    1. Smaller 100% (Default)
      Excel shows that the row height is 8.47 cms / 240 points / 320 pixels, depending on the view (Normal / Page Layout / Page Break Preview).
      When I print this on an A4 page (No Scaling, 100% of the original), the actual row/image height is only ~ 8.2 cms.
      It fits the 2 photos. 10 rows to a page neatly as is the intended purpose of the template.
    2. Medium 125%
      Excel shows that the row height is 8.47 cms / 240 points / 400 pixels.
      When I print this on an A4 page (No Scaling, 100% of the original), the actual row/image height is ~ 8.5 cms.
      It no more fits the 2 photos, 10 rows to a page.
    3. Larger 150%
      Excel shows that the row height is 8.47 cms / 240 points / 480 pixels.
      When I print this on an A4 page (No Scaling, 100% of the original), the actual row/image height is ~ 8.5 cms.
      It no more fits the 2 photos, 10 rows to a page.

    The 3 different display outcomes can be seen in the attached PDF files. I've also tried this with another monitor (screen resolution 1920 X 1080), but the results remain unchanged.

    Issue
    This report moves back & forth between a few users who prepare, review and verify it. They have different display preferences. How do I ensure that the row / image height remains unchanged, and the that the final report prints nicely, with 2 photos to a page as can be seen in the Smaller 100% PDF.

    As a follow up, I'd like to learn what is the unit of measurement to determine/record Row Height in Excel?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Row Size changes with changes in Screen Display Settings

    Has someone come across something similar with Row Heights / Column Widths? Pls share your experience.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change font size and page zoom settings after pasting
    By Ghostmonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2016, 05:27 AM
  2. VBA print to pdf - page size settings
    By m.cain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 12:40 PM
  3. Splash screen for macro security settings
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2010, 07:09 AM
  4. Screen size
    By tony.nz in forum Excel General
    Replies: 15
    Last Post: 12-09-2009, 06:13 AM
  5. How Do I Autofit To Screen Size
    By tweacle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2006, 04:20 PM
  6. vb code Screen size
    By Jim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2005, 11:56 PM
  7. Replies: 2
    Last Post: 06-07-2005, 02:05 PM

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