How to Paste Into Multiple Cells in Excel

You need the same status, date or formula in 400 rows of a sign-up sheet, and pasting it one cell at a time is eating your afternoon. In Excel, copy one cell, select every cell you want filled, and press Ctrl+V: Excel pastes the copy into the whole selection. Or select the cells, type the entry once, and press Ctrl+Enter.

These steps cover Excel for Microsoft 365, Excel 2024 and Excel 2021 on Windows. Mac shortcuts are noted where they differ.

Pick the Right Method for the Job

Most “paste into many cells” jobs fall into one of a handful of patterns. Find yours in the table and jump to that section.

What you want	Fastest method
The same value or formula in many cells	Copy one cell and paste into a selection, or type once and press Ctrl+Enter
A small block repeated down a sheet	Copy the block and paste into a larger area
Values only, formats only, or math on existing numbers	Paste Special
Copies running down from a cell that already has the entry	Ctrl+D or the fill handle
Only the empty cells in a column	Go To Special, then Blanks
Only the rows a filter is showing	Go To Special, then Visible cells only
The same cells on several worksheets	Grouped sheets or Fill Across Worksheets

Paste One Cell Into Many Cells

This is the method most people need. Here’s a worked example: Odessa runs volunteer sign-ups for a fictional food bank. Names fill A2:A401, and she wants the word Confirmed in every cell of C2:C401.

1. Click the cell that holds the value or formula, such as C2 with Confirmed typed in it.
2. Press Ctrl+C (Command+C on a Mac), or right-click the cell and choose Copy. A moving dashed border shows what’s on the clipboard.
3. Select the destination. Drag across the range, or click the first cell, scroll down, and hold Shift while you click the last cell. To pick cells that aren’t next to each other, hold Ctrl (Command on a Mac) while you click each one.
4. Press Ctrl+V (Command+V on a Mac), or go to Home and click Paste. Every selected cell receives the copy.

Pasting replaces whatever was already in those cells, and Excel doesn’t ask first. If you grab the wrong range, press Ctrl+Z straight away to undo the paste. When you’re finished, press Esc to clear the moving border so a later Enter doesn’t paste again.

What Happens to Formulas

When the copied cell holds a formula, Excel adjusts relative references for each new spot. If D2 contains =B2*$F$1 and you paste it into D3:D401, D3 becomes =B3*$F$1, D4 becomes =B4*$F$1, and so on. The dollar signs lock the reference to F1, so every row still points at the same rate cell. Add dollar signs before you copy if part of the formula must stay fixed.

Type Once and Press Ctrl+Enter

Ctrl+Enter skips the clipboard entirely: it fills the selected cell range with the current entry.

1. Select every cell that should get the entry. Drag for a block, or hold Ctrl and click scattered cells.
2. Type the value or formula. It appears only in the active cell (the white one inside the shaded selection), which is normal.
3. Press Ctrl+Enter instead of Enter. Every selected cell fills at once.

If you press plain Enter by habit, only the active cell gets the entry and the selection moves on. Select the range again, retype, and use Ctrl+Enter.

Formulas work the same way here as with copy and paste. With E2:E401 selected, typing =D2*0.08 and pressing Ctrl+Enter gives each row its own adjusted formula. Ctrl+Enter is a Windows shortcut; on a Mac, check the macOS tab of Microsoft’s Excel keyboard shortcuts page for the matching keys.

This route is handy when you don’t want to disturb what’s on the clipboard, or when the value doesn’t exist anywhere in the sheet yet.

Paste a Block of Cells Into a Bigger Area

Sometimes the thing you’re repeating is more than one cell, such as a two-row pattern of Morning and Afternoon shifts. Copy the block, then select a destination whose height and width are exact multiples of it. A 2-row by 1-column block pasted into a 20-row selection repeats ten times.

If the destination isn’t a clean multiple, Excel may paste a single copy or show a message that the copy and paste areas don’t match. When you only want one copy, select just the top-left cell of the destination and paste. Excel fills down and to the right from there, overwriting whatever sits in its path.

Paste Only What You Need With Paste Special

A normal paste brings everything: value, formula, number format, borders and fill color. Often you only want part of that. After copying, go to Home, click the arrow under Paste, and pick an option. Microsoft’s Paste options page lists them, including:

• Formulas: the formula without the source formatting.
• Values: the results only, so formulas become plain numbers or text.
• Formatting: only the look (font, fill, number format), not the contents.
• Transpose: turns copied rows into columns and columns into rows.
• Keep Source Column Widths, Values & Source Formatting, Paste Link, Picture and Linked Picture for more specific cases.

For the full set, press Ctrl+Alt+V or choose Paste Special at the bottom of the Paste menu. The dialog adds choices such as Comments and Notes, Validation and Column widths, plus two features that matter for multi-cell pastes:

• Operation (Add, Subtract, Multiply, Divide) does math on the destination cells instead of replacing them.
• Skip blanks stops empty cells in your copied range from wiping out entries already in the destination.

Some options are greyed out depending on what you copied. That’s expected, not a fault.

Example: Raise 300 Prices by 5 Percent

1. Type 1.05 in any empty cell and copy it.
2. Select the price cells.
3. Press Ctrl+Alt+V, choose Values under Paste and Multiply under Operation, then click OK.
4. Delete the 1.05 helper cell.

