Have you ever entered a list of names, numbers, or formulas in Excel and then realized you needed the same data somewhere else?
Typing everything again would take time, and there’s always a chance of making mistakes.
Fortunately, Microsoft Excel provides a quick and easy way to duplicate data using the Copy and Paste commands.
With just two simple keyboard shortcuts, you can copy information from one location and paste it anywhere in your workbook without retyping it.
Whether you’re copying a single cell, an entire table, or even formulas, these shortcuts can save you a lot of time.
In this guide, you’ll learn how to copy and paste in Excel using keyboard shortcuts, when to use Paste Special, and a few useful tips every beginner should know.
What is Copy in Excel?
The Copy feature in Excel creates a duplicate of the selected data while leaving the original data unchanged.
You can copy almost anything in Excel, including:
- Text
- Numbers
- Formulas
- Cell formatting
- Tables
- Charts
- Pictures
After you copy something, Excel displays a moving dashed border around the selected cells. This is often called the marching ants border, and it simply means your copied data is ready to paste.
What is Paste in Excel?
The Paste feature inserts the copied or cut data into a new location.
Depending on how you paste the data, Excel can copy:
- Everything
- Only the values
- Only the formulas
- Only the formatting
- Column widths
- Comments and notes
This gives you complete control over how your copied information is inserted into the worksheet.
How to Copy and Paste in Excel?
Follow these simple steps to copy and paste data in Excel.
Step 1: Select the Data
Click the cell or range of cells you want to copy.
Step 2: Copy the Data
Press:
Ctrl + C
Excel copies the selected data to the Clipboard.
You’ll notice a moving dashed border around the copied cells.
Step 3: Choose the Destination
Click the cell where you want to paste the copied data.
Step 4: Paste the Data
Press:
Ctrl + V
Excel immediately pastes the copied information into the selected location.
That’s it. Your copied data will be pasted into the new location.
Example:
Example: Copy Data to Another Worksheet
Imagine you have a list of students in Sheet1, but you also need the same list in Sheet2.
Instead of typing everything again:
1. Select cells C1:C9.
2. Press Ctrl + C.
3. Go to the other worksheet.
4. Select the destination cell.
5. Press Ctrl + V.
Excel will paste the copied data into the new location.
Copy and Paste Shortcuts in Excel:
| Action | Keyboard Shortcut |
| Copy data | Ctrl + C |
| Paste data | Ctrl + V |
| Cut data | Ctrl + X |
| Undo the last action | Ctrl + Z |
| Open Paste Special | Ctrl + Alt + V |
These are some of the most commonly used keyboard shortcuts in Excel, and learning them can greatly improve your productivity.
Copy vs Cut in Excel:
Many beginners confuse Copy and Cut, but they work differently.
Copy (Ctrl + C):
- Creates a duplicate of the selected data.
- The original data remains in its current location.
Cut (Ctrl + X):
- Moves the selected data to another location.
- After pasting, the original location becomes empty.
If you’re unsure which option to use, remember this simple rule:
- Copy = Duplicate
- Cut = Move
Points to Remember:
1. Paste in One Location:
After copying data, select the destination cell and press Enter to paste it in one location.
2. Paste in Multiple Locations:
Once you’ve copied the data, you can paste it into multiple locations.
Simply move to each destination and press Ctrl + V again.
You don’t need to copy the data each time.
3. Use Paste Special for More Options:
Sometimes you don’t want to paste everything.
For example, you may want to paste only:
- Values
- Formulas
- Formatting
- Comments
- Column widths
Press Ctrl + Alt + V to open the Paste Special dialog box.
4. Check Formulas After Pasting:
When you copy formulas, Excel automatically adjusts the cell references.
For example,
If cell A1 contains:
`=B1+C1`
After copying it to row 2, Excel changes it to:
`=B2+C2`
Always check your formulas after pasting to make sure the results are correct.
5. Use Undo if Needed:
If you accidentally paste data into the wrong place, simply press:
Ctrl + Z
Excel immediately reverses your last action.
Paste Special in Excel:
Sometimes you don’t want to paste everything you’ve copied.
For example:
- You want only the numbers.
- You want only the formulas.
- You want only the formatting.
- You want to copy the column widths.
- You want to transpose rows into columns.
Instead of using the normal Paste command, you can use Paste Special.
To open Paste Special:
1. Copy the data using Ctrl + C.
2. Select the destination cell.
3. Press Ctrl + Alt + V.
You will see different options such as:
- Values: Paste only numbers or text, not formulas.
- Formulas: Paste only formulas.
- Formats: Paste only colours, fonts, borders, and formatting.
- Column Widths: Copy the width of the columns.
- Transpose: Change rows into columns or columns into rows.
AI Tip: Ask ChatGPT or Copilot
Sometimes it’s confusing to know which paste option you should use.
For example:
- You want to copy only values.
- You want to keep the formatting but remove the formulas.
- You want to convert rows into columns.
- You want to paste formulas without changing the formatting.
Instead of searching through menus, you can simply ask ChatGPT or Microsoft Copilot.
Try this prompt:
“I want to copy data from one Excel sheet to another. I want to keep the numbers and formatting, but I do not want to copy the formulas. Which paste option should I use?”
You can also ask:
“I copied a formula in Excel, but the result changed after pasting. Why did this happen?”
AI can quickly explain which Paste option is best for your situation and help you avoid common mistakes.
Important: Always review your worksheet after using AI suggestions, especially when working with formulas, financial reports, or important business data.
Frequently Asked Questions (FAQs)
What is the shortcut key for Copy in Excel?
Press Ctrl + C to copy the selected cell, range, or object.
What is the shortcut key for Paste?
Press Ctrl + V to paste the copied or cut data.
What is the shortcut for Paste Special?
Press Ctrl + Alt + V to open the Paste Special dialog box.
Can I paste the same copied data multiple times?
Yes. After copying the data once, you can press Ctrl + V as many times as you need until you copy something else.
Why does my formula change after I paste it?
Excel automatically adjusts relative cell references when formulas are copied.
If you don’t want the references to change, use absolute references (for example, `$A$1`) or paste only the values using Paste Special.
Copy and Paste shortcuts are very useful for everyone who works in Excel.
Use Ctrl + C to copy and Ctrl + V to paste. If you need more control, use Ctrl + Alt + V for Paste Special.
Start using these shortcuts in your daily Excel work. They will save time and make your work easier.