How to Paste in Excel Using Keyboard Shortcuts

How-to basics · Updated November 20, 2026

To paste in Excel with your keyboard, select the cell or range you want to copy, press Ctrl+C on Windows, move to the destination, and press Ctrl+V. On a Mac, use Command+C and Command+V. You can also use the keyboard to paste a whole range or open Paste Special when you need only values, formulas, or formatting.

What You’ll Need

  • An open Excel workbook with the data you want to copy or cut.
  • A destination cell or range in a worksheet where you have permission to make changes.
  • A keyboard. A mouse is optional; you can select cells and move around the worksheet with keys.

These instructions are for Excel for Microsoft 365 on Windows. The basic copy-and-paste keys also work in Excel for the web, although a browser or clipboard permission can sometimes affect them. Mac equivalents are noted where they differ.

Step-by-Step

  1. Select the source cell or range. Click the cell that contains the information you want to copy, or use the arrow keys to move the active cell there. To copy several adjacent cells, hold Shift while using the arrow keys to extend the selection. For example, click A2, hold Shift, and press the right arrow twice to select A2:C2. To select a larger block, continue extending the selection up, down, left, or right. The shaded selection shows which cells will be copied.
  2. Copy the selection. Press Ctrl+C on Windows. A moving dashed border, sometimes called marching ants, usually appears around the copied cells. On a Mac, press Command+C. Copying places the selected content on the clipboard without removing it from its original location. If you meant to move the data rather than make a duplicate, use Ctrl+X on Windows or Command+X on Mac instead.
  3. Move to the destination. Select the cell where the pasted content should begin. You can click it, or navigate with the arrow keys. To move quickly, press Ctrl+G on Windows to open Go To, type a cell reference such as D5, and press Enter. On a Mac, use Control+G to open Go To in Excel. When pasting a range, select only its top-left destination cell; Excel will fill the cells to its right and below.
  4. Paste the copied content. Press Ctrl+V on Windows or Command+V on Mac. Excel pastes the copied cell or range starting at the active destination. A copied cell generally brings its value or formula along with its formatting. For a copied range, Excel keeps the same row-and-column arrangement. For instance, copying A2:B4 and pasting at D2 fills D2:E4.
  5. Check the result before continuing. Confirm that the content landed in the intended cell and that the rows and columns line up. If the copied cells contained formulas, click a pasted formula cell and inspect the formula bar: references may adjust to the new location. This is normal for relative references. If a result looks different than expected, press Ctrl+Z on Windows or Command+Z on Mac to undo, then check the source selection and destination before trying again.
  6. Paste only what you need, if required. To open the Paste Special dialog on Windows, copy the source, select the destination, and press Ctrl+Alt+V. Choose an option such as Values, Formulas, or Formats with the keyboard, then confirm with Enter. The exact dialog controls can depend on the selected option and Excel build, so check the labels before confirming. If you prefer the ribbon, use Home > Paste to open the paste options. On Mac, use the Edit > Paste Special menu; available keyboard access can vary by Excel version and keyboard settings.
  7. Finish or clear the copy outline. After pasting, Excel may keep the dashed outline around the source so you can paste again elsewhere. Press Esc when you are done to end copy mode. This does not undo the paste; it only clears the active copy selection. If you are copying more cells to another location, leave copy mode active and select the next destination instead.

For a keyboard-only workflow, use the arrow keys to reach the source, extend a range with Shift plus the arrow keys, copy, and then navigate to the destination. In a large worksheet, Go To is often quicker than pressing an arrow key repeatedly. You can type a reference such as F120 into the Go To box and jump directly to that cell.

Common Mistakes

Pressing the shortcut while editing a cell. If you double-clicked a cell or pressed F2, Excel may be editing the cell contents rather than selecting the cell. In that state, a shortcut can act on text inside the cell instead of the whole cell. Press Esc to leave edit mode without keeping the changes, or Enter to accept them, then select the cell and copy it.

Selecting the wrong destination. Excel starts the paste at the active cell, which is usually the white or outlined cell within a selection. When pasting a block, choosing the wrong starting cell shifts the entire block. Undo immediately if the layout is wrong, then select the intended top-left cell and paste again.

Expecting a formula to become a fixed number. Standard paste copies formulas, not just the displayed results. Relative cell references can change based on where the formula is pasted. If you want the current results without formulas, use Paste Special and choose Values. Conversely, if you need a working formula, do not choose Values.

Confusing copy with cut. Ctrl+C makes a duplicate; it does not remove the original. Ctrl+X marks the content to move. Avoid cutting cells when you only want another copy, and check the source area after moving information to ensure it is now empty as expected.

Copying a larger range than intended. A selection can include blank cells, hidden rows, or columns. Excel may paste those blanks too, replacing existing content in the destination. Look over the highlighted source range before copying, especially when the data is near other entries you need to preserve.

