How do you copy and paste multiple cells in Excel?

After selecting the range of cells press Ctrl + C together to copy the range of cells. Again, select a range of cells where you want to paste it and press on to Ctrl + V together to paste it. This is the easiest way of copying and pasting multiple cells altogether.

How do you copy and paste in Excel and keep formatting?

Using Copy and Paste for Formatting
  1. Select the cell or cells whose format you wish to copy.
  2. Press Ctrl+C or press Ctrl+Insert. …
  3. Select the cell or cell range into which you want the formats pasted.
  4. Choose Paste Special from the Edit menu. …
  5. Choose the Formats radio button.
  6. Click on OK.

How do I copy a range of cells in Excel?

MS Excel 2016: Copy a Range
  1. Next, hold down the SHIFT key and click on the last cell in the range. In this example, we have clicked on cell C6. …
  2. Now to copy the cells, press CTRL + C . …
  3. To paste the range of cells, press CTRL + V .
  4. Now you should see the pasted range in the new location in your spreadsheet.