Excel to pdf lines too thick. So I think that the only way is to remove the lines by setting the lines to None in Format Cells. This solved the issue for me: Go to More Borders and choose as in the picture. Per IBI Tech support though, if you want actually thin borders in Excel, modify the style via text to use borders=0. But it probably will. When reducing the line thickness (to the line that appears as the first option, thin doted line) appears to solve the thickness issue, but still -unreliable as it does not consider the colour of the line. When I export to pdf the lines are too thick. The lines in the original post i appeared to be too thick -- and that's because they were drawn at the minimum thickness (1 pixel) on a zoomed out screen, and without using Acrobats advanced drawing settings. Replied on January 22, 2023. Please help! Feb 21, 2009 · Aleks, It's not the same problem at all. All of your formatting translates over perfectly in just a few seconds. I paid for it. Please help me Thanks in advance. Microsoft Agent. This issue can be resolved by adjusting the line thickness settings in the Page Layout tab. What is happening is the PDF viewer is enhancing thin lines since sometimes thin lines can just appear blank. Very basic except for using some fill colors to highlight certain sections of the spreadsheet where I want to draw attention. DWG in AutoCAD and the result on . In my case the lines vary in thickness with no discernible pattern. When I convert a page from Excel (or Word) to pdf, the borders of the cells (or tables in Word) are shown in real bad quality in pdf (fine, light lines get thick and clumsy - just ugly). Oct 8, 2023 · When creating a PDF in AutoCAD, the resulting . No signups, no watermarks. Do you have any comment on what I did wrong or where can I fix it? I tried use dotted line instead and it's ok but due to I have to use double line also so that cannot solve my Aug 6, 2014 · Hi! I have created a 3D model and I am converting it into a paper drawing (the Print tag of the attached dwg file). <bottomPen lineWidth="1. Give 6 days ago · How to reconfigure pentable file Engraving outline is displayed improperly (thick line) Creo view drawing text is blocky and too thick inside Drawing template format The Pen table doesn't take the thickness of a pen in unit mm The output PDF lines of the drawings imported from DWG are very thin, and the line type cannot be changed Export PDF Mar 6, 2024 · When an Inventor drawing (IDW) (containing large-scale views) is exported in pdf using default options, the pdf result could be of poor quality because the lines are thick and different types look the same: Note: If the same drawing is printed on paper directly from Inventor, everything is OK. when printing straight to the printer from Excel I get a thin border on Page 1, a double thin border on Page 2 & 3, however in column C, G, and J I get a single thin border. Jan 7, 2021 · I have this same issue, huge pain for contours. The thin line display issue can occur with PDF files created from any vendor. Mar 23, 2021 · Hi, I have used coloured grid lines on my document. Printing to PDF did the wonders, even better than exporting. e they're off the page. Click the "Home" tab from the ribbon and click the "More Borders”. Jan 4, 2021 · When saving an Excel worksheet as a PDF file, the borders of the tables in the file become very thick. 4. I have already tried Page Layout > Margins > 0 all. Just a simple, free online tool to convert XLS to PDF. Kindly see attached screenshot for more details about the issue. You may experience issues when viewing a PDF file containing thin lines. Colors of solid hatches might be incorrectly represented. The border is thinner when I zoom in and Oct 8, 2023 · Some lineweights appear thicker than expected, in a file exported from Revit, when plotted to PDF in AutoCAD. 2. Most time you can leave them as they are, but you can fix them by changing the border styles with the second option as shown below. I am using Powerpoint 16. Here's what I want (screen shot of Excel): And when I export to PDF using the exporter built-in to Excel, here's what I get (screen shot of Adobe Acrobat Reader DC, same results using other PDF viewers): Oct 9, 2013 · My intention - I am trying to convert some excel files to PDF. May 14, 2022 · Changing the line color or using default line color on any cell causes the same line to be displayed in a heavier thickness when saved and displayed in a PDF. Drawing format and boundary. Apr 24, 2013 · When I PDF my Excel tables plain cell borders come out with different thickness, and typically thicker than normal. Convert Excel to PDF online, easily and free. Jul 19, 2017 · Every time I tried to convert an excel file to pdf file this happens the lines go thick when exporting as PDF. Apr 14, 2011 · Dear Adobe. ; Click the Visual Basic icon. Click the "Line Style" and select the style you want from the drop-down list. Previewing the plot shows the same issue. The quality of drawing shapes is ok. I know this is not Adobe's issue because other third party PDF programs will do the same. I am using Acrobat 9. I too faced your issue, like you I use an external application PDF24 creator to convert PDF, So it also makes lines too dark and then I change my Printer to Microsoft, My problem gets solved. Especially in assemblies I have struggled in the past when not all components have the same width set ( our current templates are set to "original") Sep 14, 2018 · I am trying to print pptx to pdf using the print dialog (also tried exporting), but all the thin lines (0. 1. Hope it is clear. Need to convert the Excel worksheet into a . Feb 14, 2022 · Your default settings likely are not correct for the paper you use. When line weights are disabled, you may find that your PDF looks different from your teammates' PDF, your documents print with no line weights, or Dynamic Fill isn't staying within the lines of your document. Revit will always print with assigned line thickness ( in Visibility Graphics ) you can create a new duplicate view, and in Visibility graphics, give all the model and annotation. Nov 20, 2020 · The actual excel file itself now has normal, extra thick, bold, double line, and dotted borders. Lineweights in the drawing are set to a thick width. Apr 11, 2016 · I have an Excel document that I need to save it as PDF but i have an image on the header and the footer that needs to be 100% long in the page. We already run repair the Microsoft office365 and re-install the adobe acrobat reader to the latest version on my pc but still same issue. ; Click Insert, followed by Module. See How to improve resolution when plotting to DWG a viewport in Realistic style Jan 16, 2020 · Here is an illustrative example, from a PDF print copy of the file: The next example shows the same excel file, but on a 2019 iMacPro with Excel for Mac 2019 Version 16. Download the converted file as a PDF. Aug 30, 2024 · When plotting to PDF, printing to a physical printer, or publishing from AutoCAD, object lineweights display thicker, thinner, darker, or lighter than displayed in the drawing. Centerline line font with white color. Such problem is not seen in the dwg file. Is there a way to set the point thickness of the lines, so that they print as I expect them too. Jan 3, 2024 · I have two pdf images of a very intricate mechanical sketch of a part, and the lines on the image are displaying too thick, as if they were in bold. I typically copy excel tables linked into Powerpoint, or just print directly. 17 on Mac. Those files contain some texts with strike through. Users can customize the line weight to their preference to ensure that the lines print with the Feb 6, 2018 · Disabeling line thickness are TEMPORARY. But when they are converted, those lines are not seen in the PDF file. 0" lineStyle="Double"/> </box> But double line border appearing as a solid thick line for pdf generated file but same code creates proper double line in Excel file. Same results if I attempt to export the worksheet. The line weight is so thick that it obscures the details of the drawing. Convert Excel to PDF and set the page orientation as you prefer. The geometry might be interrupted or shifted. 5, and that will give you the thinnest border available in Excel. Done with LWDISPLAY = off, LWT = off. Note: this should be applicable for release 7 onward. Change export options. Mia Zhao MSFT. But problem is lines in the pdf conversion file is very thick and also the text when we zoom inside. Answer. on one, when I press ctrl+5, the lines are displayed properly. Select the table in the Excel worksheet. Moreover, it seems the borders do vary with the level of zoom. I've tried troubleshooting and changing my border options to the smallest dotted line based on previous post suggestions, or going to " Apr 15, 2020 · Try using Microsoft Print to PDF instead of Adobe. This can be caused by the scaling settings in the print options. Mar 29, 2012 · When I export my drawings to a PDF file (Adobe Reader 9) the lines appear a lot thicker than the original when viewing the PDF at the default 100% zoom. PDF show very poor results and the differences arise between the . . Turn your XLS files into high-quality PDFs with our Excel to PDF converter. To set the default printer setup, Open the Devices and Printers dialog. i have done tried all the ways. comments sorted by Best Top New Controversial Q&A Add a Comment. Right-click and set Printing properties appropriately. However numbers on dimensions are now quite badly seen, but lines are fine. Tightened_To_Spec • Additional comment actions Aug 24, 2012 · It would make sense if the three options in Dev Studio corresponded to the three thicknesses in Excel. They look nice and thin on the screen, but when I print my document the lines appear much thicker than they were displayed. So try it once. May 20, 2015 · Hello everyone, I have viewed a number of previous discussions about this topic, and most of them remain unresolved. Brown portion of datum planes. Feb 3, 2022 · When saving an Excel worksheet as a PDF file, the borders of the tables in the file become thick. May 20, 2023 · In this guide, we will walk you through the simple steps to preserve the formatting of your Excel files when converting them to PDF. In this portfolio, there are many drawings with specific line weights. A lineweight override is set for specific Jan 24, 2022 · when i on line weights while plotting the lines become too thick , and when i scale a project which should fit properly in a1 sheet for 1:1000 scale it is coming too small and when i put the scale 2:1 it is fitting , please help me . It’s simple and easy to convert XLSX to PDF using Excel on your Windows computer, you will need to: Open Microsoft Excel and select the Excel spreadsheet you want to convert to PDF. I prefer a lighter cell border so I used a 15% darkness. Excel 365 - Version 2014. Select Microsoft Print to PDF. The Excel View Preference's Window options has "Show in Workbook - Gridlines" checked, with the "Color" set to "Automatic". This is because the appearance of table lines is affected by the limited resolution of the display monitor. May 4, 2020 · Hello, I was trying to print excel file and wonder why the bottom line of excel file when print or save as pdf is not the same as preview. The simplest and straightforward workflow to export Excel chart to PDF is this: Step 1: Open the Excel file containing the graph you would like to convert. Scale lineweights is enabled. The dotted borders might appear more correctly than thin borders because of the way that the display driver approximates the different lines at the effective resolution of the print preview pane. Help, this is driving me crazy! Sep 29, 2019 · Hi, I'm an architectural student, currently working on my portfolio. Is there a way i could get this to create PDFs that look more like my sheet with thin blue In other words lines get thinker when saving as pdf. I am having issues with line weights when printing to PDF. So I took a look at the Print Quality setting (Page Layout ribbon > Page Setup window > Print Quality) and noticed that the print quality was undefined. Right-click, and set Printing preferences, including Advanced, appropriately. Jan 21, 2023 · Thick lines when converting excel into pdf. I have spent way too much time on this already and am hoping someone can help me out here. Watch as Acrobat online services convert your Excel sheet to PDF automatically. 2. 0). May 24, 2017 · Great video Anthony good tip to use the view-visible line setting to override the model thickness. Next time you use PDF printing, the new Oct 9, 2020 · Currently no matter the lines are thin or thick in the table in your Excel file, the lines will be showed as thicker lines in the exported PDF file. I don't have the Pro version, but in Adobe Acrobat Reader you can go to Edit > Preferences > Page Display > Enhance Thin Lines and turn that off to fix this. I have attached the file, and the "print to pdf" output. The printed PDF file comes out with a thin border on Page 1, and thick border on Page 2&3 except for columns C,G, and J. Turning off the anti-aliasing in Acrobat's display preferences (Smooth Line Art/Smooth Images) eliminates these lines. When i convert a document from Word 2010 to PDF by printing to the PDF Maker or by using the built-in "Convert to PDF" option, my underlines appear different thicknesses than when i Oct 19, 2017 · I am using below code to create double line for text box. You can also preserve Excel workbook formatting with May 14, 2019 · It may or not may not appear as intended when you print. Acrobat 4 PDF compatibility (PDF 1. Jun 2, 2024 · Method 3 – Run an Excel VBA Code to Fix Size Problem from Excel to PDF. Tag text . Nov 16, 2023 · Hello, I've had this issue inconsistently occur before. PDF. 33 (20011301). As we are all aware, the thickness of the border lines are converted way thicker in PDF, so a document showing the thinnest continuos line is shown in PDF as a very thick line. The resolution requires adjustment. Make sure that the scaling is set to “Fit All Columns on One Page” or “Fit All Rows on One Page” to ensure that the lines are printed at the correct thickness. pdf file. Aug 4, 2022 · In Excel： Please try to use File>Print>PDF>Save as PDF than File>Export>PDF, File>Print>PDF>Save as PDF produced acceptable results, then to check if the result can be different. How can I adjust the line thickness of the printed file? I am using CutePDF to produce the PDF file. |. When I export to PDF directly from AutoCAD and view the drawings in Adobe Acrobat, the line weights are properly displayed. Click the blue button labeled “Select a file” or drag and drop your Excel sheet into the drop zone. I've tried troubleshooting and changing my border options to the smallest dotted line based on previous post suggestions, or going to "Print" before converting, but it still occurs. Can anyone help me is there any settings that i need to do. 5) in the presentation print very thick (2. family " Line thickness: 1"" Projection Line, and Cut Lines " After this you will get PDF export without thick lines. The line is awfully thicker. 3. Optical illusion Plot lineweights is enabled. Go to AutoCAD Menu/ Export/ PDF / Options. I'm kind of an Excel guru, have used it extensively since it first came on the market. All of my lines are either line weight 0 or 1, I need them to appear slightly different but when I print to PDF the line weight 1 appears very thick and the lines overlap each other. If I increase the zoom to a higher percentage the lines begin to become more in proportion with the original. STEPS: Choose the Excel sheet and navigate to the Developer tab. May 24, 2023 · White or dark lines can be caused by anti-aliasing of an application where the two regions intersect. Nothing fancy used in the spreadsheet. i have attached 2 pics showing the difference when lineweight is on and off. Moderator. Dec 20, 2017 · Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. The line at Excel output: The same line at pdf: Dec 19, 2018 · The only erroneous lines are the 4 lines I indicated with arrows. The first step is to open the Excel file you want to convert to PDF. However when I save it to a PDF I found the lines are too thick that some overlap. I am new to Microstation so am still learning some of the tricks to setting up drawings. Any idea how to make numbers better seen? Can't find it under properties or dimstyle (probably because I have no idea what to look for) Nov 20, 2015 · Line thickness too thick & text spacing issues when printing or PDF (Mac PowerPoint 2016 & Excel 2016) After upgrading from Office 2011 for Mac to Office 2016, in both PowerPoint and Excel the lines which are usually 1/4 point thick end up getting printed or exported to PDF much thicker than 1/4 point. in the table if you don't want the thicker lines. Cross-section cutting plane arrows and text. WEIRD Nov 9, 2009 · Hi all, I have Code which creates PDF for the preferred layout using Adobe PDF. Howevey, you can fix them by changing the border styles . Save Excel Chart to a PDF Page. In some instances, users may notice that the lines printed from Excel appear either too thick or too thin, affecting the document’s overall appearance. HOWEVER, Here's my problem; If To illustrate, I created two columns that are bordering using thin and dotted line styles in colors ranging from black 100% to white 5%. Misalignment and inaccuracy. Thin lines may disappear at different zoom levels. Thicknesses of lines defined in Inventor styles are defined as too large compared to the scale of the Sep 27, 2012 · Just right click on the line itself in the graph and you'll see menu items to adjust the width (along with color, point size, point style, and a bunch of other factors). Feb 24, 2014 · The lines are set to thin, but when i save as a PDF the blue lines are really big, much bigger than even the think option and it looks completely different to my sheet, to get a pdf I'm just going to save as and saving as PDF, i've not touch any setting. And I am referring to texts in a single cell, say, of two or more words, of which one or more word(s) need to be struck through. Basically, when I convert an excel sheet into an adobe pdf, my borders get screwed up (typically thickened). 3) does not support transparency. Nov 20, 2016 · Visible geometry (plot as solid lines, except where noted): Cross-section cutting plane lines: plot as phantom lines. That depends on the resolution and technology of the printer. Jul 13, 2023 · I noticed borders become thicker when converting Excel into PDF on the online Excel platform. Whenever i try to save it in PDF, excel adds a white margin on the sides of the page. Dec 11, 2019 · Same thing here, pdf'ing a Microsoft Excel 365 chart with Acrobat Pro DC, the chart converts at a scale larger than the specified sheet, both Letter and Legal, so that both the right side and bottom of the chart are clipped/cut-off, i. Looks fine in Excel print preview (using MS Print to PDF) but actually printed and viewed, borders are much, much darker. Each time I address one cell a different issue arises and some cells I just cant seem to be able to fix. Letter (yellow) All items plot as solid lines (except where noted Aug 17, 2023 · Hi, We use Excel documents to create technical datasheets that then are converting to PDF for the external use. After analyzing the print previews under the PDF printer and the regular printer, I noticed that the PDF document seemed to be shrinking. I also tried using PDFCreator, printing the document as a PDF files. Read on as we explain, step-by-step, how to extract only charts from MS Excel spreadsheet and save them to a Portable Document Format. Change overrides precision and Merge Control To disable line weights, select View > Disable Line Weights. Jun 27, 2023 · Another common issue with Excel line printing is when the lines appear too thick or too thin on the printed page. Nov 16, 2023 · Basically, when I convert an excel sheet into an adobe pdf, my borders get screwed up (typically thickened). Step-by-Step Guide to Convert Excel to PDF Without Losing Formatting Step 1: Open the Excel file you want to convert. When to enable line weights. knecjvriywyfdhjzboelpufushzfjqabhicvmkuyfarqznrddilj
