+ Reply to Thread
Results 1 to 3 of 3

Columns will not scale to one page for print

  1. #1
    Registered User
    Join Date
    05-18-2020
    Location
    Mississippi
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    23

    Columns will not scale to one page for print

    Hello,
    No matter what I do, I cant seem to get this document to fit all columns on one page. I have tried setting width and height in page layout to one page, I have also checked the printer settings to make sure that it is set to all columns fit to one page, but I still cuts off at column J. Does anyone know how to fix this?

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Columns will not scale to one page for print

    I suspect that the various settings are disagreeing with each other in a fuzzy way.

    In Page Layout / Page Setup Panel, Print Area => click "Clear Print Area" button. In Breaks => "Reset all Page Breaks." Make sure you don't have any merged columns, or text boxes overlaid that would confuse things.

    Try setting only Page Layout / Width to one page while leaving Height as Automatic, and Print Scaling to "No scaling."
    Conversely, try setting both Page Layout / Width and / Height to Automatic, while setting Print Scaling only to "Shrink columns to one page."

    If that doesn't help, could you upload a copy of the spreadsheet so we can view & diagnose?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    05-18-2020
    Location
    Mississippi
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    23

    Re: Columns will not scale to one page for print

    The print area and page breaks clearing fixed it. Thanks a lot for the help!

+ 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. [SOLVED] How to scale chart to print on a full page
    By Numcruncher1 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-12-2018, 10:56 AM
  2. [SOLVED] Trying to print three very long columns on one page
    By JTSF in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-09-2018, 03:38 AM
  3. Replies: 3
    Last Post: 09-14-2013, 06:54 PM
  4. Print a 15000 line list of 2 related columns in 4 columns per page.
    By jriver03 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-25-2012, 05:23 PM
  5. How to automatically scale print size of page to one A4 sht
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2012, 01:27 AM
  6. Replies: 1
    Last Post: 04-04-2012, 03:39 PM
  7. Print 2 columns across the page?
    By muppit in forum Excel General
    Replies: 1
    Last Post: 11-30-2006, 07:58 AM

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