To copy one cell’s data into many cells in Excel for Microsoft 365 on Windows, select the source cell and press Ctrl+C, select the destination range, then press Ctrl+V. Excel places the copied content in each cell of the selected range. You can also use Fill Down, the fill handle, or Ctrl+Enter when you want to enter the same value without copying first.
What You’ll Need
- An Excel workbook you can edit, with the source value or formula already entered in a cell.
- A clear idea of which destination cells should receive the data. If those cells contain information you need, make a copy of the workbook or choose an empty range first.
- A keyboard and mouse or trackpad. The steps below use Excel for Microsoft 365 on Windows; Mac shortcuts and menu alternatives are noted where they differ.
Step-by-Step
- Choose the cell to copy. Click the cell containing the text, number, date, or formula you want to duplicate. Check the formula bar if you are unsure what is stored in the cell: a displayed value might be the result of a formula rather than a typed number. Copying a formula can produce different results in the destination cells because Excel may adjust its references.
- Copy the source cell. Press Ctrl+C, or select Home > Copy on the ribbon. A moving dashed outline usually appears around the copied cell. On a Mac, use Command+C. Keep the source copied while you select the destination; if you copy something else, the clipboard contents change.
- Select the destination cells. For a continuous block, click the first destination cell and drag across or down to the last cell. You can also click the first cell, hold Shift, and click the last. To select a whole column or row, click its heading, but do this only if you intend to fill every cell in it. Do not include the source cell unless you intend to replace or update it.
- Paste into the selection. Press Ctrl+V, or choose Home > Paste. Excel repeats the single copied cell’s content throughout the selected range. For example, if you copied a cell containing North and selected B2:B8, each of B2 through B8 receives North. On a Mac, press Command+V. If you selected only one destination cell, only that cell is filled.
- Check the result and formatting. Look at a few cells near the top, middle, and bottom of the range. A regular paste copies the cell’s content and usually its formatting too, so the destination may inherit the source’s font, fill color, borders, and number format. If you need the destination’s existing appearance, undo with Ctrl+Z and use a paste option that transfers only the content, such as Values, where available in the Paste Options menu.
- Use Fill Down for a vertical range when appropriate. If the top cell already contains the content you want repeated, select that cell plus the cells below it, then choose Home > Fill > Down. The Windows shortcut is Ctrl+D. For example, select C3:C15 when C3 has the entry to repeat; Fill Down copies the top cell into the cells underneath. On Mac, use Home > Fill > Down if your keyboard shortcut differs.
- Use the fill handle for a quick drag. Click the cell with the entry, point to the small square at the lower-right corner of its selection border, then drag it across or down over the destination cells. Release the mouse to fill. Excel may extend a pattern rather than repeat a value in some situations, particularly with number sequences or dates, so inspect the result. If a fill options button appears, use it to choose the intended behavior.
- Enter the same item into separate selected cells. For nonadjacent cells, hold Ctrl on Windows while clicking each destination cell. Type the value, then press Ctrl+Enter to enter it into all selected cells at once. On a Mac, use Command-click to select separate cells; Control+Return is commonly used to enter the typed item into the selected cells. This method enters new content rather than pasting the clipboard, so use it when the cells are scattered or selecting a large rectangular block is inconvenient. Be careful: any existing contents in those selected cells are replaced.
- Finish the copy operation. Press Esc if the moving outline remains and you no longer need the copied cell on the clipboard. Save the workbook with Ctrl+S; on Mac, use Command+S. If the result is wrong, use Ctrl+Z on Windows or Command+Z on Mac immediately, then reselect the correct range and try again.
Common Mistakes
- Selecting the wrong range: A range that is too large can overwrite unrelated information. Before pasting, check the highlighted cells and the name box to confirm the selection. If you accidentally select a whole row or column, undo before making other edits.
- Confusing copy with a series fill: Dragging the fill handle can continue a sequence, such as dates or numbered labels, instead of repeating the exact same item. For a guaranteed duplicate of a single cell, copy it and paste into the selected range, then inspect the result.
- Overwriting data without noticing: Pasting replaces existing cell contents. Excel may not give a separate warning for an ordinary paste into populated cells. Check the destination first, and keep a backup when the existing data matters.
- Expecting a formula to stay identical: When you copy a formula, relative references normally shift for each destination. A formula that refers to a nearby cell may therefore calculate a different result after pasting. If you want references to stay fixed, use absolute references in the formula, or paste values when you want only the current displayed results.
- Assuming formatting will stay unchanged: A normal paste often carries the source formatting. This can change number formats, borders, or colors in the target cells. Use a Values or other suitable paste option if you want to transfer data without all of the source cell’s appearance.
- Using Ctrl+Enter before selecting all targets: The typed entry goes into the selected cell or cells, so a selection error can replace the wrong content. Select and verify the target cells before typing.
Tips
- Use the Name Box for a large range. Click the Name Box to the left of the formula bar, type a range such as D2:D500, and press Enter. With the source already copied, this selects the destination precisely without scrolling or dragging through hundreds of rows.
- Choose the paste type deliberately. After pasting, use the Paste Options button near the selection to choose an available option such as Values or Formulas. You can also use Home > Paste to see paste choices on the ribbon. The precise options shown can vary with what you copied and your Excel version.
- Use Fill Down when the source is already at the top. It is often quicker than copying and pasting for a vertical block. Select the source cell and the cells below it together; Ctrl+D fills downward from the top cell. For a horizontal block, Excel’s Home > Fill > Right command can fill from the leftmost selected cell.
- Use Ctrl+Enter for a shared entry, not a complex layout. It is handy for assigning the same status, label, or formula to multiple selected cells. It does not copy the source cell’s formatting in the same way as a normal paste, so apply formatting separately if needed.
- Remember that filtered lists need extra care. A range can contain hidden rows when a filter is active. A standard selection and paste may not behave like a selection of visible cells only. If you mean to update visible records but leave hidden rows untouched, select visible cells only using Home > Find & Select > Go To Special > Visible cells only before pasting, then verify the affected rows.
- Keep source and destination clear. If you are copying between worksheets, select the destination sheet tab after copying, then select the target range and paste. Excel can paste across sheets in the same workbook; confirm that you are on the intended sheet before pressing Ctrl+V.
Troubleshooting
- Only one cell changed: The destination range may not have been selected when you pasted. Undo, copy the source again, select the full target block, and paste once more.
- Excel says the copy area and paste area are different sizes: This can happen when you copied multiple cells but selected an incompatible destination shape. If you want one value repeated, copy a single source cell. If copying a block, select a destination of a matching size or use a single-cell source for a larger range.
- Nothing pastes or the moving border disappeared: Copy the source again with Ctrl+C, then select the destination and press Ctrl+V. If you are using Excel for the web, browser or clipboard permissions can affect clipboard behavior; try the ribbon’s Copy and Paste commands or use Ctrl+Enter to enter the same value in a selected range.
- Some cells did not change: The worksheet may be protected, the workbook may be read-only, or the target cells may be part of a merged area or table with restrictions. Check Review > Protect Sheet, confirm you can edit the workbook, and inspect whether cells are merged. Unmerge cells only if doing so is appropriate for the layout.
- The pasted result has the wrong colors or number format: Undo, then paste again using Values or another suitable option from Paste Options. Alternatively, use Ctrl+Enter to enter the same typed item without copying the source formatting.
- The values differ from the source: Check whether the copied cell contains a formula. Relative references can adjust when copied, and formulas can recalculate based on each row. If you need identical displayed results, paste values rather than formulas.
Frequently Asked Questions
Can I copy one cell into an entire column?
Select the destination cells in that column and paste the copied cell. For a very large column, consider selecting only the rows that actually need the value so you do not overwrite headings, totals, or other data.
How do I put the same value in several cells without copying?
Select the destination cells, type the value, and press Ctrl+Enter on Windows. On a Mac, Control+Return is commonly the equivalent. This replaces the contents of all selected cells with the entry you typed.
Will copying a cell also copy its formatting?
A regular paste usually copies both content and formatting. Choose Values or another paste option if you want to limit what is transferred, and check the Paste Options button because the available choices depend on the copied content.
Why does a copied formula give different results in each cell?
Excel normally adjusts relative cell references as a formula is copied. To keep a reference fixed, make it absolute in the formula before copying, or paste values if you need the existing calculated result rather than a working formula.
Can I paste into cells that are not next to each other?
You can select separate cells with Ctrl-click on Windows or Command-click on Mac and use Ctrl+Enter or Control+Return to enter the same typed value. Standard clipboard pasting into several separate areas can be less predictable, so this entry method is usually simpler for scattered cells.
Does this work in Excel for Mac and Excel for the web?
Yes, the basic idea is the same: copy a cell, select a destination, and paste. Mac uses Command+C and Command+V instead of Ctrl+C and Ctrl+V. In Excel for the web, ribbon commands are also available, and some shortcuts or clipboard behavior can depend on the browser.
Related
- How to Close Excel Without Saving Changes
- Close Excel Without a Mouse Using Keyboard Shortcuts
- How to Close Excel When Frozen Without Losing Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Share a Google Calendar in Outlook: Step-by-StepTo see a Google Calendar in Outlook, copy its iCal address from Google Calendar and add it to…
- How to Insert Track Changes in a Word DocumentTo insert tracked edits in a Word document, open the file and select Review > Track Changes >…
- Google Sheets IF Not Empty: Formulas and Examples GuideTo make Google Sheets do something when a cell is not empty, use an IF test such as…
- How to Put Slide Numbers in PowerPoint on Every SlideTo put slide numbers in PowerPoint, open Insert > Slide Number, check Slide number, then select Apply to…
- Record Data in Excel Online: Setup, Sharing and TipsYes. You can record and manage data in Excel for the web by creating a workbook in OneDrive…
- Google Sheets Date Format: How to Turn It On and Set ItTo turn on date formatting in Google Sheets, select the cells you want to format, then choose Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.