The fastest way to copy multiple cells at once
To copy multiple cells in Excel, select all the cells you want to copy, then press Ctrl+C (or Cmd+C on Mac). The cells will show a dotted border around them — that border means they are copied and ready to paste. Then click where you want to paste and press Ctrl+V.
The dotted border stays visible until you press Escape or paste somewhere else. This is useful because you can paste the same copied cells into multiple locations without copying again. Excel keeps the cells in its clipboard until you copy something new or close the file.
Key Takeaways
- Select the cells you need by clicking the first one, then holding Shift and clicking the last one in the range you want.
- Press Ctrl+C to copy — you will see a dotted border appear around the selected cells.
- Click the cell where you want the copied data to start, then press Ctrl+V to paste.
- You can paste the same copied cells multiple times without copying again, as long as the dotted border is still visible.
- Dragging the fill handle (the small square at the bottom-right corner of a selection) copies cells and fills a pattern downward or rightward automatically.
Selecting a range of cells to copy
The first step is telling Excel which cells you want to copy. Click on the first cell in the group. Then hold Shift and click on the last cell in the group. Excel will highlight all the cells between them in blue.
If the cells are not in a straight line or rectangle, use Ctrl+Click instead. Click the first cell, then hold Ctrl and click each additional cell you want to include. This works for scattered cells anywhere on the sheet. Each cell you Ctrl+Click adds to the selection without removing the ones you already chose.
You can also select an entire row or column by clicking the row number on the left side or the column letter at the top. If you need all the data in a sheet, press Ctrl+A to select everything at once.
Copying and pasting in the same sheet
Once your cells are selected, press Ctrl+C. You will see a dotted line (called a marching ants border) appear around the cells you selected. This dotted border tells you the cells are copied and waiting in Excel's clipboard.
Click on the cell where you want the data to appear — this is where the top-left corner of your copied cells will land. Then press Ctrl+V. The data pastes when ready. If you paste into cells that already have data, the new data will overwrite what was there.
The dotted border stays visible after you paste. You can paste the same cells again somewhere else without pressing Ctrl+C again. This is handy when you need the same data in multiple places. Press Escape when you are done pasting to clear the dotted border and remove the cells from the clipboard.
Copying cells to a different sheet or workbook
Copying to another sheet works the same way as copying within the same sheet. Copy your cells with Ctrl+C, then click on the sheet tab at the bottom of the window to switch to the other sheet. Click the cell where you want to paste and press Ctrl+V.
To copy to a different Excel file entirely, copy the cells from the first file, then switch to the second file (or open it if it is not already open) and paste. Excel keeps the copied cells in the clipboard even when you switch between files, so you do not have to copy again.
If you are moving cells rather than copying them — meaning you want to remove them from the original location — press Ctrl+X instead of Ctrl+C. The cells will still show the dotted border, but they will be cut rather than copied. When you paste them, they disappear from the original location.
Using the fill handle to copy cells downward or rightward
The fill handle is a small square at the bottom-right corner of a selected cell or range. When you hover over it, the cursor changes to a plus sign. You can drag this handle downward or rightward to copy the cells and automatically fill the pattern.
If you select a cell with a number and drag the fill handle down, Excel copies the cell and increases the number by one in each row (1, 2, 3, 4, and so on). If you select two cells with numbers that show a pattern (like 2 and 4), Excel continues the pattern when you drag (6, 8, 10, and so on). For text or dates, Excel repeats the same value unless it recognizes a pattern.
This method is faster than copy-and-paste when you need to fill many rows or columns with a repeating or incrementing pattern. Double-clicking the fill handle makes Excel automatically fill down to the last row that has data in an adjacent column, which saves you from dragging manually.
Pasting special: keeping or removing formatting
When you paste with Ctrl+V, Excel pastes both the data and the formatting — the colors, fonts, borders, and number formats from the original cells. Sometimes you want only the data without the formatting, or only the formatting without the data.
Press Ctrl+Shift+V instead of Ctrl+V to open the Paste Special dialog. This window shows you options: you can paste values only (the numbers and text with no formatting), paste formatting only, paste formulas, or paste comments. Choose what you need and click OK.
Paste Special is also useful when you copy from a website or another program and the formatting does not match your spreadsheet. Pasting values only strips away all the original formatting and lets your spreadsheet's own styles take over.
Undoing a copy or paste mistake
If you paste data in the wrong place or paste over something you needed, press Ctrl+Z when ready. This undo command reverses the last action — the paste will disappear and the cells will go back to what they were before. You can press Ctrl+Z multiple times to undo several actions in a row.
If you realize the mistake later and have already done other work, you can still undo, but you will also undo all the work you did after the paste. In that case, it is faster to manually delete the pasted data or retype what was overwritten.
Frequently Asked Questions
Can I copy cells from one Excel file and paste them into another?
Yes. Copy the cells with Ctrl+C in the first file, switch to the second file, click where you want to paste, and press Ctrl+V. Excel keeps the copied cells in the clipboard even when you switch between files, so you do not have to copy again.
What is the dotted border around my cells?
The dotted border (called a marching ants border) appears after you press Ctrl+C and shows that the cells are copied and ready to paste. It stays visible until you paste, press Escape, or copy something else. You can paste the same cells multiple times while the border is still there.
How do I copy cells without copying the colors and formatting?
Copy the cells normally with Ctrl+C, then press Ctrl+Shift+V to open Paste Special. Choose "Values" and click OK. This pastes only the numbers and text, leaving behind the colors, fonts, and number formats from the original cells.
Can I copy non-adjacent cells (cells that are not next to each other)?
Yes. Click the first cell, then hold Ctrl and click each additional cell you want to copy. All the cells you Ctrl+Click will be selected. Then press Ctrl+C and paste as usual. When you paste, the cells will paste in the same pattern they had in the original location.
What happens if I copy cells and then copy something else before pasting?
The new copy replaces the old one in the clipboard. The dotted border disappears from the first cells and appears around the new cells you copied. If you need to paste the first cells, you will have to copy them again.