To enter the same value in several Excel cells at once, select the cells, type the value, and press Ctrl+Enter on Windows. To copy content that is already in a cell, copy it, select the destination range, and paste; to copy a formula with adjusted references, use Fill Down or Fill Right. These methods work in Excel for Microsoft 365 on Windows, with Mac and web notes below.
What You’ll Need
- An Excel workbook with the cells you want to fill, plus the value, formula, or source range you want to copy.
- A clear idea of whether the destination cells should receive identical content, a copied formula with changing references, or a whole block of cells.
- For a workbook you care about, save your changes or make a copy before doing a large paste. You can usually undo a paste with Ctrl+Z, but a backup is a safer safeguard.
Step-by-Step
- Choose the right method. If you are entering a new identical value or formula into a selection, use Ctrl+Enter. If the content already exists in a cell and should be repeated, copy and paste. If a formula should adjust as it moves down or across rows, use Fill Down or Fill Right. If you are copying a block, plan for a destination area the same size as the source.
- Select the destination cells. Click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell to select a rectangle. You can also click the Name Box to the left of the formula bar, type a range such as B2:B20, and press Enter. Check the highlighted area before continuing; an unintended selection can overwrite data.
- Enter one identical item in all selected cells. With the destination cells selected, type the value, text, or formula. Do not click another cell or press Enter alone. Press Ctrl+Enter to put that entry into every selected cell. For example, selecting C2:C10, typing Pending, and pressing Ctrl+Enter enters Pending in each of those nine cells. If you are entering a formula this way, Excel enters the same formula in the selection; it does not work like copying a formula cell by cell to create shifting references.
- Copy a single existing cell into a range. Click the source cell and press Ctrl+C. Select the destination range, making sure its first cell is where you want the pasted content to begin, then press Ctrl+V. When the copied source is just one cell, Excel repeats that cell’s contents across the selected destination range. This can copy its value or formula and, by default, its formatting too. Press Esc when finished to clear the moving copy outline.
- Fill a formula down with changing references. Put the formula in the top cell of the intended column, then select that cell and the cells below it that should receive the formula. Press Ctrl+D. Excel copies the top cell down through the selection and adjusts relative references for each row. For instance, a formula in D2 that refers to B2 and C2 will normally refer to B3 and C3 when filled into D3. Use dollar signs in a formula reference when that row or column must stay fixed.
- Fill a formula or value to the right. Enter the source content in the leftmost cell of the selected row. Select that cell and the cells to its right, then press Ctrl+R. Excel copies the leftmost cell across the selection. Relative formula references adjust by column. If you prefer the ribbon, use Home > Fill > Right or Home > Fill > Down, as appropriate.
- Copy a multi-cell block. Select the whole source range, press Ctrl+C, select the top-left destination cell, and press Ctrl+V. For a straightforward copy, make the destination area the same number of rows and columns as the source. If you select a larger destination area for a multi-cell source, Excel may report that the copy and paste areas do not match; a one-cell source is the special case that can be repeated across a larger selection. Review the pasted block for overwritten information.
- Choose what gets pasted when needed. A normal paste copies both cell contents and formatting. To paste only values, copy the source, right-click the destination, and choose the Values paste option, shown with a clipboard icon and a 123 symbol in current Excel versions. You can also use Home > Paste to view the available paste choices. The exact icons and menu layout can vary slightly by update, so read the option labels before choosing.
- Check the result. Click a few cells in different parts of the filled area. Confirm that the value is correct, that formulas refer to the intended rows or columns, and that formatting looks right. If you replaced existing information by mistake, press Ctrl+Z promptly rather than trying to repair the range manually.
On Mac: Copy and paste use Command+C and Command+V. Excel for Mac commonly uses Control+Return to enter the same item in selected cells; check the shortcut shown in Excel’s menus if your keyboard or version behaves differently. Fill Down and Fill Right use Control+D and Control+R in Excel for Mac. In Excel for the web, the ribbon’s Home > Fill options are useful if a browser intercepts a shortcut; some shortcut behavior can depend on the browser and operating system.
Common Mistakes
Pressing Enter instead of Ctrl+Enter: Enter normally commits the entry and moves the active cell, rather than placing the entry in the entire selected range. Select the range again if needed, type the item, and use Ctrl+Enter.
Expecting Ctrl+Enter to adjust a formula: That shortcut is for entering the same item in a selection. To create row-by-row references, put the formula in the first cell and use Fill Down or copy and paste the formula cell into the cells below. Before filling, check whether references should be relative, absolute (with dollar signs), or mixed.
Selecting the wrong range: Pasting replaces existing content in the selected destination. Verify the address in the Name Box or look closely at the highlighted cells, especially when working far down a sheet or in a filtered table.
Copying a large block into an incompatible area: The destination for a multi-cell copy should match the source dimensions. If you want one item repeated, copy a single cell instead, or use Ctrl+Enter for a new entry.
Overlooking formatting or hidden content: A normal paste can bring over number formats, borders, colors, and formulas as well as the visible value. Use Paste Values when you need fixed results without the source formatting or formula.
Tips
- Use the Name Box for long ranges: typing A2:A500 is often faster and more precise than dragging.
- For a continuous range, select the first cell and use Ctrl+Shift+Down to extend the selection through a contiguous set of populated cells. Check the endpoint; blank cells can affect where selection stops.
- If you want to copy a formula while keeping one reference fixed, edit the formula to use an absolute reference such as $A$1 before filling. A reference like A$1 fixes the row only, while $A1 fixes the column only.
- Use Ctrl+D and Ctrl+R when you want Excel to copy from the top or left edge of a selected range. They are especially handy when the destination is adjacent to the source.
- For values only, use the Paste Values option rather than deleting formulas after pasting. That preserves the calculated result without leaving a live link to the source formula.
- After a large operation, check a few cells near the beginning, middle, and end of the range. This can catch a wrong selection or a reference that shifted unexpectedly.
Troubleshooting
Nothing appears in all the selected cells: If you expected the same new entry everywhere, select the destination cells, type the entry, and press Ctrl+Enter. If using copy and paste, check that you pressed Ctrl+C before selecting the destination and Ctrl+V afterward. If a cell is being edited rather than selected, press Esc, select the cells again, and repeat.
Excel says the copy and paste areas are different sizes: This usually happens when the copied source contains more than one cell and the destination selection has incompatible dimensions. Select a destination matching the source’s row and column count, or copy just one cell if the goal is to repeat one item across a larger area.
The formula results are identical or point to the wrong cells: If you used Ctrl+Enter, the same formula was entered throughout the selection. Undo, enter the formula in the first cell, and use Ctrl+D or Ctrl+R to create adjusted references. If you used Fill and a reference should not move, edit it to include the needed dollar sign, then fill again.
The pasted cells look different from the originals: A standard paste carries formatting, while Values paste does not carry the source’s appearance. Undo if necessary, then repeat using the paste option that matches your goal. If you only need the appearance, use the formatting paste option rather than pasting all content.
Only some cells changed, or Excel will not accept the selection: Check whether the range includes merged cells, protected cells, or a filtered list. Merged cells can prevent a rectangular paste, and protection can block edits. Unmerge or adjust the selection if appropriate, or ask the workbook owner to allow editing. With filtered data, take care: selecting a visible range and filling may not behave like filling an ordinary uninterrupted range, so test on a small area first.
Frequently Asked Questions
How do I put the same text in multiple Excel cells at once?
Select the cells, type the text, and press Ctrl+Enter on Windows. This is convenient for labels or status entries because it does not require copying a source cell first.
Can I copy one cell into several non-adjacent cells?
Excel’s ordinary multi-cell paste is designed for a continuous destination range, and pasting into a non-adjacent selection may be blocked. For a few separate cells, paste into each one individually. If you are entering the same new value, you can select multiple cells and use Ctrl+Enter where Excel allows that selection.
How do I copy a formula without changing its references?
Use absolute references, such as $A$1, for the parts of the formula that must remain fixed, then copy or fill the formula. If all references should remain exactly as written, consider pasting values instead when you need the current results rather than live formulas.
Does copying into multiple cells also copy formatting?
Yes. Standard copy and paste generally includes formatting along with the cell’s contents. Choose Paste Values if you want the result or text without the source formatting.
Can I fill cells on a Mac or in Excel for the web?
Yes. Excel for Mac supports these methods, with Command+C and Command+V for copy and paste and Control-based fill shortcuts. Excel for the web also provides Fill options on the Home ribbon; use those if a keyboard shortcut conflicts with your browser.
Related
- Excel Screen Lock: How to Unlock a Sheet or Unfreeze Panes
- Close Version History in Excel Without Losing Data
- How to Color an Excel Spreadsheet: Cells, Rows, and More
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation Reference Table Column ExplainedTo use an Excel table column as a data-validation dropdown list, create a defined name that refers to…
- Excel Cell Size: Adjust Row Height and Column WidthTo format cell size in Excel for Microsoft 365 on Windows, adjust the row height, the column width,…
- How to Insert a Row in Excel Without a Mouse: ShortcutsTo insert a row in Excel without a mouse, move to a cell in the row that should…
- Google Sheets SUMIF: Syntax, Examples, and Common FixesTo add values in Google Sheets only when matching cells meet a condition, use SUMIF. For example, if…
- Google Sheets Calendar Dropdown: How to Add a Date PickerTo add a calendar picker in Google Sheets, select the cells, choose Data > Data validation > Add…
- How to Delete Grouping in Excel: Rows, Columns & SheetsTo delete a row or column grouping in Excel, select the grouped rows or columns, then choose Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.