How to paste in multiple cells in Excel

You can watch a video tutorial here.

Copy and paste is an operation that you will perform frequently when working with Excel. You may want to copy some data from one sheet to another. There are 3 ways in which this can be done:

1. Keyboard shortcuts
2. Context menu
3. Edit menu

Option 1 – Use the keyboard shortcuts

Step 1 – Copy the data

• Select the data
• Press Ctrl+C

Step 2 – Paste the data

• Go to the location where the data is to be pasted
• Press Ctrl+V

Option 2 – Use the context menu

Step 1 – Copy the data

• Select the data
• Right-click and select Copy from the context menu

Step 2 – Paste the data

• Go to the location where the data is to be pasted
• Right-click and select Paste from the context menu

Option 3 – Use the menu option

Step 1 – Copy the data

• Select the data
• Go to Home > Clipboard
• Expand the Copy dropdown
• Select Copy 

Step 2 – Paste the data

• Go to the location where the data is to be pasted
• Go to Home > Clipboard
• Expand the Paste dropdown
• Select Paste