Choosing Values instead of All keeps the prices’ existing number format. This works best on typed numbers; on formula cells, Excel folds the operation into each formula.

Fill Down or Drag the Fill Handle

When the cell you want repeated sits at the top of an empty range, filling is faster than copying.

• Ctrl+D: select the filled cell plus the cells below it, then press Ctrl+D. This copies the contents and format of the top cell into the cells below.
• Fill handle: select the cell and drag the small square at its bottom-right corner down or across. When you let go, an Auto Fill Options button appears so you can choose between copying the cells and filling a series. More fill options are on the fill data automatically page.
• Ctrl-drag: select a cell, hold Ctrl, point at the cell border, and drag to another spot to copy it there. Keep Ctrl held until after you release the mouse button, or Excel moves the cell instead.

If dragging a date or a number like Week 1 produces a running series when you wanted identical copies, open Auto Fill Options and choose Copy Cells.

Fill Only the Blank Cells in a Column

Imported lists often have gaps, such as a Region column filled in only on the first row of each group. You can target just the gaps without touching filled cells.

1. Select the range that contains the gaps, for example B2:B500.
2. Go to Home, then Find & Select, then Go To Special. (Ctrl+G and then Special gets you to the same dialog.)
3. Choose Blanks and click OK. Only the empty cells stay selected.
4. Type the value you want and press Ctrl+Enter.

To copy the entry above each gap instead, type an equals sign at step 4, press the Up arrow once, and then press Ctrl+Enter. Each blank now points at the cell above it. Once it looks right, copy the column and paste it back over itself with Paste Values, so later sorting doesn’t scramble those references. The Blanks option is one of several on the Go To Special dialog.

Paste Into a Filtered List

Filters hide rows, but a plain drag selection can still include cells in the hidden rows. Narrow the selection to visible cells before you type or paste.

1. Apply the filter and select the cells in the column you want to fill.
2. Go to Home, then Find & Select, then Go To Special, and choose Visible cells only. Click OK.
3. Type the entry and press Ctrl+Enter, or paste a single copied cell with Ctrl+V.
4. Clear the filter and spot-check a few rows that were hidden to confirm they didn’t change.

Be careful pasting a multi-cell block into a filtered list. Microsoft’s copy visible cells only page notes that pasted data lands in consecutive rows and columns, so a block can spill into rows you can’t see. Paste blocks into an unfiltered area, or one visible row at a time.

Paste the Same Data Into Several Sheets

If you keep one sheet per month or per location, you can fill the same cells on all of them together.

Before you start: while sheets are grouped, every change you make (typing, deleting, formatting) hits every sheet in the group. Ungroup as soon as you’re done.

1. Click the first sheet tab, then hold Ctrl and click each additional tab.
2. Check the title bar for [Group], which confirms grouping is on.
3. Type or paste in the active sheet. The same cells on every grouped sheet receive it.
4. Ungroup when you’re done: right-click any grouped tab and choose Ungroup Sheets, or click a tab that isn’t part of the group.

If the data already sits on one sheet, select that range, group it with the other sheets, and go to Home, then Fill, then Across Worksheets. Both routes are on the enter data on multiple worksheets page.

When Pasting Into Multiple Cells Fails

• A message about multiple selections. Depending on your version, Excel says “This action won’t work on multiple selections” or “That command cannot be used on multiple selections.” This usually means you copied scattered cells. A scattered copy works only when the cells sit in the same row, the same column, or line up into a rectangle (see this multiple selections troubleshooting article). Copy one continuous block, or copy each piece separately. Scattered destinations are fine when you copy a single cell.
• Merged cells in the way. Excel often refuses to paste across merged cells that don’t line up with what you copied. Unmerge them first; here’s how merging and unmerging cells works.
• The sheet is protected. Locked cells on a protected sheet won’t accept a paste. Unprotect the sheet or adjust the locked cell settings.
• Numbers turn into dates. Entries like 3-4 or 1/2 can become dates when pasted into cells with the General format. Format the destination as Text first, or see why Excel changes numbers to dates.
• The wrong thing pastes. If an older item keeps appearing, clearing the Office clipboard and copying again usually sorts it out.

Pasting Questions People Ask

Can I paste into every other row?

Yes. Type the value in the first cell and leave the cell below it empty, select both, and drag the fill handle down. Excel repeats the value-and-blank pair, so every second row gets the entry. Choose Copy Cells from Auto Fill Options if Excel tries to build a series.

Why did only part of my selection fill?

Two common reasons: you pressed Enter instead of Ctrl+Enter, or the copied block didn’t divide evenly into the destination, so Excel pasted one copy. Check the shape of what you copied against the shape you selected.

Will Skip blanks stop a paste from overwriting my data?

Only where the copied cell is empty. Any copied cell that holds something still replaces what’s in the destination. For a safety net, save first or paste into a spare column and compare.

Can I paste a formula so its references don’t change?

Lock the references with dollar signs (for example $B$2) before copying. A locked reference stays the same in every cell the formula lands in, while the parts without dollar signs keep adjusting.

Does this work in a table?

Yes. Pasting or using Ctrl+Enter inside an Excel table fills the selected cells like any range. If you type a formula into an empty table column, Excel may fill the whole column for you automatically.

Once the column is filled, Flash Fill is worth a look for entries that follow a pattern rather than repeating one value.