To copy in Excel without dragging, select the cell or range, press Ctrl+C, select the destination, and press Ctrl+V. To repeat a value or formula down or across adjacent cells, select the source together with the cells to fill, then use Ctrl+D for down or Ctrl+R for right. These methods avoid the fill handle and work in Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook open in the desktop version of Microsoft Excel. Save your work before making a large replacement or fill.
- The cell or range you want to copy, and a clear idea of where the copied content should go.
- A keyboard, if you want to use the shortcuts. You can also use the Home tab commands described below.
On a Mac, use Command+C and Command+V for ordinary copy and paste instead of Ctrl+C and Ctrl+V. The Fill Down and Fill Right commands are also available from the Home tab, so you can use those if a shortcut behaves differently on your keyboard. Excel for the web has similar commands, but some browser shortcuts may be intercepted by the browser.
Step-by-Step
- Choose the copying method that fits the job. Use copy and paste when you want to put a cell, formula, or block of cells somewhere else. Use Fill Down or Fill Right when you want Excel to repeat the top row or leftmost column through neighboring cells. This distinction matters: copy and paste can move content to a separate area, while Fill commands work across a selected adjoining range.
- Select the source cell or range. Click the cell you want to copy. For a block, click the first cell and drag across the block if selecting it with the mouse is convenient; that is only selecting, not dragging the fill handle. You can also click the first cell, hold Shift, and click the last cell of the block. The selected range appears highlighted, and its address is shown in the Name Box to the left of the formula bar.
- Copy the selection. On Windows, press Ctrl+C. On Mac, press Command+C. Alternatively, choose Home > Copy, or right-click the selected cell and choose Copy. A moving dashed outline around the source usually indicates that Excel has placed it on the clipboard. Do not press Esc yet, because that cancels the copy outline.
- Select the destination. Click the top-left cell where the copied content should begin. For a larger block, make sure the destination has enough room and does not overlap content you need to keep. To jump to a distant cell or range, click the Name Box, type an address such as G4 or G4:J8, and press Enter. If copying a multi-cell block, choose a destination of the same shape unless you specifically intend to repeat the copied pattern.
- Paste the copied cells. Press Ctrl+V on Windows or Command+V on Mac. You can also choose Home > Paste. Excel places the copied cells at the destination, generally including their contents, formulas, and formatting. If a warning says the destination will be overwritten, check the selected area before proceeding. After pasting, press Esc to clear the moving outline if it remains visible.
- Fill a column without dragging. Enter or keep the item to repeat in the first cell. Select that cell and all the cells below it that should receive the entry. For example, if A2 contains the source and you want it copied through A12, select A2:A12. Press Ctrl+D on Windows, or choose Home > Fill > Down. Excel copies the contents and formatting from the top cell through the selected range. The source must be the top row of the selection.
- Fill a row without dragging. Put the source in the leftmost cell, then select it together with the cells to its right. For example, if B3 is the source and the row should continue through G3, select B3:G3. Press Ctrl+R on Windows, or choose Home > Fill > Right. Excel fills the selected cells using the leftmost cell as the source. If the source is not at the far left of the selection, the result may not be what you intend.
- Check what Excel copied. Look at the destination cells and, if the copied content includes a formula, click one of the filled cells and inspect the formula bar. Relative references may shift to match the new position. For example, copying a formula that refers to B2 one column to the right can make the reference point to C2. If you wanted an identical reference instead, use absolute references such as $B$2 in the original formula before copying.
- Use Paste Values when formulas should become fixed results. Copy the source as usual, then open Home > Paste and choose the Values option. This pastes the displayed results rather than the formulas. It is useful for sharing a snapshot or preventing future recalculation, but it does not preserve the original formula logic. Check the pasted results before deleting or changing the source.
For Excel for the web, select the cells and use the Home tab’s Copy and Paste commands or the keyboard shortcuts when they work in the browser. Fill Down and Fill Right are available from the Home tab as well. If the browser captures a shortcut, use the ribbon command rather than repeatedly pressing keys.
Common Mistakes
- Selecting the wrong range for Fill Down or Fill Right. Fill Down takes its source from the top row of the selection; Fill Right takes its source from the leftmost column. Include the source cell in the selection, and verify that it is at the correct edge.
- Confusing Fill with ordinary paste. Ctrl+D does not paste the contents of the Windows clipboard. It fills from the top cell in the selected range. Ctrl+R similarly fills from the leftmost cell. For a distant destination or a differently sized block, use Copy and Paste.
- Overwriting existing data. Pasting a copied block can replace content in the destination. Before you paste, confirm the active cell and check whether the target range contains anything you need. Use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the paste replaced something unintentionally.
- Expecting formulas to stay identical. Excel adjusts relative cell references when formulas are copied. This is useful when repeating calculations row by row, but can cause unexpected results if a reference should remain fixed. Use dollar signs in the formula’s references where appropriate, and inspect a copied formula before filling a long range.
- Copying formatting you did not want. A normal paste can bring formatting along with the cell contents. If you only need the value, use Home > Paste > Values. If you need only the appearance, use the Paste options for formats rather than pasting the entire cell.
- Pressing Esc before pasting. Esc cancels the active copy operation. If the dashed outline disappears before you select the destination, copy the source again.
Tips
- Use the Name Box for precise selections. Click the box left of the formula bar, enter an address such as C5:C100, and press Enter. This is faster and less error-prone than scrolling through a long worksheet to select a destination. You can type a single cell address or a rectangular range.
- Use keyboard selection to extend a range. Click the source cell, then hold Shift and use the arrow keys to extend the selection. On Windows, Ctrl+Shift+Down can extend a selection to the next edge of a data region, but it may select much farther than intended when blanks or adjacent data affect the boundary. Check the highlighted cells before filling.
- Fill a formula down a known range in one move. Enter the formula in the first cell, select that cell and the intended cells below it, then use Ctrl+D or Home > Fill > Down. This avoids copying each row individually. Review the last few results, especially if the sheet contains blank rows or different kinds of records.
- Choose the paste option deliberately. Normal paste generally brings over formulas and formatting. Values-only paste is suited to fixed results, while a formats-only paste is suited to appearance. After pasting, Excel may show a Paste Options button near the destination; use it to adjust the paste if the option you need is available.
- Keep the source intact until you verify the result. Copying does not remove the original cells. Check the pasted block, formulas, and formatting before clearing the source. If you need to move rather than copy, cut and paste is a different operation and removes the original content from its starting location.
Troubleshooting
Ctrl+C or Ctrl+V does not work: Make sure the worksheet is active and you are not currently typing inside a cell or the formula bar. Press Esc or Enter to finish editing, select the cell again, and retry. On Mac, use Command+C and Command+V. In a browser, try the Home tab commands if a shortcut is being captured by the browser.
Ctrl+D fills the wrong value: Check the selected range. The top cell is the source for Fill Down, so the value or formula you want to repeat must be in that cell. For Fill Right, check that the intended source is in the leftmost selected cell. Correct the selection and run the Fill command again.
The formula result changes after copying: This is usually caused by relative references adjusting to the new location. Compare the source and destination formulas in the formula bar. If a reference should remain fixed, edit the original formula to use an absolute reference, such as $B$2, and repeat the copy or fill. If the copied formula is already wrong, undo the fill, correct the source, and fill again.
Excel says the copy and destination areas are different sizes: For a multi-cell copy, select a destination that matches the copied range’s dimensions, or click only the destination’s top-left cell and paste there. Make sure the destination is large enough and does not intersect a merged-cell layout that prevents the paste. If the source includes merged cells, try unmerging the relevant cells or copying a range with the same merged structure.
The pasted content has unwanted colors, borders, or number formats: Undo the paste if needed, copy the source again, then use Home > Paste > Values to paste only results. If you want formulas but not the source formatting, use the Paste options to choose a formula-oriented paste option where available. Confirm the output because paste choices can vary with the copied content.
The selection jumps too far or stops early: Worksheet boundaries and blank cells affect keyboard navigation. If Ctrl+Shift+Down selects too many or too few cells, click the Name Box and type the exact range instead. If you are unsure of the final row, select a smaller block first and verify it visually before applying Fill Down.
Frequently Asked Questions
Can I copy cells in Excel without using the mouse?
Yes. Select the source with the keyboard, press Ctrl+C on Windows or Command+C on Mac, move to the destination, and press Ctrl+V or Command+V. For a known range, use the Name Box to select it by address.
What is the shortcut to copy a cell down without dragging?
Put the source in the top cell, select it and the cells below that should be filled, then press Ctrl+D on Windows. On Mac, use Home > Fill > Down if the shortcut is unavailable or differs with your keyboard setup.
What is the shortcut to copy a cell across a row?
Select the source in the leftmost cell along with the cells to its right, then press Ctrl+R on Windows. You can also choose Home > Fill > Right. The source must be at the left edge of the selection.
Does copying a formula copy the same formula exactly?
Not necessarily. Excel changes relative references to match the formula’s new location. Absolute references marked with dollar signs stay fixed when copied. Check the formula bar at the destination to confirm that the references point where you intend.
How do I copy only the result, not the formula?
Copy the cell, select the destination, then choose Home > Paste > Values. The destination receives the current result rather than the formula that produced it, so it will not update if the original inputs change.
Can I copy a range to another worksheet without dragging?
Yes. Select the range, copy it, open the destination worksheet, select the top-left destination cell, and paste. Check that the destination area has enough space and that formulas referencing other sheets still point to the intended cells.
Related
- How to Close Editing Mode in Excel Without Losing Work
- How to Close an Excel File With a Keyboard Shortcut
- Enable Editing in Excel: Exit Protected View
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a Label Template in Word: Step-by-Step GuideTo create a reusable label template in Microsoft Word, open Mailings > Labels, choose the label brand and…
- How to Delete a Page Range in Word Without Losing TextTo delete a page range in Word, select the content from the beginning of the first page through…
- How to Create a Signature Line in Microsoft OutlookTo create an email signature line in Outlook, open the signature settings for your version of Outlook, write…
- Keyboard Shortcut for X Mark in Excel and Other OptionsFor a multiplication-style x (×), hold Alt and type 0215 on the numeric keypad, then release Alt; Excel…
- Can You Create Outlook Rules in OWA? Here’s HowYes. You can create and manage Outlook rules in Outlook on the web (OWA) to sort incoming email,…
- How to Export an Excel Table to Word Without Losing FormatTo export an Excel table to Word, select the table in Excel, copy it, and paste it where…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.