Fix Overlapping Excel Text Objects Merging in Acrobat DC
Question details
The user needs to prevent Acrobat DC from merging overlapping text objects in PDFs that were originally created from Excel spreadsheets.
- Product
- Adobe Acrobat DC and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Editing a PDF document in Acrobat DC that was exported from an Excel file containing overlapping text elements.
- Observed behavior
- Acrobat DC partially or completely merges the overlapping text objects during the editing process, making it difficult to reposition them correctly, whereas older versions like Acrobat X kept them separate.
Ensure you have access to the original Excel source file, as resolving PDF text merging issues is most effectively done by correcting the layout before the document is converted.
Correct Overlapping Content in the Excel Source File
The most reliable way to prevent text objects from merging in a PDF editor is to fix the layout in the original Excel file before exporting it.
Acrobat DC uses advanced text recognition to group paragraph blocks, which causes overlapping items to merge. Because Acrobat cannot reliably restore these objects once merged, the best approach is to prevent the overlap during the PDF creation stage.
Launch Microsoft Excel and open the spreadsheet that was used to create the problematic PDF.
Resize your column widths and row heights to ensure that no text spills over into adjacent cells. Alternatively, use the 'Wrap Text' feature.
Click on File > Save As, and choose PDF as the format to generate a new document with properly separated text objects.
Test an Alternative PDF Creation Method
Different PDF export engines interpret text layers differently. Changing the way you generate the PDF might preserve text separation.
Create and Edit PDFs Flawlessly with WPS Office
Avoid complex text merging issues by using WPS Office to manage both your spreadsheets and PDFs. Its built-in PDF converter accurately preserves layout objects, and the WPS PDF editor allows you to precisely reposition elements without unwanted merging.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open your original file. The interface is highly compatible with traditional Excel files.
- 2. Export to PDF safely: Navigate to the Menu, click on 'Export to PDF', and save the file. WPS maintains strict formatting boundaries during export.
- 3. Edit precisely in WPS PDF: Open the newly created PDF in WPS PDF. Click the 'Edit' tab to modify or reposition individual text objects without them merging together.
Frequently Asked Questions
Why does Acrobat DC merge my text objects while Acrobat X did not?
Acrobat DC utilizes an updated text recognition and editing engine designed to group adjacent or overlapping text elements into continuous blocks for easier paragraph editing. Unfortunately, this automated grouping causes overlapping individual objects to merge.
Can I ungroup merged text objects in Acrobat DC?
Once Acrobat DC interprets and merges overlapping text objects during the PDF interpretation or editing process, it cannot reliably separate or restore them to their original individual states.
How do I prevent text from overlapping when converting Excel to PDF?
To prevent overlaps, adjust your Excel column widths to fit the text, enable the 'Wrap Text' feature, or merge cells in the original spreadsheet. This ensures all text is contained within its designated boundaries before you export to PDF.
