+ Reply to Thread
Results 1 to 14 of 14

Excel Cells not viewing properly in PDF format.

  1. #1
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Excel Cells not viewing properly in PDF format.

    Hi Friends,

    I am using some below excel with wrap text. in Excel document its showing correctly, but when I am trying for PDF then some line are not coming properly. Please see attachments for better understanding. Some cells using extra space at the bottom. Some cells not coming in to box at the bottom.

    Thank you.
    Attached Files Attached Files
    Last edited by rajeshn_in; 03-27-2018 at 07:10 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Excel Cells not viewing properly in PDF format.

    here is a print (Lines Problem) and save as (Copy of Lines Problem)

    what is wrong with these two?
    Attached Files Attached Files
    Last edited by sandy666; 03-27-2018 at 07:25 PM.

  3. #3
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    Hi sandy,

    Some cells have extra space at the bottom

  4. #4
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    In my pdf some cells not showing properly.
    Attached Files Attached Files

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel Cells not viewing properly in PDF format.

    Ah so, but this is better then cutted text at the bottom

    Ok, I'll check

  6. #6
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    Actually, cutted text or extra line, these two are not allowed, please send me the solution

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Excel Cells not viewing properly in PDF format.

    I give up with Excel - this is not a text editor so better to use is MS Word, no problem with cutted text and additional lines,
    Option for save as pdf exist
    Attached Files Attached Files
    Last edited by sandy666; 03-27-2018 at 09:23 PM.

  8. #8
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    Is there any way to do in excel, because these all are contractual terms coming based on formulas and have some letterhead and page layouts.

  9. #9
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    I cant use word for this.

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel Cells not viewing properly in PDF format.

    sorry mate, pdf is not native format for Excel

    or you agree with the bottom white lines, or you manually modify the height of the cell or you have a big problem
    You can try VBA but I can not help you with this

  11. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Excel Cells not viewing properly in PDF format.

    Ok, I don't want to waste my time more than is needed

    You can play with font type, size, width of print area but every time if you change something unwrap and wrap again
    (CF) and (LF) are removed - I hope
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    Hi friends,

    I have posted the same issue in below web site just now, I didn't get solution, thats way I am posting there. Please consider my apology if it is wrong.

    https://www.ozgrid.com/forum/forum/h...-in-pdf-format

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,718

    Re: Excel Cells not viewing properly in PDF format.

    That's fine, as you have provided a link - thank you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  14. #14
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Excel Cells not viewing properly in PDF format.

    Hi friends,

    Any solution !

+ 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] Cannot get Excel to properly format a date time graph
    By filky in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-03-2017, 11:43 AM
  2. How to properly format IF/THEN
    By sos4excel in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-04-2014, 12:05 PM
  3. [SOLVED] Extracting data from one table format and putting into a different viewing format
    By BeachRock in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2014, 05:55 PM
  4. View of Cells properly as per saved format
    By thilag in forum Excel General
    Replies: 1
    Last Post: 02-03-2013, 11:53 AM
  5. Properly format names and addresses within a file in Excel 2010.
    By epilf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 09:00 PM
  6. Replies: 1
    Last Post: 05-30-2006, 10:10 AM
  7. [SOLVED] viewing cells in excel 2000
    By Ewa in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-03-2005, 07: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