+ Reply to Thread
Results 1 to 2 of 2

confusion about how Excel scales pages

  1. #1
    Registered User
    Join Date
    02-23-2017
    Location
    Rocky Mountains, USA
    MS-Off Ver
    2016 for mac
    Posts
    7

    confusion about how Excel scales pages

    I know Excel does not claim to remotely be a page-layout application, but that doesn't mean I still haven't been tasked by a superior to created a nicely formatted, multi-page workbook that will be populated with data and exported as PDF.

    In trying to keep things formatted consistently across tabs (with each tab essentially equating to 1 page), I'm finding that Excel does some weird scaling. In the attached file, even though both tabs have the same Page Layout properties (namely page dimensions and margins) and they're both being viewed at the same zoom level, the scale of the horizontal ruler is different between the 2 of them. IN this case, the 2nd tab's ruler displays as I would expect a view with greater zoom level to, but as I said, the zoom level is the same for both.

    I know the column widths don't all match up between the 2 (and they should - this is what I'm trying to fix and noticed this ruler thing while doing so), but I would think that at the same zoom on pages of the same dimensions and margins, the columns widths would not affect that.

    What am I missing?
    Attached Files Attached Files
    Last edited by daveh0; 01-16-2020 at 01:42 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,770

    Re: confusion about how Excel scales pages

    You have them both set to fit 1 page, which is okay. But they do not have the same number of rows. so scaling is 1% different.
    Remove excess blank rows.
    Also use copy Paste Special, Column widths to set the two pages to same width.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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