Question: how do i copy and paste a large range of cells in excel?
Answer: Next, hold down the SHIFT key and click on the last cell in the range. In this example, we have clicked on cell C6. ... 
Now to copy the cells, press CTRL + C . ... 
To paste the range of cells, press CTRL + V .
Now you should see the pasted range in the new location in your spreadsheet.