How to Enable Copy and Paste in Excel When It Stops

How-to basics · Updated November 20, 2026

Copy and paste is normally enabled in Excel for Microsoft 365 on Windows; there is no general switch you need to turn on. Select a cell or range, press Ctrl+C, select a destination, and press Ctrl+V. If the commands are unavailable or nothing pastes, check whether Excel is editing a cell, the sheet or destination is protected, or a browser or organization policy is blocking clipboard access.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or the Excel version you are using.
  • A workbook with a cell or range you are allowed to select, and a destination where you can enter data.
  • If Excel is running in a browser, an up-to-date browser and permission to access the clipboard when prompted.

You do not need to install a special add-in or enable a separate copy-and-paste feature for ordinary cell copying. If you are using a managed work or school computer, your organization may apply restrictions that you cannot change yourself.

Step-by-Step

  1. Leave cell-editing mode. Click a cell once rather than double-clicking it. If a cursor is visible inside the cell or the formula bar, press Enter to keep the edit or Esc to cancel it. Excel treats copying text inside a cell differently from copying the cell itself, and the regular range commands may not work as expected while you are editing.
  2. Select the source. Click the cell you want to copy. To copy a block, click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. The selection border should surround the cells. You can also select whole columns or rows by clicking their letter or number headers, but be careful not to overwrite a large destination area.
  3. Copy the selection. On Windows, press Ctrl+C. Alternatively, choose Home > Clipboard > Copy on the ribbon. A moving dashed outline, sometimes called marching ants, usually appears around the copied cells. It is a visual sign that Excel has a copy selection ready; it is not an error message.
  4. Choose the destination cell. Click the upper-left cell where the copied selection should begin. If you copied a multi-cell range, Excel fills the corresponding number of rows and columns from that starting point. Check that the destination is the correct sheet and workbook before pasting, especially if you have several workbooks open.
  5. Paste the cells. Press Ctrl+V, or choose Home > Clipboard > Paste. A normal paste can include values, formulas, formatting, and other cell properties. If you only want the displayed results, use Home > Paste > Paste Values when that option is available in the ribbon menu. To paste into a different workbook, first switch to it and select the destination cell, then paste.
  6. Confirm the result and finish the copy operation. Check a few pasted cells to make sure the values, formulas, and formatting are what you expected. Press Esc when you are done to remove the moving outline and end the current copy operation. Esc does not undo the paste; use Ctrl+Z immediately if you pasted into the wrong place and want to undo it.

On Excel for Mac, use Command+C to copy and Command+V to paste; the ribbon commands are available from the Home tab as well. In Excel for the web, the ribbon commands work too, but the browser may ask you to allow clipboard access. Follow that prompt if you want to use keyboard shortcuts. If access is blocked, try the ribbon’s Copy and Paste buttons.

Common Mistakes

  • Trying to copy while editing the contents of a cell. If you see a text cursor, Excel may copy selected text rather than the cell range. Press Enter or Esc, then select the cell again.
  • Assuming protection always disables copying. Worksheet protection mainly limits changes, and it does not necessarily prevent copying. It can, however, prevent selecting certain cells or pasting into locked cells. Check both the source selection and destination permissions.
  • Using Cut when you mean Copy. Ctrl+X removes the source content when you complete the move. Ctrl+C leaves the original in place. If you need the original unchanged, use Copy.
  • Expecting a regular paste to transfer only text or values. A standard paste may bring formulas and formatting along. Use Paste Values for results only, or choose a suitable Paste Special option when you need a specific part of the copied cells.
  • Ignoring the size or shape of the copied range. A range needs enough room at the destination. Pasting a wide or tall selection over existing data can replace that data, so confirm the starting cell and destination area first.
  • Looking for a global enable switch. Excel does not normally have a single setting that turns ordinary copy and paste on or off. A disabled command is more often a sign of the current editing state, protection, a clipboard problem, or a policy restriction.

