+ Reply to Thread
Results 1 to 3 of 3

row height/width auto adjusts when I move print margins trying to print in center of page

  1. #1
    Registered User
    Join Date
    02-25-2016
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    2

    row height/width auto adjusts when I move print margins trying to print in center of page

    hello
    wondering if anyone can help a noobie out please.

    I have a workbook I created for work that has approx 50 pages and each page has a document with multiple set row heights (not all the same height)
    when I print a page, the document page prints to the top of the page regardless of the margin size I set AND regardless of whether I have center vertically/horizontally checked when I print.
    ALSO if I try and adjust that print margin height for some ungodly reason it changes all my ROW heights in my document page ( kinda like its trying to adjust and auto fit the print page)
    Its really really annoying and I have tried everything I can think to stop it happening. I've also tried swapping printers ...to no avail.
    If anyone can please explain to me how I can SAVE my document page row heights and widths so they will NOT alter even if I play about with the actual margins to center the document when printing I will be super grateful.
    I hope I have explained this clearly enough.
    I am using excel 2007

    thanks in advance
    D

  2. #2
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: row height/width auto adjusts when I move print margins trying to print in center of p

    It sounds like all you need to do is set Page Breaks. Go to View on the Ribbon, then select "Page Break Preview". You'll see a bunch of blue dotted lines - these are where your printer will start printing on a new page. You can add, remove, and move Page Breaks as you need.

    Hope that helps!

  3. #3
    Registered User
    Join Date
    02-25-2016
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    2

    Re: row height/width auto adjusts when I move print margins trying to print in center of p

    no dice><
    I guess to reiterate the main issues are I cant print in the center of may page; for example if I put margins for top and bottom at .5 and the sides at .6 you would be forgiven for assuming the actual body of the document I then create would print evenly between those margins but what happens is a/ it prints for example .2 from top 1.5 from the bottom and evenly .13 from each side(which is clearly ignoring the margins i set in the first place) AND 2/ as it prints it alters every single row height and width of my document ( for no apparent reason I can figure out)thus skewing my page layout and making it impossible to print double sided and bind the entire workbook.
    and I do not understand how to make it stop.
    my document is within the lines your referring to AstToTheRegionalMGR
    any other ideas?

+ 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. Excel will not print images at correct height/width!!
    By vigilantezack in forum Excel General
    Replies: 25
    Last Post: 07-04-2022, 07:45 AM
  2. [SOLVED] VBA code to set out page print layout - height automatic
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2013, 03:22 AM
  3. How to decrease margins/increase print area on page
    By Excelhelpfordebbie in forum Excel General
    Replies: 0
    Last Post: 07-15-2010, 09:45 PM
  4. macro to adjust print margins in print preview mode
    By yeoye in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 06:16 AM
  5. Replies: 8
    Last Post: 02-02-2009, 04:21 PM
  6. [SOLVED] How to print fitted 1 page width and 1 page tall
    By SupperDuck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2006, 04:40 PM
  7. Replies: 1
    Last Post: 12-05-2005, 12:00 PM
  8. [SOLVED] how to move header and footer within print margins excel
    By Rohit in forum Excel General
    Replies: 2
    Last Post: 05-04-2005, 12: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