How to Copy Selected Cells in Excel Without Errors

How-to basics · Updated November 20, 2026

To copy selected cells in Excel for Microsoft 365 on Windows, select a cell or range, press Ctrl+C, click the destination cell, and press Ctrl+V. To copy nonadjacent cells, select them with Ctrl-click first, but if Excel rejects the multiple-area selection, copy and paste each area separately.

What You’ll Need

  • An Excel workbook open to the worksheet containing the cells you want to copy.
  • A destination cell or worksheet with enough room for the copied range.
  • A keyboard or access to Excel’s Home ribbon commands. On a Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V.

Copying usually includes the cell contents, formulas, and formatting. You can choose a different paste option if you only need values, formulas, or formatting. If the source workbook is shared or protected, you may need permission to edit the destination.

Step-by-Step

  1. Open the worksheet and identify the cells. Click the worksheet tab that contains the data. Decide whether you need one cell, a continuous range such as B2:D8, a whole row or column, or separate cells in different places. Check the intended boundaries before copying; an extra row or column can bring unwanted data and formatting along.
  2. Select one cell or a continuous range. For one cell, click it once. To select a range, click its first cell, hold the mouse button, and drag to the last cell. You can also click the first cell, hold Shift, and click the last cell. For a large range, click the Name Box to the left of the formula bar, type an address such as B2:D8, and press Enter. Excel selects that exact range.
  3. Select a whole row or column if needed. Click the row number at the left edge of the sheet to select a row, or the column letter at the top to select a column. To select several adjacent rows or columns, drag across their row numbers or column letters. Copying an entire row or column may also copy blank cells and formatting across the sheet, so select only the relevant range when you do not need the whole row or column.
  4. Select separate cells or ranges when appropriate. On Windows, hold Ctrl while clicking each separate cell or dragging across each separate range. Release Ctrl after making the selections. On a Mac, hold Command while selecting additional cells or ranges. A nonadjacent selection is useful when you need to identify several locations, but copying and pasting multiple areas at once is not supported in every arrangement. If Excel displays a warning or will not copy the selection, copy each area individually instead.
  5. Copy the selection. Press Ctrl+C on Windows or Command+C on Mac. Alternatively, go to Home > Clipboard > Copy, or right-click the selected area and choose Copy. A moving dashed outline, sometimes called the copy border, usually appears around the copied cells. Do not press Esc yet; Esc cancels the active copy outline.
  6. Choose the destination. Click the cell where the upper-left corner of the copied range should go. For a single copied cell, click the cell where that value or formula belongs. For a multi-cell range, select only the top-left destination cell; Excel fills the cells to the right and below it. Confirm that the destination area is clear, especially if the source range is several rows or columns wide.
  7. Paste the cells. Press Ctrl+V on Windows or Command+V on Mac. You can also use Home > Clipboard > Paste or right-click the destination and choose Paste. Check the result before continuing: confirm that the right cells arrived, formulas refer to the intended locations, and the formatting looks acceptable. If the pasted range is wrong, use Ctrl+Z on Windows or Command+Z on Mac to undo it, then repeat with the correct selection or destination.
  8. Choose a specific paste option if you do not want everything. After copying, open Home > Clipboard > Paste ▼ and choose an option such as Values, Formulas, or Formatting. In the Paste Special dialog, you can select the kind of content to paste, such as values or formulas. The exact available options depend on what you copied. For example, choosing Values pastes displayed results instead of formulas, which is useful when you want a fixed result rather than a live calculation.
  9. Finish the copy operation. After verifying the pasted cells, press Esc if the moving copy outline remains and you are finished copying. This clears the outline; it does not undo the paste. Save the workbook with Ctrl+S on Windows or Command+S on Mac if you want to keep the changes.

When you copy formulas, Excel normally adjusts relative references for the new location. For example, a formula that refers to the cell directly above may refer to the cell directly above its new location after pasting. Absolute references marked with dollar signs, such as $A$1, remain fixed. Review formulas when the destination is in a different part of the sheet, or use Paste Special > Values if you need only the current calculated results.

Common Mistakes

  • Choosing the wrong destination corner. When you paste a range, the selected destination cell becomes its upper-left corner. Selecting a destination cell in the middle of the area you intend to fill shifts the pasted data and can overwrite other entries.
  • Copying when you meant to move. Copy leaves the original cells in place. If you intend to move data, use Cut (Ctrl+X on Windows or Command+X on Mac) and then paste, or drag the selection carefully. Cutting and pasting can affect formulas and references differently from copying, so verify the outcome.
  • Assuming the pasted cells contain only values. A normal paste can include formulas, number formats, fonts, fills, borders, and other cell properties. Use a specific paste option when you need only one part of the cell.
  • Trying to paste an irregular multi-area selection as one block. Separate cells do not form a single rectangular range. Excel may refuse to copy or paste the selection, or the result may not match the layout you want. Handle each area separately unless Excel accepts the selection and you have confirmed the result.
  • Overlooking formulas that change references. Relative references update when copied, which is often useful but can produce a different answer if you expected the original reference to stay fixed. Inspect formulas in the formula bar or paste values if the calculation should not change.
  • Ignoring hidden rows or columns. A selection that appears to show only visible records may include hidden cells in some situations. If you need only visible cells, select the range, then use Home > Find & Select > Go To Special > Visible cells only before copying. Check the copied result, particularly when working with filtered data.

