How do I copy multiple cells in Excel?

To copy multiple non-adjacent cells in Excel, you need to select the cells while holding down the Ctrl key (or Command key on a Mac), then copy using the usual methods. Here's a detailed breakdown:

Steps to Copy Multiple Non-Adjacent Cells

1. Select the First Cell: Click on the first cell you want to copy.
2. Hold Ctrl/Command: Press and hold the Ctrl key on a Windows PC or the Command key on a Mac.
3. Select Additional Cells: While holding down the Ctrl/Command key, click on each additional cell you wish to copy.
   • You'll notice that each selected cell is highlighted, and they don't have to be next to each other.
4. Copy: Once you've selected all the cells you want, you can copy them using one of the following methods:
   • Press Ctrl + C (Windows) or Command + C (Mac)
   • Right-click on one of the selected cells and select "Copy" from the context menu.
5. Paste: Now, navigate to where you want to paste these cells and use one of the following:
   • Press Ctrl + V (Windows) or Command + V (Mac).
   • Right-click the target location and select "Paste" from the context menu.

Example

Let's say you have values in cells A2, A5, A7, and A9, as shown in the reference. To copy these cells, you would:

1. Click on cell A2.
2. Press and hold the Ctrl/Command key.
3. Click on cell A5, then cell A7, and finally cell A9 while still holding the Ctrl/Command key.
4. Release the Ctrl/Command key.
5. Press Ctrl+C (Windows) or Command+C (Mac) or right-click and select "Copy".
6. Click on the cell where you want the data to be pasted, then press Ctrl+V (Windows) or Command+V (Mac) or right-click and select "Paste".

This process will copy the values from cells A2, A5, A7, and A9 and paste them into the new location. This is a very efficient way of copying multiple cells in Excel, especially when the cells aren't next to each other.