Tips

  • Use Ctrl+C and Ctrl+V for the quickest workflow on Windows. The Mac equivalents are Command+C and Command+V. When shortcuts are intercepted by another application or browser, use the Home tab commands instead.
  • For adjacent cells, select the entire range before copying rather than copying cells one at a time. This preserves the layout and makes the destination footprint easier to anticipate.
  • When copying formulas between locations, remember that relative cell references may adjust to the new position. If you intended to copy displayed results instead, choose Paste Values and check the result.
  • When moving data between workbooks, keep both workbooks open and select the destination cell in the correct workbook. If you are moving data between different apps, try a small sample first to see whether formatting is retained.
  • In Excel for the web, use the ribbon if a keyboard shortcut fails and look for a browser permission prompt. Browser clipboard controls vary, so there is not one settings path that applies to every browser and operating system.
  • If you are pasting a large range, consider copying a small test range first. This can reveal whether protection, merged cells, or a formatting mismatch is likely to interrupt the full operation.

Troubleshooting

Copy or Paste is greyed out. First press Enter or Esc to exit cell editing, then select a cell or range again. If you are in a dialog box, a chart-editing context, or another mode that is not a normal worksheet selection, close or exit that mode and try from the worksheet. The Home tab buttons may become available once a valid selection is active.

You cannot select or change the cells. Check Review > Unprotect Sheet. If the sheet is protected, you may need the password or help from the workbook owner; do not try to bypass a password. If the sheet is protected but you can select the source, try pasting into an unprotected cell or a new blank workbook. A workbook marked read-only may still allow copying from it, while preventing changes to that workbook; save an editable copy if you have permission to do so.

Nothing happens after Ctrl+V. Copy a cell again, wait for the moving outline, click a normal worksheet destination, and paste. If the outline disappeared, press Ctrl+C again because Esc or another copy action can replace or cancel the pending selection. Try Home > Paste to determine whether the shortcut is the issue. On a Mac, retry with Command+C and Command+V.

Excel for the web reports a clipboard problem. Allow clipboard access if your browser displays a permission prompt, then retry. If no prompt appears or the shortcut remains blocked, use Home > Copy and Home > Paste. You can also try another supported browser if your organization permits it. Browser privacy settings or managed-device policies may prevent access, in which case an administrator may need to review the restriction.

You see an error when pasting. Check that the destination is not protected and that the copied range can fit. Merged cells can cause problems when the source and destination have different merged-cell layouts; try an unmerged destination or copy a matching range. If you are pasting into a filtered list, verify which visible cells are selected before proceeding so you do not change unintended data.

Copy and paste fail in every workbook. Test the clipboard in another application, such as copying a short phrase into Notepad on Windows. If it also fails there, the issue may be outside Excel. Save your work, close and reopen Excel, and retry. If the problem returns, an add-in or managed security policy may be involved; ask your IT administrator before changing security settings or disabling approved software.

Frequently Asked Questions

Is copy and paste enabled by default in Excel?

Yes. Ordinary copying and pasting between worksheet cells is available by default. If a command is unavailable, look for an editing mode, a restricted source or destination, a browser permission issue, or an organization policy rather than searching for a general enable setting.

Can a protected Excel sheet prevent copy and paste?

Protection can restrict which cells you can select or change, so it can stop a particular copy or paste operation. It does not always block copying. Check Review > Unprotect Sheet if you have authorization and the required password, or ask the workbook owner to provide an editable destination.

Why can I copy cells but not paste into them?

The destination may be locked on a protected sheet, read-only, or otherwise unavailable. Select a permitted cell in an editable sheet or workbook and try again. Also confirm that the copied range fits the destination and does not conflict with merged cells.

How do I paste values without the original formatting or formulas?

Copy the cells, select the destination, and choose Home > Paste > Paste Values. This pastes the calculated results rather than carrying over the source formulas and most formatting. The exact arrangement of paste options can vary slightly with the ribbon layout and Excel version.

Why does copy and paste work in desktop Excel but not Excel for the web?

The browser controls clipboard access, so it may block shortcuts or request permission. Allow access when prompted, or use the Copy and Paste commands on the Home tab. If a work or school policy blocks clipboard use, contact the administrator.

Does pressing Esc undo a paste?

No. Esc ends the active copy selection and removes its moving outline; it does not reverse a completed paste. Use Ctrl+Z on Windows or Command+Z on Mac immediately after the paste if you need to undo it.

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.