Tips

  • Use the keyboard for a quick repeat. Select the range, press Ctrl+C, click the destination, and press Ctrl+V. On Mac, replace Ctrl with Command. If you regularly use ribbon commands instead, Home > Clipboard > Copy and Home > Clipboard > Paste provide the same basic actions.
  • Copy a range without dragging. Use the Name Box to select a known address such as A1:C20. This is faster for large ranges and helps avoid stopping one row or column too early. You can also use Shift with the arrow keys to extend a selection from the active cell.
  • Keep the source pattern intact. When you paste a rectangular range, start at the destination’s upper-left cell and make sure the surrounding destination cells are empty if you do not want to replace existing content. Excel may warn you before overwriting data, but do not rely on a warning as your only check.
  • Use Paste Values to make a snapshot. If a copied cell contains a formula but you want to preserve its current displayed answer, choose Home > Clipboard > Paste ▼ > Values. This is also useful when transferring calculated results to a sheet where the original formulas or referenced cells are unavailable.
  • Use the fill handle only when you want a pattern. Dragging the small square at the selected range’s lower-right corner can copy or extend a series, depending on the selection and Excel’s behavior. For an exact duplicate, Ctrl+C and Ctrl+V are less ambiguous.
  • Check the status of the workbook. Protected sheets, merged cells, filtered lists, and shared editing can affect what you can select or paste. If a paste operation fails, check whether the destination is editable and whether its merged-cell layout matches the copied area.

Troubleshooting

Nothing happens after Ctrl+V. Click a worksheet cell first, then try the shortcut again. If the copy outline is no longer visible, repeat the selection and copy. The clipboard may have been replaced by something copied from another application, or Esc may have canceled Excel’s copy state. You can also use Home > Clipboard > Paste to check whether Excel has a selection available.

Excel says it cannot paste the selection. Check that the destination is not part of a merged range that conflicts with the source dimensions. A multi-cell range generally needs a compatible rectangular destination. Try clicking a single empty destination cell rather than selecting a differently sized destination block. For separate, nonadjacent source areas, copy and paste each area individually.

The pasted range overwrote data or landed in the wrong place. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Select the intended top-left destination cell and paste again. If you have already made more changes, review them before undoing, because undo reverses the most recent action first.

Only some cells appear to copy from a filtered list. If hidden rows or columns are involved, decide whether they should be included. To copy visible cells only, select the range and choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. If the visible selection consists of multiple separate areas and Excel rejects it, copy each visible block separately.

The pasted formula returns a different result. Excel may have adjusted relative references to fit the new position. Click the pasted cell and inspect its formula in the formula bar. If you need the original result rather than a recalculating formula, undo and paste with Home > Clipboard > Paste ▼ > Values. If the formula should keep particular references fixed, edit the source formula to use absolute references before copying.

Excel will not let you edit the destination. Look for a protected-sheet restriction, a read-only workbook, or a prompt indicating that another user has locked the area. If you have permission, use Review > Unprotect Sheet where available, or ask the workbook owner for edit access. Do not remove protection unless you are authorized to do so.

Frequently Asked Questions

How do I copy selected cells in Excel without a mouse?

Use the arrow keys to move to the first cell. Hold Shift and use the arrow keys to extend a continuous selection, then press Ctrl+C on Windows or Command+C on Mac. Move to the destination cell and press Ctrl+V or Command+V. For a known range, use the Name Box to enter its address, then copy and paste.

Can I copy only the values from selected cells?

Yes. Copy the selection, click the destination, then choose Home > Clipboard > Paste ▼ > Values. This pastes the current results rather than formulas. It also avoids carrying over most of the source formatting, so the destination keeps its existing appearance.

How do I copy nonadjacent cells in Excel?

Hold Ctrl on Windows or Command on Mac while selecting the separate cells or ranges. Excel may not support copying and pasting every multi-area selection as one operation. If you see an error, copy each cell or rectangular area separately and paste it into its matching destination.

Why did the copied formula change?

Excel adjusts relative cell references when you copy a formula to a new location. References with dollar signs, such as $A$1, are absolute and stay fixed. If you need the displayed answer without a formula, use Paste Values instead.

Does copying cells remove them from the original location?

No. Copying duplicates the selected cells and leaves the source in place. To move the content, use Cut and Paste instead. Review the destination after either operation, especially if formulas, formatting, or existing data are involved.

Can I copy cells between worksheets?

Yes. Copy the selected cells, click the destination worksheet tab, select the top-left destination cell, and paste. You can also copy between open workbooks. If the source contains formulas that refer to other sheets or workbooks, check those references after pasting.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.