Copy Text into Multiple Cells in Excel: A Quick Guide

How-to basics · Updated November 20, 2026

To put the same text in several Excel cells at once, select the cells, type the text, and press Ctrl+Enter on Windows; on Mac, use Control+Return. You can also copy a cell and paste it into a selected range, or use Fill for a row or column. These methods work in Excel for Microsoft 365 on Windows and are useful for labels, status notes, categories, and repeated instructions.

What You’ll Need

  • An Excel workbook open in the desktop app. The steps below use Excel for Microsoft 365 on Windows; Mac notes are included where shortcuts differ.
  • The text you want to repeat. You can type it during the steps or copy it from another cell, document, or source.
  • A clear idea of which cells should receive the text. If the destination range already contains information, decide whether it is safe to replace it before proceeding.

Step-by-Step

  1. Choose the destination cells. Click the first cell and drag across a continuous range, such as B2:B12 for a column or B2:F2 for a row. You can also click the first cell, hold Shift, and click the last cell to select the range. To select a larger block, such as B2:D12, drag from the top-left cell to the bottom-right cell. Check the highlighted selection before entering anything: every selected cell is a potential destination.
  2. Enter the same text in every selected cell with Ctrl+Enter. Keep the range selected, type the text, and do not press Enter by itself. On Windows, press Ctrl+Enter. Excel puts the entry in each selected cell and keeps the range selected. On Excel for Mac, use Control+Return. For example, selecting C2:C8, typing Pending, and pressing Ctrl+Enter puts Pending in all seven cells. This is usually the quickest method when the text is not already in a worksheet cell.
  3. Use this method for a nonadjacent selection when needed. To target separate cells, hold Ctrl on Windows and click each one, such as A2, A5, and A9. Type the shared text and press Ctrl+Enter. On Mac, hold Command while selecting separate cells, then use Control+Return to enter the text. If Excel does not accept the disjoint selection or changes what is selected, fill one group at a time instead. Avoid clicking another cell after selecting the targets, because that can replace the multi-cell selection.
  4. Copy an existing cell and paste it into a range. Click the cell that contains the text and press Ctrl+C. Select the destination range, then press Ctrl+V. A copied single cell can be pasted repeatedly through a selected range. On Mac, use Command+C and Command+V. This option is handy when the source cell has the exact spelling, capitalization, or formatting you want to reuse. If you only want the words and not the source cell’s formatting, use Paste Special in the next step.
  5. Paste only the text or value if formatting should stay different. After copying the source cell, select the destination range. On Windows, open Home > Paste and choose Values, if that option is shown in the Paste menu. This copies the cell contents without carrying over the source formatting. Depending on your Excel version and the copied content, Paste Special may offer a Values option as well. If you want both the text and the original appearance, use ordinary Ctrl+V instead. Check the destination after pasting, especially if the source cell has a fill color, border, or number format.
  6. Fill down from a starting cell. Enter the text in the top cell of a continuous column range, such as D2. Select D2 and the cells below it that should receive the same entry, for example D2:D10. On Windows, press Ctrl+D, or choose Home > Fill > Down. Excel copies the top cell’s contents and formatting down through the selected range. On Mac, use the Fill Down command from the Home tab if the keyboard shortcut differs in your setup. This method is especially convenient when you are already working with a column and want the top cell to act as the source.
  7. Fill across a row. Enter the text in the leftmost cell, select that cell and the cells to its right, then press Ctrl+R on Windows or choose Home > Fill > Right. Excel copies the contents of the leftmost cell to the rest of the selected row range. For instance, entering Review in E3 and filling E3:H3 puts the same entry in four cells. If you need a rectangular block rather than a single row or column, Ctrl+Enter is often simpler because it fills the whole selection with the text you type.
  8. Use the fill handle for a visual copy. Enter the text in one cell and select it. Move the pointer to the small square at the bottom-right corner of the cell border, called the fill handle. When the pointer changes to a small black plus sign, drag the handle over the neighboring cells. Release the mouse button to copy the cell. Drag down to fill a column or sideways to fill a row. If the fill handle is not visible, check File > Options > Advanced and make sure Enable fill handle and cell drag-and-drop is selected. Excel for Mac has a similar fill handle; drag it over the target cells.
  9. Confirm the result and save. Click a few filled cells, including the first and last destination, and check the formula bar to confirm the text is present. If the task required preserving existing formatting, make sure the appearance is still right too. Save the workbook with Ctrl+S on Windows or Command+S on Mac. If you notice that you filled the wrong area, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo the last action, then select the correct range and repeat.

Common Mistakes

Pressing Enter instead of Ctrl+Enter: Enter normally commits the value to the active cell and moves the selection. It does not fill the rest of a selected range. If you need the same typed text in every selected cell, keep the range highlighted and use the combined shortcut.

Selecting the wrong range: A drag that starts one row too high or extends too far can overwrite unrelated data. Look at the highlighted cells and the Name Box, to the left of the formula bar, before you type or paste. If the range is large, click the Name Box and type an exact address such as D2:D50, then press Enter.

Overwriting existing information: Pasting or filling replaces contents in destination cells. Excel may not give a separate warning for ordinary cell contents. If the cells matter, copy the worksheet first, or undo immediately if you see an unintended replacement.

Copying formatting you did not want: Standard copy and paste can carry cell formatting along with the text. Use a Values paste option when available, or type the text into the selection with Ctrl+Enter to avoid copying the source cell’s appearance. Do not assume that two cells will look the same just because their text matches; number formats, borders, and fills are separate properties.

