Merged cells are one of the most common ways a PDF table lands in Excel looking right but behaving wrong. A date that spans four rows, a header that stretches across three columns, a category label that covers a block of transactions: in the PDF these read fine, but once they become merged cells in Excel they break sorting, filtering, pivot tables, and almost every formula you try to run. This guide explains why it happens, how to convert so it does not happen in the first place, and how to clean up merged cells you already have.
Why does converting a PDF create merged cells in Excel?
Merged cells appear because the converter is copying the PDF's visual layout instead of rebuilding a real data grid. In a PDF, a label that visually covers several rows or columns is just text positioned over an area, with no rule that says which cell owns it. A layout-faithful converter mirrors that by merging the matching cells, which looks like the original but is not a clean table. A data-first converter instead assigns the value to one cell and leaves the rest as proper, separate cells, which is what Excel needs for sorting and math.
Why are merged cells a problem in Excel?
Merged cells block the features that make a spreadsheet useful. You cannot sort or filter a range that contains merged cells without Excel throwing an error or scrambling the rows. Pivot tables refuse merged source data. Formulas like SUM, VLOOKUP, and XLOOKUP misread merged ranges because only the top-left cell holds the value and the rest are empty. Even selecting a single column becomes awkward. For any table you plan to actually work with, unmerged, fully populated cells are the only reliable starting point.
How do I convert a PDF to Excel without merged cells?
Use a converter that rebuilds the table as a real grid rather than reproducing the PDF's appearance. Upload your file to the PDF table extractor at the top of this page and it detects the rows and columns, places each value in its own cell, and keeps numbers numeric so a column totals on the first try. Download the result as XLSX or CSV. CSV is worth noting here: the format has no concept of merging at all, so exporting to CSV guarantees a flat grid, though you lose any styling. Starting from a clean conversion saves the cleanup steps below entirely.
How do I unmerge cells and fill in the blanks?
If you already have a sheet full of merged cells, the fastest fix is unmerge then fill the gaps. Select the affected range and click Merge and Center on the Home tab to unmerge everything, which leaves the value only in the original top-left cell and blanks below it. Then select the range again, go to Home, Find and Select, Go To Special, and choose Blanks. With the blank cells selected, type an equals sign, press the Up arrow, and press Ctrl and Enter together. Every blank now repeats the value above it. Finally, copy the range and use Paste Special, Values to replace those formulas with plain text.
How do I unmerge and fill cells using Power Query?
For large tables or a step you want to repeat, Power Query is cleaner. Load the data through Data, Get Data, From Other Sources, or just select the range and choose From Table or Range. In the Power Query editor, click the column that has blanks where the merges were, then on the Transform tab choose Fill, then Down, which carries each value into the empty rows beneath it. Close and load back to a sheet. Because the query is saved, refreshing it re-applies the same fill the next time you bring in a similar file, which beats redoing the manual steps every month.
How do I stop Excel from merging cells when I paste from a PDF?
The merges usually come from the source, not from pasting, so the real fix is to change how you get the data in. Copy and paste from a PDF reader tends to drop everything into one column or carry over the visual blocks, both of which create messy, merged-looking results. Converting the PDF properly avoids that. If you must paste, paste into a blank sheet, then use Home, Merge and Center on the whole selection to clear any merges before you start work, and run the Go To Special, Blanks fill if values are missing. A clean conversion is faster than fighting paste behavior.
Why do some converters keep merging cells and others do not?
It comes down to whether the tool optimizes for looking like the PDF or for being usable data. Free open-source tools such as Tabula rely on you drawing the table region by hand, and they struggle when a header spans multiple columns, often misplacing the values below a merged header. General PDF editors lean toward visual fidelity, so they reproduce merges. A converter built specifically for getting tables into a spreadsheet treats the merge as something to resolve, assigning the value to one cell and keeping the rest separate, which is why the output drops straight into a pivot table or formula without cleanup.
What about merged headers across multiple columns?
Multi-column headers are the trickiest case because the data below them often inherits the wrong column. A quarter label sitting above three monthly columns, or a Debit and Credit pair under one Amount banner, needs the converter to understand the column grouping rather than just copy the visual span. After conversion, check that the first data row lines up under the right headers, and if a banner header was flattened, retype it as individual column names. For invoices, which almost always have merged-cell headers over line-item tables, a tool aimed at extracting invoice data to Excel handles those layouts more reliably than a generic converter, and a scanned invoice can go through invoice OCR first so the text is readable before the table is rebuilt.
Convert once, cleanly
The best way to avoid merged-cell headaches is to never create them. Convert the PDF with a tool that rebuilds a real grid, verify the first few rows line up under the right headers, and reach for the unmerge-and-fill steps only on files that arrived messy. For tables you receive every month, save a Power Query step so the fill is automatic. Try the converter at the top of this page on a document that has been giving you trouble, and compare a clean XLSX against the merged mess you have been editing by hand. For more on layout issues, see copying a table from PDF to Excel without losing columns and the broader PDF to Excel formatting problems guide.