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.
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
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.
Firstly set print area from Page layout tab then run this macro.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
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
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
wow, I thought I did use alt+enter, but now unchecking "wap text" fixed it, thanks a bunch! :D
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks