Excel Copy and Paste Keyboard Shortcuts for Windows and Mac

In Microsoft Excel, you can use the keyboard shortcut Ctrl + C to copy selected cells or data. You can then paste the copied data to another location using the keyboard shortcut Ctrl + V. For Mac os use Command

You can also use the following shortcuts to copy data in Excel for Windows OS:

  • Ctrl + D: Copy the contents and format of the top-left cell in a selected range to the cells below and to the right of the selected range.
  • Ctrl + R: Copy the contents and format of the top-left cell in a selected range to the cells to the right of the selected range.
  • Ctrl + Shift + Down Arrow: Copy the contents of the cell above the active cell to the cells below the active cell in the same column.
  • Ctrl + Shift + Right Arrow: Copy the contents of the cell to the left of the active cell to the cells to the right of the active cell in the same row.

Keyboard shortcuts for copying and pasting data in Microsoft Excel for Mac OS:

  1. Copy: Command + C
  2. Paste: Command + V
  3. Fill Down: Command + D
  4. Fill Right: Command + R
  5. Autofill: Select the cells you want to copy, then click and drag the Fill Handle over the destination cells.

Additionally, you can use the Fill Handle to copy data in Excel. To use the Fill Handle, simply select the cells you want to copy and then click and drag the small square in the bottom-right corner of the selected cells (known as the Fill Handle) to the destination cells. The data will be automatically copied and filled into the destination cells based on the pattern of the source cells.

You can also use the AutoFill feature in Excel to copy data in a series. To use AutoFill, simply select the cells you want to copy and then drag the Fill Handle over the destination cells. The data will be automatically copied in a series based on the pattern of the source cells. For example, if you have a series of dates, you can use AutoFill to quickly fill in the remaining dates in the series.

There are many other Excel keyboard shortcuts and techniques you can use to copy and paste data in Excel. These are just a few of the most common methods.

FAQ’s

What is the keyboard shortcut to copy data in Microsoft Excel?

The keyboard shortcut to copy data in Microsoft Excel is Ctrl + C for Windows OS and Command + C for Mac OS users

Can I copy and paste data using the mouse in Microsoft Excel?

Yes, you can copy and paste data using the mouse in Microsoft Excel by right-clicking on the selected cells and choosing the “Copy” and “Paste” options from the context menu.

Can I copy data from one worksheet to another in Microsoft Excel?

Yes, you can copy data from one worksheet to another in Microsoft Excel by copying the data in the source worksheet and then pasting it into the destination worksheet.

How do I use the Fill Handle to copy data in Microsoft Excel?

To use the Fill Handle to copy data in Microsoft Excel, simply select the cells you want to copy and then click and drag the small square in the bottom-right corner of the selected cells to the destination cells.

How does the AutoFill feature work in Microsoft Excel?

The AutoFill feature in Microsoft Excel automatically copies data in a series based on the pattern of the source cells. To use AutoFill, simply select the cells you want to copy and then drag the Fill Handle over the destination cells.

Learn More Excel Keyboard Shortcuts

esyExcel

Gavesh S. is the founder and owner of EsyExcel.com. He has been a Microsoft Excel Expert since early 2012. With experience explained thousand of queries for companies including Microsoft and top other financial institutions. Theres is most uses of Business Analysis, People Management, Automation, Performance Reporting, Strategic Analysis, Project Management, Managing Programs, Account Management etc.  In 2021 he found EsyExcel.com to share his experiences with other who’s is looking to learn MS Excel. He is currently working on a book about working in the Learn Excel, expanding his skill set beyond the Excel Learning niche.