If Excel is not pasting all the cells you copied, copy the full source range again, click only the top-left cell of the destination, and press Ctrl+V. If the result is still incomplete, check whether the source or destination is filtered, contains merged cells, or is using a paste option that excludes the content you expect.
Start with a quick check of the selection
Many apparent paste failures begin with a smaller source selection than intended. Before copying, look at the highlighted outline and the Name Box to the left of the formula bar: it shows the selected cell or range. For example, if you mean to copy A1:D20 but the Name Box or outline shows A1:C20, the last column was never included in the copied range.
Try this simple test in a blank area of the same workbook:
- Select the intended source range, including its first and last row and column.
- Press Ctrl+C on Windows, or Command+C on a Mac.
- Click one destination cell at the upper-left corner of where the copied block should go.
- Press Ctrl+V on Windows, or Command+V on a Mac.
Clicking one cell is usually safer than selecting a destination block first. Excel can size the pasted block from the copied range. If you select a destination range with a different shape, the paste may be rejected or may not behave as you expected. Also check that the moving dashed outline remains around the copied source until you paste; pressing Esc cancels copy mode.
Confirm what Excel actually copied
Excel copies cells, not just the words visible on the screen. A copied cell can contain a value, a formula, formatting, validation, or a combination of these. If you select a range and the clipboard outline encloses fewer rows or columns than expected, adjust the selection and copy again. When the source contains separate, nonadjacent ranges, Excel treats that selection differently from one solid rectangle, and some destination layouts will not accept it as a single paste.
Check whether the missing cells are genuinely absent or merely look blank. Select one of the affected destination cells and inspect the formula bar. A formula may have pasted correctly but return an empty string, or a cell may contain a value that its number format or font color makes difficult to see. If the formula bar contains the expected content, the issue is display or calculation rather than an incomplete copy.
When copying between workbooks, keep both workbooks open in Excel and use the normal copy and paste commands. If you copy from a web page, PDF, or another application, the clipboard may hold text or a table representation rather than Excel cells. Tabs and line breaks often determine how pasted text is divided among cells, so the layout can differ from the original page.
Check filters and hidden rows or columns
Hidden or filtered cells are a common source of confusion. By default, copying a range in Excel can include cells in hidden rows or columns, including rows hidden by a filter. That means the pasted block may contain more items than the visible source suggests. Conversely, if you intended to copy every underlying row but judged the selection only by what was on screen, it may seem as though Excel selected the wrong records.
To copy only the visible cells in a selected range on Windows, use Home > Find & Select > Go To Special, choose Visible cells only, and select OK. Then copy and paste. The Windows shortcut Alt+; selects visible cells only after you have selected the range. On a Mac, use the Go To Special options available in Excel’s menus; shortcuts can differ by version and keyboard layout.
Pasting into a filtered destination needs extra care. A normal rectangular paste can affect cells that are not currently visible, and a visible-cells-only selection can consist of separate areas rather than one continuous block. If it is important to update only filtered records, test on a small range or copy the filtered results to an unfiltered helper area, make the changes there, and verify the row alignment before replacing data. Do not assume that what is visible on screen is the only content being changed.
Look for merged cells and mismatched shapes
Merged cells combine several grid cells into one displayed area. They can make a source or destination range a different shape from what it appears to be, and Excel may refuse to paste a block into a destination with an incompatible merged-cell layout. A warning about merged cells, or a paste that stops at an unexpected point, is a reason to inspect the selection for merged areas.
On the Home tab, check the Merge & Center control in the Alignment group. If merging is not needed, unmerge the relevant destination cells and try again. Be aware that unmerging does not restore values that were discarded when cells were merged: a merged area keeps the value from its upper-left cell. Make a copy of important data before changing a layout with merged cells.
Also compare the dimensions of the source and destination. Copying a 4-column by 10-row block into a destination area containing merged cells or an oddly sized selection can cause an error even though the source copy itself is complete. For a clean test, choose a single empty destination cell on an ordinary, unmerged part of the sheet.
Choose the right paste option
Excel’s paste choices can make a successful paste look incomplete because each option carries different parts of a cell. The standard Ctrl+V paste brings over the copied cells with their content and formatting. The Paste Special choices can instead transfer only values, formulas, formatting, or other supported attributes.
On Windows, open Home > Paste to see the paste options, or use Home > Paste > Paste Special for the dialog. On a Mac, use the Paste options on the Home tab or the Edit menu; the exact shortcut combinations for Paste Special differ from Windows. If you want to preserve everything, use the ordinary paste first rather than choosing Values or Formulas.
For example, if a copied cell contains the formula =A1+B1, choosing Values pastes the calculated result rather than the formula. If you choose Formulas, the formula is transferred, but the destination may display a different result because its relative references adjust to the new location. To diagnose a suspected partial paste, use ordinary paste into a blank area, then inspect both the formula bar and the formatting of the affected cells.
Check protection, table structure, and workbook limits
A protected worksheet can allow selection while preventing edits to locked cells. This usually produces a protection warning or blocks the paste rather than silently removing selected source cells. If Excel refuses to change the destination, check Review > Unprotect Sheet, if you have permission and the required password. Do not try to bypass protection; ask the workbook owner to authorize the change.
Excel tables can also behave differently from plain ranges. A table has a defined header and data area, and pasting across its boundaries may expand the table, affect calculated columns, or conflict with existing content. If the pasted rows do not line up with the table’s records, confirm the headers and destination columns before pasting. For a controlled test, paste a few rows into an empty worksheet area and compare the result.
Excel worksheets have a maximum size of 1,048,576 rows by 16,384 columns. A destination that extends past those boundaries cannot contain the entire copied range. More commonly, a very large operation is delayed by a busy workbook, complex formulas, or limited available memory. Wait for Excel to finish responding before repeating the paste, since retrying repeatedly can create duplicate or conflicting changes.
Use a dependable troubleshooting sequence
When the cause is not obvious, work from a simple test toward the original layout. This makes it easier to distinguish a clipboard problem from a filter, formatting, or destination issue.
- Save the workbook, especially before changing a large or important range.
- Copy a small, ordinary rectangular range and paste it into a blank sheet in the same workbook.
- If that works, repeat with the full source range and compare the selected outline with the intended boundaries.
- Try the full paste in a blank area before pasting into a filtered, merged, protected, or table-based destination.
- Inspect cells that look missing in the formula bar, then check filters, hidden rows, and formatting.
- If the small test fails too, close and reopen the workbook, then retry the standard copy and paste commands.
If the paste succeeds in a blank area but not in the intended destination, the source copy is probably fine; investigate the destination’s layout or permissions. If the test fails across destinations, check whether you are copying from another application, whether copy mode was canceled, or whether Excel is still processing another task.
Prevent incomplete-looking pastes
A few habits reduce surprises. Select the range from its first cell to its last rather than relying on a visual estimate, particularly when rows or columns are hidden. Use a blank, unmerged destination for an initial test. When working with filtered lists, decide whether you need all underlying rows or only visible records before copying, and use Visible cells only when that is the intention.
For important updates, retain a backup copy and verify a few cells at the top, middle, and bottom of the pasted block. Check formulas as well as displayed values if formulas matter. If the data comes from an external application, paste a small sample first to see whether it separates into columns as expected. These checks take less time than repairing a large range pasted into the wrong rows.
Frequently Asked Questions
Why does Excel paste only one cell?
A one-cell paste often means only one cell was copied, or the copied content came from another application as a single text item. Recheck the source outline, copy a small rectangular range directly in Excel, and paste into one destination cell.
Does Excel copy hidden rows when I copy a range?
By default, Excel can include hidden and filtered-out cells in the copied range. To copy just the visible cells on Windows, select the range and use Home > Find & Select > Go To Special > Visible cells only before copying.
Why do some pasted cells appear blank?
The cells may contain formulas that return an empty result, or their formatting may hide the displayed value. Click a supposedly blank cell and check the formula bar. Also review number formats, font color, and conditional formatting.
Why will Excel not paste into merged cells?
The destination’s merged areas may not match the shape of the copied range. Use an unmerged destination if practical, or adjust the layout before pasting. Remember that unmerging retains only the merged area’s upper-left value.
Can I paste into filtered rows without changing hidden rows?
Do not assume that a regular paste will affect only the rows visible on screen. Filtered ranges can involve hidden records and separate visible areas. Test with a small sample, use visible-cells-only selection when appropriate, and verify the affected row positions before updating a full list.
Related
- Convert PowerPoint to Excel: Steps, Options, and Limits
- Access Database Import from Excel: Steps and Tips
- Excel Attendance Format: A Clear Monthly Attendance Tracker
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text Direction: Change Cells and Sheet LayoutIn Excel for Microsoft 365 on Windows, change the direction of text in a cell by opening Format…
- How to Hide the Top Bar in Excel and Restore It QuicklyIn Excel for Microsoft 365 on Windows, hide the top bar by opening Ribbon Display Options near the…
- Make a Brochure in Microsoft Word Online and DesktopYes. You can make a brochure online in Word for the web by starting with a brochure template…
- Excel Text to Value: Convert Numbers Stored as TextTo turn numeric text into a real Excel number, select the cells and choose Convert to Number from…
- How to Insert a Checkbox in Word Online for ChecklistsTo add clickable checkboxes in Word Online, open the document, go to Home, and choose Checklist in the…
- Insert a Checkbox in Word: Shortcut and OptionsIn Microsoft Word for Windows, type 2610 and press Alt+X to insert an empty checkbox (☐); use 2611…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.