To copy only selected cells in Excel, select the exact cell or range you want, press Ctrl+C, click the destination’s top-left cell, and press Ctrl+V. Excel copies the selected cells—not the rest of the worksheet. If you need to leave out hidden rows or columns, or copy separate, nonadjacent cells, use the specific methods below because those selections behave differently.
The instructions are for Excel for Microsoft 365 on Windows. Copying cells transfers their contents and, by default, their formatting and formulas too. You can choose a different paste option if you want only values or another part of the copied cells.
What You’ll Need
- A workbook open in Excel with the cells you want to copy.
- A destination cell or range. For a regular paste, check that the destination has enough room and that you are not overwriting information you need to keep.
- For copying between workbooks, both workbooks open. You can also paste into another app, although the available formatting and paste options may differ.
Step-by-Step
- Identify the exact cells. Decide whether you need a single cell, a block of adjacent cells, visible cells from a filtered list, or several cells in different places. This matters: a normal rectangular selection is copied as one block, while nonadjacent selections and hidden rows need extra care. If you only want the displayed result of a formula, plan to use Paste Values rather than an ordinary paste.
- Select a single cell or a continuous range. Click a cell to copy just that cell. To select a block, click its first cell, hold the mouse button, and drag to the last cell. You can also click the first cell, hold Shift, and click the last cell; Excel selects the rectangle between them. For a range with known addresses, click the Name Box to the left of the formula bar, type an address such as B3:D8, and press Enter. Confirm the highlight covers only what you intend to copy.
- Copy the selection. Press Ctrl+C on Windows, or choose Home > Copy. A moving dashed border usually appears around the copied area. Copying does not remove or change the source cells. Avoid pressing Ctrl+X unless you intend to move the cells; Cut has different effects and can change references or overwrite destination content.
- Choose the destination’s top-left cell. Click the cell where the upper-left corner of the copied block should appear. For example, if you copied B3:D8 and want the block to start at F2, click F2. The copied block will occupy the corresponding number of rows and columns from that starting point. If you selected one cell, only that destination cell is filled.
- Paste the cells. Press Ctrl+V, or choose Home > Paste. Check the result before continuing: a normal paste can bring over values, formulas, number formats, borders, fills, and other cell formatting. If the source contains formulas, Excel usually adjusts relative cell references to fit the new location. That is expected behavior, but it can affect the results.
- Choose a paste type when you need less than the whole cell. After copying, click the destination, then choose Home > Paste > Paste Special. Select Values to paste the displayed results without formulas, or choose another available option such as Formulas or Formats if that is what you need. The Paste Options button that appears after a paste can also offer quick choices. Menu labels and available options can vary slightly by Excel build.
- Copy only visible cells when rows or columns are hidden. If a list is filtered or rows are manually hidden, a normal selection can include hidden cells. Select the range, then on Windows press Alt+; to select visible cells only. Alternatively, choose Home > Find & Select > Go To Special, select Visible cells only, and choose OK. Then copy and paste. On Mac, use Home > Find & Select > Go To Special > Visible cells only; the Windows Alt+; shortcut is not the Mac shortcut. In Excel for the web, use the available Go To Special or visible-cell selection options if present; if they are unavailable, open the workbook in the desktop app for this operation.
- Handle separate cells one at a time if Excel rejects a multi-area copy. On Windows, hold Ctrl while clicking separate cells or ranges; on Mac, use Command-click. This makes a nonadjacent selection, but Excel does not reliably allow all multiple-area selections to be copied and pasted as one block. If you see an error, copy each area separately to its own destination, or first arrange the wanted values together in a temporary contiguous range and copy that range. Remove the temporary range when you are finished if it is no longer needed.
- Finish and clear the copy outline. After the paste, check that the destination contains the intended cells and that surrounding data remains intact. Press Esc to clear the moving dashed copy border. If you pasted into the wrong place, use Ctrl+Z immediately to undo the paste, then repeat with the correct destination. On Mac, use Command+Z.
Common Mistakes
Selecting a larger rectangle than intended: When you select two distant cells by clicking one and Shift-clicking another, Excel includes every cell in the rectangle between them. It does not select just the two endpoints. For isolated cells, use Ctrl-click on Windows or Command-click on Mac, and remember that copying the resulting multiple areas may require separate copy operations.
Assuming a filtered range means visible cells only: A filter hides rows from view, but a regular selection can still involve hidden cells. Use Visible cells only before copying when you must exclude them. Check the pasted row count and values, especially when the destination is used for a report or a separate list.
Overwriting destination data: A multi-cell paste fills a rectangle starting at the destination cell. It can replace existing contents in that footprint. Before pasting, check the dimensions of the selected range and choose an empty destination area, or undo immediately if you pasted over something important.
Expecting formulas to remain identical: A normal copy adjusts relative references. For instance, a formula referring to the cell directly above may point to a different cell after it is pasted elsewhere. Use Paste Special > Values if you want the current calculated results, or review formulas after pasting if you need them to keep their original references.
Confusing copy with cut: Ctrl+X cuts cells rather than making a duplicate. It can remove the original content after the move is completed. Use Ctrl+C when you want the source to stay in place.
Tips
For a large but exact range, use the Name Box instead of dragging across the sheet. Typing C5:F20 selects that rectangle directly and reduces the chance of including an extra row or column. Before copying, look at the highlighted range and confirm its corners match the intended first and last cells.
If your goal is to copy only the data and not its appearance, Paste Values is usually the right choice. It keeps the results visible in the source cells but does not carry the source formulas. If you need the formulas but not the formatting, choose the appropriate Paste Special option rather than using the default paste.
When copying a formula that must continue to refer to the same fixed cell, check whether its references are absolute (with dollar signs) before copying. You can edit the formula or make the reference absolute in the source, then copy. Do not assume every formula should be fixed: relative references are useful when you want a formula pattern to shift with its new position.
To copy cells into another workbook, open both workbooks, copy the source selection, switch to the destination workbook, and click its target cell before pasting. If you paste into another program, such as an email or document, Excel may transfer a table or formatted text rather than editable spreadsheet cells. For dependable results, paste into Excel first and then choose the desired output format.
On Mac, use Command+C and Command+V for copy and paste. On Windows, use Ctrl+C and Ctrl+V. The ribbon commands are useful if keyboard shortcuts are intercepted by a browser, remote desktop, or another application. Excel for the web also supports standard copy and paste, though browser permissions and selection features can differ from desktop Excel.
Troubleshooting
Excel says the command cannot be used on multiple selections: You probably selected separate areas. Copy one area at a time, or place the cells together in a temporary adjacent range and copy that. Avoid trying to paste scattered cells as a single rectangular block; Excel cannot infer where each separate piece should go.
Hidden rows appear in the pasted result: Undo the paste, reselect the source range, choose Visible cells only using Alt+; on Windows or Go To Special on Mac, and copy again. If the sheet is filtered, confirm the filter is still active and that you selected the intended list range rather than entire columns that include unrelated data.
The paste button is unavailable or nothing happens: Make sure you copied cells in Excel and have not pressed Esc or copied something else since. Click a normal, editable destination cell and try Ctrl+V again. A protected sheet, merged cells, an active cell-editing cursor, or a selection with incompatible dimensions can prevent a paste. Press Esc once to leave cell-editing mode, then try again. If the destination is protected, check whether editing is allowed or use an unprotected destination.
The pasted result looks different: Excel’s default paste brings formatting along. Undo and use Home > Paste > Paste Special > Values if you only want results, or choose Formulas or another suitable option. If the issue is a changed formula result rather than appearance, inspect the formula references in the destination cell.
The copy border remains on screen: The dashed border means Excel still has the copied cells on the clipboard; it does not mean the cells were moved. Press Esc to cancel the copy state. If you pasted into the wrong location, use Undo before doing more edits.
Frequently Asked Questions
Can I copy just one cell from a larger selected range?
Yes. Click the individual cell you want, press Ctrl+C on Windows or Command+C on Mac, then select the destination and paste. Do not copy the larger range if only one cell is required.
How do I copy nonadjacent cells in Excel?
Use Ctrl-click on Windows or Command-click on Mac to select separate cells, but note that Excel may not let you copy multiple separate areas together. If it reports that the command cannot be used on multiple selections, copy each cell separately or bring the wanted cells together in a temporary range.
How do I copy only visible cells from a filtered list?
Select the filtered range and choose Visible cells only before copying. On Windows, Alt+; is the shortcut; you can also use Home > Find & Select > Go To Special > Visible cells only. On Mac, use the Go To Special menu because the Windows shortcut differs.
Will copying cells copy formulas and formatting?
Yes. A normal paste usually copies formulas, values, and formatting. Formula references may adjust to the destination. Use Paste Special and choose Values if you want the displayed results without formulas, or select another paste type for a more specific result.
Can I copy selected cells to another worksheet or workbook?
Yes. Copy the selection, switch to the other sheet or open workbook, click the destination’s top-left cell, and paste. If you are copying a block, ensure the destination has enough empty space and then check the pasted formulas and formatting.
How do I stop Excel from copying the source formatting?
After copying, use Home > Paste > Paste Special and select Values if you need only the cell results. If you want formulas without the source appearance, choose the formulas-only paste option when it is available in your Excel version.
Related
- How to Combine Cells in Excel Without Losing Data Safely
- How to Combine Columns in Excel Without Losing Data
- How to Combine CSV Files in Excel with Power Query
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Remove Merged Cells in Google SheetsTo remove merged cells in Google Sheets, select a merged cell or range, then choose Format > Merge…
- Google Sheets: Count Cells by Highlight ColorGoogle Sheets does not have a built-in COUNTIF function that counts cells just because they are highlighted with…
- Excel Shortcut Codes: Essential Keys and How They WorkExcel shortcut codes usually means keyboard shortcuts: press a key or combination of keys to run a command…
- How to Freeze One Column in Excel While You ScrollTo keep Excel’s first column visible while you scroll sideways, choose View > Freeze Panes > Freeze First…
- Excel: Insert a New Row Every Other RowYes. To insert a genuinely blank worksheet row between each record, select the data rows—not the header—and run…
- How to Set Out of Office in the Outlook Mobile AppTo set an out-of-office reply in Outlook mobile, open the app’s Settings, select the email account, choose Automatic…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.