The basic way to select and copy a single cell or range
To copy data in Excel, you first select the cells you want, then copy them. The simplest selection is a single cell: click on it once, and it becomes highlighted with a blue border. To select a range of cells in a rectangle — say from A1 to D5 — click on the first cell (A1), then hold Shift and click on the last cell (D5). Excel highlights all cells between them.
Once your cells are selected, press Ctrl+C on Windows or Command+C on Mac. You will see a moving dotted border around your selection, which tells you the cells are copied and ready to paste. This dotted border stays visible until you paste or press Escape.
Key Takeaways
- Click a single cell to select it, or click and drag across multiple cells to select a rectangle of data.
- Use Shift+click to select a range without dragging — click the first cell, hold Shift, then click the last cell.
- Hold Ctrl (or Command on Mac) and click separate cells or ranges to select multiple non-adjacent areas at once.
- Press Ctrl+C to copy your selection; the moving dotted border shows the cells are ready to paste.
- Select an entire row or column by clicking its number or letter on the left or top edge of the spreadsheet.
Selecting by clicking and dragging
The most direct way to select a group of cells is to click on the first one and drag to the last. Click on cell A1, hold the mouse button down, and drag diagonally to D5. As you drag, Excel highlights every cell you pass over. When you reach the last cell you want, release the mouse button.
This method works well for small selections you can see on screen. For larger ranges or when the end cell is not visible, dragging becomes awkward — you have to drag all the way to the edge of the screen and wait for it to scroll, which is slow and error-prone. In those cases, the Shift+click method is faster.
Using Shift+click for ranges you cannot see in one view
When your data spans more rows or columns than fit on your screen, Shift+click is the reliable way to select without dragging. Click on the first cell of your range (A1), then scroll down or right to find the last cell you want (say, D500). Hold Shift and click on that last cell. Excel selects every cell in the rectangle between them, even though you cannot see all of them at once.
You can also type the range directly into the Name Box — the field that shows the current cell address, located to the left of the formula bar at the top of the spreadsheet. Click the Name Box, type A1:D500, and press Enter. Excel selects that entire range when ready. This method is the fastest when you know exactly which cells you need.
Selecting multiple separate areas at once
Sometimes you need to copy cells that are not next to each other — for example, column A and column C, but not column B. Hold Ctrl (or Command on Mac) and click on the first cell or range you want. Then, while still holding Ctrl, click on another cell or drag to select another range. Excel highlights both areas. You can add as many separate selections as you need by continuing to hold Ctrl and clicking.
When you copy a multi-area selection, Excel copies each area separately. When you paste, it pastes them in the same pattern — the first area goes to the first location, the second area to the second location, and so on. This is useful when you want to reorganize data or copy specific columns from different parts of a spreadsheet.
Selecting entire rows and columns
To select a whole row, click on the row number on the left edge of the spreadsheet — click on 5 to select the entire fifth row. To select a whole column, click on the column letter at the top — click on C to select the entire column C. The entire row or column highlights in blue.
You can select multiple adjacent rows or columns by clicking the first one and Shift+clicking the last. Click row 5, then Shift+click row 10 to select rows 5 through 10. To select non-adjacent rows or columns, hold Ctrl and click each one separately. Selecting entire rows or columns is useful when you want to copy all the data in a column regardless of how many rows it contains, or when you need to move or delete a whole row.
Selecting all cells in a spreadsheet
To select every cell in the current spreadsheet, press Ctrl+A on Windows or Command+A on Mac. The entire sheet highlights. If you press Ctrl+A a second time, Excel selects all cells across all sheets in the workbook. This is rarely needed for copying, but it is useful when you want to explore formatting to an entire sheet or delete all content at once.
You can also click the Select All button — the small rectangle where the row numbers and column letters meet, in the top-left corner of the spreadsheet grid. This selects every cell on the current sheet.
What happens after you copy
After you press Ctrl+C, the dotted border stays around your selection until you paste or press Escape. You can click elsewhere in the spreadsheet or even switch to a different sheet, and the cells remain copied. Click on the cell where you want to paste, then press Ctrl+V. The data appears in the new location.
If you copy cells and then copy something else before pasting, the first selection is replaced in the clipboard. Only one set of cells can be copied at a time. If you need to copy multiple separate groups and paste them in different places, copy and paste the first group, then copy and paste the second group.
Frequently Asked Questions
Can I select cells that are not in a rectangle shape?
Yes, by holding Ctrl and clicking separate cells or ranges. Each selection you add stays highlighted. When you copy, Excel copies each area separately, and when you paste, it pastes them in the same non-rectangular pattern in the new location.
What if I select the wrong cells by mistake?
Click somewhere else to deselect, then start over. Or press Escape to clear the selection without copying. If you have already copied and pasted the wrong cells, press Ctrl+Z to undo the paste.
Does selecting a cell and copying it move the cell?
No. Copying leaves the original cells in place. The dotted border shows they are copied, but they stay where they are. If you want to move cells instead of copy them, use Ctrl+X to cut, then Ctrl+V to paste — cutting removes them from the original location.
Can I select cells across multiple sheets at once?
No. You can only copy from one sheet at a time. To copy data from multiple sheets, copy from the first sheet and paste it, then go to the second sheet, copy from there, and paste in a new location.
Why does my selection disappear when I click elsewhere?
Clicking on a different cell deselects your current selection. If you have already copied (Ctrl+C), the cells remain in the clipboard even though the blue highlight is gone. You can click elsewhere and paste without re-copying.