This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 22,160 times.
Learn more...
This wikiHow teaches you how to select and copy multiple cells in a Microsoft Excel spreadsheet, using a computer. Excel allows you to copy multiple cells only if they're in the same row or column.
Steps
-
1Open the Excel spreadsheet you want to edit. Find and double-click the Excel file you want to edit on your computer to open it in Excel.
-
2Hold down ⌘ Command on Mac or Control on Windows. While holding this button down on your keyboard, you can select multiple cells to copy and edit.
-
3Select multiple cells in the same row or column. While pressing down ⌘ Cmd or Ctrl, click all the cells you want to copy in the same row or column. This will highlight all the selected cells.
- You can copy multiple cells only if they're all in the same row or column.
- If you select multiple cells from different rows and columns, you'll see an error message saying this is not possible.
-
4Click the Home tab on the toolbar ribbon. You can find this button above the toolbar ribbon in the upper-left corner of Excel. It will switch your toolbar to the Home layout.
- You can skip this step if you're already in the Home tab.
-
5Click Copy on the Home toolbar. You can find this button next to Paste in the upper-left corner of the Home toolbar. It will copy all the selected cells to your clipboard.
- Alternatively, you can press ⌘ Command+C on Mac or Control+C on Windows to copy the selected cells.
-
6Click where you want to paste the copied cells. You can paste the copied cells anywhere on your spreadsheet.
-
7Click Paste on the Home toolbar. This button looks like a clipboard icon in the upper-left corner of the Home toolbar. It will paste the copied cells to the selected location on your spreadsheet.
- Alternatively, you can press ⌘ Command+V on Mac or Control+V on Windows to paste.
About This Article
1. Open your Excel spreadsheet.
2. Hold down Command (Mac) or Control (Windows).
3. Select multiple cells in the same row or column.
4. Click the Home tab.
5. Click Copy on the top-left of the toolbar.
6. Select where you want to paste.
7. Click Paste on the top-left of the toolbar.
