+ Reply to Thread
Results 1 to 7 of 7

Print Preview different than original document

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Foulfell
    MS-Off Ver
    Excel 2013
    Posts
    5

    Print Preview different than original document

    Hello,

    I have an excel document, I have made one cell very big and have typed text into in and formatted it to be on three lines/paragraphs, but when I click "Print Preview" the text is a little different - one line is moved out of center and it prints that way, while on the original document/file it remains as it should.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Print Preview different than original document

    If possible please share both the screens Screeshot to get a clear picture


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-23-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Print Preview different than original document

    Try print area to set the area for printing .
    Given the code for setting print area and print preview. Assign this macro to a print button.
    Sub Print_Sheet()
    '
    ' Print_Sheet Macro
    Set Sh = ActiveSheet
    Set range1 = ActiveSheet.Range("Print_Area")
    With Sh.PageSetup
    .Zoom = False
    .FitToPagesWide = 1
    .FitToPagesTall = 1
    End With
    range1.Printpreview

    End Sub
    Firstly set print area from Page layout tab then run this macro.

  4. #4
    Registered User
    Join Date
    02-05-2014
    Location
    Foulfell
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Print Preview different than original document

    Sixthsense , oh sorry, didn't think of that :D

    reality, what is actually seen on screen:

    actual.jpg



    print preview:

    print preview.jpg



    tanvi_kalra, thank you but is this a fix, a workaround or something else? :D

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Print Preview different than original document

    Instead of using Wrap Text Use Alt+Enter to separate the lines inside the cell.

    Because Wrap Text will auto align the text which may be the root cause of this problem

  6. #6
    Registered User
    Join Date
    02-05-2014
    Location
    Foulfell
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Print Preview different than original document

    wow, I thought I did use alt+enter, but now unchecking "wap text" fixed it, thanks a bunch! :D

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Print Preview different than original document

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. page break preview vs print preview do not match
    By chadgar24 in forum Excel General
    Replies: 1
    Last Post: 05-16-2012, 11:32 AM
  2. Excel 2010 print/print preview error for combo boxes
    By dlmcdan in forum Excel General
    Replies: 3
    Last Post: 03-23-2011, 12:32 PM
  3. VBA Macro shows Print Preview page: How to auto-maximize the Print Preview?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2010, 04:48 PM
  4. Print Preview Doesn't Match Page Break Preview
    By mik7585 in forum Excel General
    Replies: 0
    Last Post: 06-01-2009, 11:32 AM
  5. [SOLVED] cell borders that I create dont show on print preview or print
    By scott3435 in forum Excel General
    Replies: 2
    Last Post: 04-05-2006, 09:40 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