Tips

Use copy for repeat pastes. After copying a cell or block, you can select another destination and press Ctrl+V again. Press Esc when you have finished. This is handy for placing the same label, formula, or formatted block in several locations.

Match the destination to the shape of the source. If you copy a three-column by four-row block, select its top-left destination cell and make sure there is room for a three-by-four block. Pasting over occupied cells replaces their contents. Excel may show a warning in some situations, but do not rely on a prompt to protect existing data.

Use the formula bar to distinguish display from content. A cell may show a rounded number while storing more decimal places, or show a formula result while containing a formula. Standard paste copies the underlying cell content and formatting. Paste Special Values is useful when you want to keep the displayed result as a fixed value and not carry over the original formula.

Keep formulas linked when that is the goal. When a formula refers to cells using relative references, such as A1, those references usually adjust as the formula moves. Absolute references written with dollar signs, such as $A$1, remain fixed when copied. If pasted calculations point to unexpected cells, compare the original and pasted formulas and check whether the references should be relative or absolute.

Know the difference between pasting and filling. Copy and paste is suitable for moving a selection to a separate area. If you want to repeat a value or formula into neighboring cells, copying the source and pasting over the chosen range can work, but check the result carefully. For a series such as dates or numbers, dragging the fill handle or using a fill command may produce a sequence rather than identical copies; ordinary keyboard paste duplicates the copied content.

Consider the workbook and worksheet context. Pasting into a filtered list, a protected sheet, or a merged-cell area can behave differently from pasting into a simple blank grid. Before copying a large block, check that the destination has the same suitable layout and that the sheet is not protected against edits. If Excel rejects the paste, try a single destination cell in an unmerged, editable area to identify whether the layout is the issue.

Troubleshooting

Nothing happens after Ctrl+V. First check that the cell selection is active and that Excel, rather than another application or a dialog box, has focus. Copy the source again, then select the destination and press Ctrl+V. If you are using Excel for the web, the browser may block clipboard access; use the Excel copy and paste buttons or allow clipboard access if the browser asks. On Mac, verify that you are using Command+V, not the Windows shortcut.

The wrong content appears. You may have copied a different cell, or the clipboard may have been replaced after the copy. Select the intended source and copy it again immediately before pasting. If the source has a dashed border, it is still in copy mode, but another copy operation can replace the clipboard contents. Check the formula bar or the source cell before retrying.

Excel reports that the copy and paste areas are different sizes. This can happen when you select a destination range whose dimensions do not match the copied range. For a block paste, select just one top-left destination cell, then paste. If you want to fill a particular range, make sure its row and column count is compatible with the copied selection.

Only a result or only formatting was pasted. You may have used a Paste Special option previously, or selected a paste option from the ribbon. Open Paste Special again and choose the intended type: Values for fixed results, Formulas for calculations, or Formats for appearance. Standard Ctrl+V is the usual choice when you want Excel’s normal paste behavior.

The paste is blocked or changes the layout. Check for a protected worksheet, merged cells, a filtered range, or existing data in the target area. If possible, test by pasting into a blank cell on an unprotected worksheet. Undo if the paste overwrote something, then resolve the sheet or range restriction before trying the intended destination again.

Frequently Asked Questions

What is the keyboard shortcut to paste in Excel?
In Excel for Windows, press Ctrl+V. On a Mac, press Command+V. Copy the source first with the matching copy shortcut, then select the destination cell.

Can I paste in Excel without using a mouse?
Yes. Move to cells with the arrow keys, extend a selection with Shift plus an arrow key, copy with Ctrl+C on Windows or Command+C on Mac, and navigate to the destination before pasting.

How do I paste values only with the keyboard?
On Windows, copy the cells, select the destination, and press Ctrl+Alt+V to open Paste Special. Choose Values and confirm. Because dialog navigation can vary slightly, read the option labels before pressing Enter. On Mac, open Edit > Paste Special and select Values.

Does Ctrl+V paste formulas as well as values?
Usually, standard paste copies the cell’s formula, value, and formatting. If the source contains a formula, Excel pastes the formula and may adjust relative references for the new location. Choose Values in Paste Special if you need only the calculated result.

Why does my pasted formula show a different answer?
Its cell references may have adjusted when you moved it. Compare the formula in the source and destination. Relative references change position when copied; references with dollar signs, such as $A$1, are fixed. Undo and revise the formula or use Paste Special Values if a fixed result is what you need.

Can I paste the same copied cells more than once?
Yes. After copying, select each destination in turn and paste again. Excel can keep the copied selection active until you press Esc or perform another action that ends or replaces copy mode. Check each destination to avoid overwriting content accidentally.

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.