To paste copied content into several Excel cells, copy the source, select the destination range, and press Ctrl+V on Windows. To put the same typed value in many cells at once, select the cells, type the value, and press Ctrl+Enter. The right method depends on whether you are copying a block, repeating one cell, or filling selected cells with one entry.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The content you want to copy, either in Excel or in another app.
- A clear destination range large enough for the copied content. If you are pasting a block, check its number of rows and columns first.
- If the source is outside Excel, make sure it is copied to the clipboard before switching to the workbook.
The instructions below use Windows shortcuts unless stated otherwise. In Excel for Mac, use Command instead of Ctrl for common copy-and-paste shortcuts, such as Command+C and Command+V. Some selection shortcuts differ, so those differences are noted where they matter.
Step-by-Step
- Choose the kind of paste you need. Use a normal paste to copy a single cell or a group of cells, including their contents and usually their formatting. If you only need the same text or number in several places, use the fill method later in this list. If you need only the copied values rather than formulas or formatting, use Paste Values.
- Check the source content. In Excel, select the cell or rectangular range you want to copy. A rectangular range is a connected group of cells, such as B2:D4. To copy data from another program, select and copy it there first. You can copy a single item, a row or column of cells, or a block with several rows and columns.
- Copy the selection. Press Ctrl+C on Windows or Command+C on Mac. Excel displays a moving border around the copied cells. Keep the workbook open and avoid copying something else before you paste, because a new copy replaces the previous clipboard selection.
- Select the destination in Excel. Click the top-left cell where the copied material should begin. For a single copied cell, you can select one destination cell or drag across a larger range if you want the same copied cell repeated. For a multi-cell source, select the top-left destination cell; Excel will place the full block starting there.
- Confirm there is room for the whole block. If the source is three columns wide and two rows tall, the destination starting point must have space for those six cells. For example, pasting a B2:D3 block starting at F5 fills F5:H6. Check that no information you need will be overwritten in that area.
- Paste the copied cells. Press Ctrl+V on Windows or Command+V on Mac. You can also use Home > Paste on the ribbon. Excel inserts the copied content at the selected destination. A single copied cell pasted into a selected rectangular range is repeated throughout that range; a copied block is placed as a block, beginning at the destination cell.
- Review the result before doing anything else. Check the first and last cells in the pasted area, as well as any formulas, dates, number formats, and borders. Pasting can replace existing values. If the result is wrong, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo it, then make a corrected selection and try again.
- Use Paste Values if you do not want formulas or formatting. Copy the source as usual, select the destination, and open Home > Paste using the ribbon dropdown. Choose Values, often shown with a clipboard and 123 icon. This pastes the calculated values rather than formulas and does not carry over the source cell formatting. The exact icon appearance can vary slightly with the ribbon display.
- Enter the same value in a selected range. Select the cells you want to fill. For a continuous block, click and drag over it or enter its address in the Name Box to the left of the formula bar. Type the text or number, then press Ctrl+Enter on Windows. Excel places that entry in every selected cell. On Mac, Control+Return is commonly used for this action; if your keyboard or Excel settings behave differently, use the menu or check Excel’s shortcut list.
- Fill non-adjacent cells with one entry. If the target cells are separated, hold Ctrl and click each cell on Windows; on Mac, hold Command while selecting additional cells. Type the shared entry, then press Ctrl+Enter on Windows to enter it in the selected cells. This is an entry operation, not a conventional clipboard paste: it is useful for repeating a value, but it does not distribute a copied multi-cell block across separate areas.
- Finish the selection and verify each target. Click another cell after filling, then inspect the intended destinations. A multi-area selection can be hard to see, so check each target cell individually. If you are filling a large range, save the workbook after confirming the result.
For example, to repeat the word Pending from a copied cell across C2:C20, copy the source cell, select C2:C20, and press Ctrl+V. To type the word into that range without copying, select C2:C20, type Pending, and press Ctrl+Enter. These methods look similar in the result, but the first uses clipboard content and may bring formatting, while the second enters the typed content into the selected cells.
Common Mistakes
- Selecting only one destination cell for a block and not checking the footprint. Excel expands a pasted block from that starting point. If cells below or to the right contain data, the paste may replace them. Estimate the source dimensions and inspect the destination area first.
- Expecting Ctrl+V to fill separated cells. A standard paste is designed for a destination area, not a collection of unrelated cells. For one shared value in non-adjacent cells, select those cells and use the type-and-Ctrl+Enter method. For different copied content, paste into separate destinations or arrange the destinations as a continuous block.
- Copying a formula when you meant to copy its displayed result. Normal paste generally copies the formula. Relative cell references may adjust for the new location, which can change the result. Choose Paste Values when you need the current calculated results without formulas.
- Assuming Paste Values keeps the source appearance. It is meant to paste values without the original formatting. If you need the formatting too, use normal paste or choose a suitable option from the Paste menu.
- Typing after selecting a range but pressing Enter. Enter normally commits an entry to the active cell and moves the selection. To put one typed entry into all selected cells, use Ctrl+Enter on Windows instead.
- Forgetting that a paste overwrites existing content. Excel does not always ask for confirmation before replacing cells. Check the destination before pasting and use Undo promptly if you replace something by mistake.
Tips
- Use the Name Box for a large, continuous range. Click the box to the left of the formula bar, type an address such as D2:D500, and press Enter. The range is selected without scrolling through every row. Then use Ctrl+Enter to fill it with one typed entry, or use it as a destination when the copied source fits.
- Use a clear destination when pasting a block. If you are unsure how much data is in the source, check its selection outline or status information before copying. Start the paste in a blank area when practical, then move the result after reviewing it.
- Keep the distinction between content and appearance in mind. Normal paste can include values or formulas and formatting. Paste Values is appropriate for results you want to keep fixed, such as figures copied from formulas, but it does not preserve the formula that produced them.
- Use the Paste Options button when it appears. After a paste, Excel may show a small options button beside the pasted area. It provides convenient choices for how to keep or change the pasted content. If the button disappears, undo and repeat the paste, or use Home > Paste.
- Save before large changes. Ctrl+Z can undo a recent paste, but it is safer to save a copy of important workbooks before replacing a large area or making many changes. Be especially careful when the destination contains formulas or manually entered data.
Troubleshooting
Nothing pastes. Make sure the copy operation completed and that the moving border is visible around the source. Select a destination cell in the worksheet and try Ctrl+V again. If you copied from another program, return to that program, copy the content once more, and switch back to Excel. Also check whether the worksheet or workbook is protected, which can prevent changes to locked cells.
Excel says the copy and paste areas are different sizes. This can happen when a multi-cell source and a separately selected destination do not match. For a normal block paste, select just the top-left destination cell and paste; Excel will expand the block from there. If you specifically need a one-to-one fill into a selected range, make sure the source and destination dimensions match.
The pasted data lands in the wrong place. Undo immediately with Ctrl+Z, click the correct top-left destination cell, and paste again. If Excel is in cell-edit mode, pressing a shortcut may affect text inside the cell rather than the worksheet selection. Press Esc to leave edit mode, select the intended cell, and retry.
The result has unexpected formulas or formatting. Undo, copy the source again, and use Home > Paste > Values if you need only the displayed results. If you want formulas but not the source styling, choose the relevant paste option from the ribbon dropdown. Review a few cells to ensure the chosen option produced the intended result.
Ctrl+Enter does not fill every intended cell. First confirm that all target cells are selected before typing. If you press Enter instead, Excel may commit the entry only to the active cell. Select the cells again, type the entry, and use Ctrl+Enter on Windows. For non-adjacent selections, make sure each target is included in the selection before entering the value.
The clipboard content changes unexpectedly. Copying another item replaces the current clipboard content. Repeat the copy immediately before selecting the destination and pasting. If you have copied content from a website or another app, formatting may also come along; use Paste Values or a plain-text option when offered if you only need the text or values.
Frequently Asked Questions
How do I paste one cell into multiple cells in Excel?
Copy the cell, select the rectangular destination range, and press Ctrl+V. Excel repeats the single copied cell throughout that selected range. If you are entering a new value rather than copying, select the range, type the value, and press Ctrl+Enter.
Can I paste the same value into non-adjacent cells?
For the same typed value, select the separate cells by Ctrl-clicking them on Windows, type the value, and press Ctrl+Enter. Standard clipboard paste into a multi-area selection may not work as expected, so do not rely on it for distributing a copied block to unrelated locations.
How do I paste without changing existing formatting?
Copy the source, select the destination, then choose Home > Paste > Values. This pastes the cell values or formula results without carrying over the source formatting. If you need a different combination of content and appearance, check the other options in the Paste dropdown.
Will formulas change when I paste them into other cells?
They can. In a normal paste, relative references typically adjust to the new position, while absolute references marked with dollar signs remain fixed. Use Paste Values if you want the current results without copying formulas, and check the pasted cells before relying on them.
Can I paste a row or column into several cells?
You can copy a row, column, or rectangular block and paste it starting at a destination cell with enough space. To repeat a one-cell source, select a larger rectangular range before pasting. A multi-cell source is pasted as a block rather than repeated as separate complete blocks across an arbitrary selection.
Do these steps work in Excel for the web?
The basic copy and paste commands are available in Excel for the web, though browser and operating-system shortcuts can affect clipboard behavior. Use the ribbon’s Paste command if a keyboard shortcut is intercepted. Some desktop paste options and interactions may differ, so check the ribbon menu in the web app.
Related
- Multiply in Excel by a Constant Number
- How to Move to a New Line in an Excel Cell on Windows
- How to Move Tabs in Excel With the Keyboard
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Make a Budget Tracker in Google SheetsMake a monthly budget tracker in Google Sheets by listing expense categories, entering planned and actual amounts, and…
- How to Copy Large Data in Excel Safely and QuicklyTo copy a large data range in Excel, select only the cells you need, press Ctrl+C, click the…
- Forecast Sheet in Excel: Enable It and Build a ForecastTo enable Excel’s Forecast Sheet, put a chronological timeline in one column and the matching numeric values in…
- Creating a Booklet in Word: Setup, Pages, and PrintingTo create a booklet in Microsoft Word for Microsoft 365 on Windows, open Layout > Margins > Custom…
- How to Keep Leading Zeros in Excel as Text or NumbersTo keep a leading zero in Excel, format the cell as Text before entering the value, or type…
- Convert Text to Number in Excel Cells: Quick FixesTo convert text to numbers in Excel, select the affected cells and click the warning icon, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.