Accidentally creating a formula: Excel interprets an entry starting with an equals sign as a formula. If you need the characters to appear literally, start the entry with an apostrophe, such as ‘=Ready, and then fill the cells. Excel uses the apostrophe to mark text and does not display it as part of the cell value. Also check for leading spaces if the repeated text seems not to match exactly.

Tips

For a one-time entry across a block, Ctrl+Enter is usually the most direct choice: it avoids making a source cell and does not require dragging. For a long column where the first cell is already correct, Fill Down or Ctrl+D is easy to repeat. Use the fill handle when you can see the target cells and want to copy by dragging. Pick one method based on the shape of the destination rather than combining several methods unnecessarily.

When your selection is a whole column, consider selecting only the rows that actually need the text. Filling an entire worksheet column can slow the workbook and make later filtering or sorting less clear. For example, if a table currently has records in rows 2 through 40, select just those rows rather than all of column E. If the table will grow, you can fill the new rows when you add them.

If the repeated text is a category used in many places, make a small source list or copy the approved spelling from an existing cell. That helps avoid subtle inconsistencies such as Complete, Completed, and complete being treated as different labels in filters or reports. For a one-off update, still check the spelling in the formula bar before filling a large range.

Keep an eye on selection boundaries when using keyboard shortcuts. Ctrl+D and Ctrl+R copy from the top cell or leftmost cell of the selected region; they do not use whatever cell you last copied. If that starting cell is blank or contains a different label, the result will be wrong. Before using Fill Down or Fill Right, verify the source edge of the selection.

When you are using Excel for the web, the basic typing and paste methods are available, but shortcuts or ribbon details can vary by browser and keyboard. If a desktop shortcut does not work as expected, select the range and use the Home tab commands, or use Ctrl+Enter after typing the value. Mac users should remember that copy and paste commonly use Command+C and Command+V, while entering data into a selected range uses Control+Return.

Troubleshooting

Only one cell changed: The range may have lost its selection before you pressed the shortcut, or you may have pressed Enter alone. Select the intended cells again, type the text, and press Ctrl+Enter on Windows or Control+Return on Mac. You can also type the value in the first cell, select the full range with that first cell included, and use Home > Fill > Down for a column.

The paste did not fill the entire range: Make sure you copied one cell, not a multi-cell block with a different shape, and then select the destination cells before pasting. A multi-cell copied area may paste as a block or produce a size mismatch. Press Esc to cancel a moving copy border if necessary, copy the single source cell again, and try the destination range. If the source range and target range differ, use Ctrl+Enter to enter typed text or paste in matching-sized blocks.

Excel filled a sequence instead of repeating the text: This can happen when dragging the fill handle from values Excel recognizes as a series, such as dates or numbered labels. Use Ctrl+Enter for a plain repeated entry, or hold Ctrl while dragging the fill handle to switch between filling a series and copying, when that modifier is supported in your Excel setup. Another reliable option is to copy the source cell and paste it into the selected destination cells.

The destination cells look different afterward: You likely pasted the source formatting. Undo with Ctrl+Z or Command+Z if the action is still the most recent change, then copy again and choose a Values paste option. If the contents are already correct and you only need to restore formatting, use Format Painter or apply the desired formatting separately; avoid repeating a full paste that could overwrite other edits.

The text appears with a leading apostrophe or as a formula: A leading apostrophe is normally a text marker and is not displayed in the cell, but check the formula bar to see exactly what is stored. If a value beginning with = was interpreted as a formula, undo, then re-enter it with an apostrophe before the first character. If the cell displays an error, inspect the beginning of the entry and confirm that Excel is treating it as text.

A keyboard shortcut does something else: Confirm that the correct cells are selected and that Excel has focus, rather than another open window. On Mac, use Command for ordinary copy and paste, but Control+Return for the selected-range entry method. If a shortcut is intercepted by your keyboard settings or browser, use the corresponding Home tab command, or enter the text into the selected range and use the menu or ribbon option available in your version.

Frequently Asked Questions

How do I put the same text in multiple Excel cells at once?
Select the destination cells, type the text, and press Ctrl+Enter on Windows. In Excel for Mac, press Control+Return. Excel fills each selected cell with the entry.

Can I copy text into cells that are not next to each other?
Yes. On Windows, hold Ctrl and click each destination cell, type the text, and press Ctrl+Enter. On Mac, hold Command while selecting cells and use Control+Return. If Excel will not accept a disjoint selection, fill each group separately.

How do I repeat a cell down a column?
Enter the text in the first cell, select it together with the cells below, and press Ctrl+D on Windows. You can also choose Home > Fill > Down. Check that the first cell in the selected range contains the text you want to repeat.

How do I fill the same text across a row?
Enter it in the leftmost cell, select that cell and the cells to its right, then press Ctrl+R on Windows or use Home > Fill > Right. To enter new text across the row without a source cell, select the row range, type the text, and press Ctrl+Enter.

Will copying one cell also copy its formatting?
Ordinary copy and paste can copy both contents and formatting. To keep the destination cells’ existing appearance, choose a Values paste option when available, or type the text into the selected range with Ctrl+Enter.

Can I use these steps in Excel for the web?
Yes, you can select a range, type the text, and use Ctrl+Enter in many browser setups, as well as copy and paste cells. Browser shortcuts can vary, so if a shortcut is intercepted, use the Home tab or try the corresponding ribbon command.

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.