+ Reply to Thread
Results 1 to 4 of 4

Problems with Page Setup

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Calgary, Alberta
    MS-Off Ver
    2013
    Posts
    5

    Problems with Page Setup

    I am trying to set up a spreadsheet to print onto an Avery label. I have set my margins and column sizes to the width of the label.
    But Excel splits this into 2 pages even though the combined values (margins plus all columns) are only 8.37 inches. I can't just use the scaling because then it won't line up with the labels.

    I have tried shrinking the column size until it fits on one page, but then it expands to fit (even though scaling and fit are not turned on). So it still doesn't the label.

    I have these settings
    Left margin 0.62"
    Right Margin 0.31"
    Column widths 330 pixels (3.44 inches), 54 pixels (.56 inches), 330 pixels (3.44 inches)

    Why doesn't this work?

    Thanks

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Problems with Page Setup

    Page Layout
    Print Titles
    Page
    Fit to 1 by 1.
    OK

    (Avery also has downloadable templates that align your printed page to the Avery label number.)

    Pete
    Last edited by PeteABC123; 05-26-2022 at 03:28 PM.

  3. #3
    Registered User
    Join Date
    05-05-2015
    Location
    Calgary, Alberta
    MS-Off Ver
    2013
    Posts
    5

    Re: Problems with Page Setup

    Avery does not have Excel templates; they have Word, Powerpoint, PDF and Publisher. Fit to 1 by 1 does not allow me to set the exact size of the cell to match the label.

  4. #4
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

+ 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] VB code to do page setup and find page breaks
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2019, 06:37 PM
  2. [SOLVED] how to insert modified page setup in print setup
    By JEAN1972 in forum Excel General
    Replies: 1
    Last Post: 01-11-2019, 06:02 AM
  3. [SOLVED] need help with page setup/print Setup on a worksheet
    By laurabach in forum Excel General
    Replies: 9
    Last Post: 04-28-2013, 11:44 PM
  4. Page setup, view page in 3 equal sections?
    By JapanDave in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 08:03 PM
  5. Set page setup on chart page when no printer is connected
    By Nicky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-24-2009, 10:13 PM
  6. Page setup problems in Excel 2003
    By CherylD in forum Excel General
    Replies: 1
    Last Post: 01-18-2006, 02:55 PM
  7. [SOLVED] Page SetUp Print Problems
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 02-11-2005, 06:06 PM

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