If Excel is not copying and pasting all your data, first check whether a filter, hidden rows, or an incomplete selection is excluding cells; then copy the exact source range again and use Ctrl+C and Ctrl+V on Windows. If the destination still looks incomplete, check paste options, merged cells, protection, and whether the source range is larger than the destination.
Why Excel may appear to leave data out
Copying a range transfers more than the words and numbers you see. Excel can copy formulas, formatting, hyperlinks, comments or notes, and other cell properties. What appears at the destination depends on the cells selected and the paste method used. For example, Paste Values transfers calculated results rather than formulas, while ordinary paste generally brings formulas and formatting along too.
It also matters which cells are included in the selection. A filter can make rows disappear from view, a manually hidden row can be hard to notice, and a selection made by dragging can stop short of the final row or column. On the other hand, a paste may succeed while only part of the result is visible because the destination sheet is filtered or scrolled elsewhere.
Before changing settings, identify what is missing: entire rows, certain columns, formulas, formatting, or just the visible contents of cells. That distinction often points directly to the cause.
Check the selected range and copy method
Look at the highlighted outline before copying. Confirm that it covers the first and last rows and columns you intend to transfer. If you drag to select a large range, it is easy to release the mouse a row early or omit a column at the edge.
For a precise selection, click the Name Box to the left of the formula bar, type a range such as A1:D200, and press Enter. This selects those cells without relying on a long drag. You can then copy with Ctrl+C and paste with Ctrl+V. On a Mac, use Command+C and Command+V.
Ctrl+A does not always mean the whole worksheet. In a block of connected data, it typically selects the current region; in an Excel table, it selects table content, and pressing it again can change the selection. If you need the entire sheet, use the Select All button at the corner where the row and column headings meet, but avoid copying a whole sheet when only a defined data range is needed.
- Check the selection outline for the correct last row and column.
- Use the Name Box for a known rectangular range.
- Make sure you are copying cells, not a chart, text box, or other object selected on the worksheet.
- After copying, click a single destination cell unless you specifically need to paste into a matching range.
Filters and hidden rows or columns
Filtered data is a frequent source of confusion. A filter hides rows that do not meet its criteria; it does not delete them. When you copy filtered data, Excel commonly copies the visible cells in the filtered range, but manually hidden rows and columns can behave differently. A pasted result may therefore seem incomplete if you expected every underlying record.
If you want only the records currently visible after filtering, keep the filter in place and check the copied result. If you want every record, clear the filter using Data > Clear, or open the filter menu and choose the option to clear that column’s filter. The exact filter menu depends on the worksheet layout. Clearing a filter shows rows again; it does not remove the filter controls.
For a selection containing manually hidden rows or columns, choose visible cells explicitly when that is the intended result. In Excel for Microsoft 365 on Windows, select the range and use Home > Find & Select > Go To Special > Visible cells only, then copy. The shortcut Alt+; also selects visible cells only in Windows Excel. Excel for Mac has different shortcut behavior and menu arrangements across versions; use its Go To Special command if available rather than assuming the Windows shortcut works.
To copy hidden data as well, unhide the rows or columns first. Select the row or column headings on either side of the hidden area, right-click, and choose Unhide. If a row is hidden by a filter, clear the filter instead. These two kinds of hidden data are controlled differently.
Paste options can change what arrives
When the copied cells contain formulas, standard paste normally transfers the formulas and adjusts relative references for the new location. If you choose Values, Excel pastes the displayed results, not the underlying formulas. This is useful for a fixed snapshot, but it can look as though some data or calculations were lost if you expected formulas to remain editable.
After copying, use Home > Paste to view the available paste choices, or right-click the destination and select a paste option. Common choices include keeping source formatting, matching destination formatting, pasting formulas, and pasting values. Options can vary with the source, destination, and Excel version. If an ordinary paste behaves unexpectedly, try a standard paste into a blank worksheet first; that helps separate a source-selection issue from a destination-format issue.
Also check whether you copied a whole row or column but selected a smaller destination area. Excel may adjust the paste or report that the copied area and destination are different sizes. For a rectangular block, click only the upper-left destination cell and paste; Excel fills the corresponding area. If you deliberately select a destination first, make sure it has compatible dimensions.
Merged cells, protection, tables, and spill ranges
Merged cells can interfere with rectangular copying because a merged area does not behave like a set of ordinary individual cells. If Excel reports that merged cells must be the same size, or the paste is blocked, inspect both ranges for merged cells. Use Home > Merge & Center to review or change merging, and consider unmerging cells before moving a large data block. Unmerging keeps the value in the upper-left cell; it does not recreate values that were never stored in the other cells.
A protected worksheet may allow selection but prevent pasting into locked cells. Check Review > Unprotect Sheet; if the sheet is protected with a password, you need the password or permission from the workbook owner. Protection is separate from workbook encryption and is not a reason to try to bypass access controls.
Excel tables have their own structure. Pasting into a table can extend it or apply a calculated-column formula throughout the column. That may make the pasted results appear to change, even though Excel has applied the table’s consistent formula behavior. Dynamic array formulas can also occupy a spill range: the formula is in one cell, and its results fill neighboring cells. Pasting into cells that the formula needs can produce a spill error or prevent the paste. Check whether a destination cell belongs to a table or an existing spill range before replacing it.
When only some data types seem missing
If the text and numbers arrive but the appearance does not, the issue is probably the paste type rather than the copied range. Use a paste option that includes formatting, or use Format Painter when you only need to reproduce the appearance. Conversely, if you need clean data without source colors or borders, paste values or match the destination formatting.
If formulas become numbers, confirm that you did not choose Paste Values. If formulas arrive but show different answers, inspect their references: relative references can shift during a normal paste. This is expected behavior, not necessarily lost data. You can inspect a cell’s formula in the formula bar. If a formula refers to another sheet or workbook, make sure that referenced source is still available.
For dates, decimal values, or long numbers that look changed, check the cell’s number format and the formula bar. A value may be present but displayed differently—for example, a narrow column can show number signs, and a date format can display a serial value as a calendar date. Widen the column or choose an appropriate number format before concluding that the underlying value is missing.
Clipboard, workbook size, and practical troubleshooting
If copying stops working across Excel, test a small range in a new blank workbook. If that works, the problem is likely specific to the original selection, sheet, or destination. If it does not, try copying and pasting with the ribbon or right-click menu, then save the workbook and restart Excel. Another application or a remote desktop session can affect the Windows clipboard, so close unnecessary clipboard utilities and check whether ordinary text can be copied between applications.
Excel worksheets have a maximum of 1,048,576 rows and 16,384 columns. A destination cannot hold a range that extends beyond those worksheet limits. Large workbooks can also be slow to copy, especially when they include extensive formatting, formulas, or objects; wait for Excel to finish before repeating the command, since repeated pastes can create duplicates.
Use this sequence to narrow the problem without risking the original data:
- Save the workbook, preferably with a new name if the data is important.
- Clear filters or unhide rows if you need all records, and inspect the selected range.
- Copy a small sample to a blank sheet to see whether the basic operation works.
- Try a normal paste, then the specific paste option you need, such as Values or Formulas.
- Check for merged cells, sheet protection, table behavior, and spill ranges if the destination blocks or alters the paste.
In Excel for the web, copying between worksheets or browser tabs may also depend on browser clipboard permissions and the browser’s handling of selections. If a paste fails there, try the Excel ribbon commands, confirm the browser permits clipboard access, or open the workbook in the desktop app if it is available. Menu wording and some capabilities differ from Windows desktop Excel.
Frequently Asked Questions
Why does Excel paste only the visible rows?
Filters hide nonmatching records, and copying a filtered selection generally focuses on visible cells. Clear the filter if you want all rows, or use Go To Special > Visible cells only when you intentionally want only visible cells from a selection that includes hidden rows.
Why does Excel copy only one cell?
The active selection may have collapsed to one cell, or you may have selected an object rather than the full cell range. Recheck the outline or enter the exact range in the Name Box, then copy again.
Why does Excel paste values instead of formulas?
You may have selected the Values paste option. Use a normal paste or choose the formulas option. If the formula is present but produces a different result, check for adjusted cell references.
Can I copy hidden rows in Excel?
Yes. Unhide manually hidden rows before copying if you want them included. Filtered-out rows need the filter cleared to appear; visible-cells-only selection is for copying the displayed subset, not the hidden records.
Why will Excel not paste into a protected sheet?
Protection may prevent editing the destination cells. Ask the workbook owner for permission or the password, or use an authorized unprotected copy. Selecting a cell on a protected sheet does not necessarily mean it can be changed.
Related
- Cash Flow Format in Excel: Build a Simple Statement
- CAGR Return in Excel: Calculate Investment Growth
- How to Calculate CAGR in Excel for 3 Years
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Conditional Formatting: Apply Rules and Fix IssuesTo apply conditional formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Excel Spill Error: Why It Happens and How to Fix ItExcel shows a #SPILL! error when a formula returns multiple results but Excel cannot place those results in…
- Excel VLOOKUP Spill Error: Causes and FixesAn Excel VLOOKUP spill error, shown as #SPILL!, means the formula is returning multiple results but Excel cannot…
- COUNTA Excel Not Working? Find the CauseIf COUNTA seems wrong, first check what is actually in the cells: the function counts any nonempty cell,…
- Excel SUMIF Quotation Marks Not Working? Fix the CriteriaIf Excel SUMIF quotation marks are not working, first check that text criteria use straight double quotation marks…
- Excel #REF! Error: Causes and FixesAn Excel #REF! error means a formula contains a reference to a cell, range, or worksheet that Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.