Copy vs. Cut in Microsoft Excel
Wednesday, Apr 01
commerce curve online accounting course

What are Cut and Copy Functions in Microsoft Excel?

Copy and Cut are the most common used functions of Microsoft Excel. It is pertinent to understand the difference between both these functions.

Copy function is applied when you want to copy the contents of a particular cell to another location. This function is also useful for replicating a formula from one cell to another. On the other hand, Cut function is applied when you want to move the contents of a particular cell to another cell and have it deleted from the previous cell. This function is also useful while moving a formula from one cell to another.

Following are the shortcuts for cut, copy and paste function in an Excel spreadsheet:

  • Ctrl + C – Copy Command
  • Ctrl + X – Cut Command
  • Ctrl + V – Paste Command

This article will demonstrate, how to use copy and cut function in an Excel spreadsheet.

What are the uses and Practical applications of Copy Function?

Copy function is applied when you need to duplicate text, formulas, charts, and other data. The new cell where the data has to be pasted can be on the same or different worksheet or even in a completely different workbook.

What are the Steps to copy something in Microsoft Excel?

Following steps are performed while using copy function in Excel:

Moving content from one location to another

Step 1: Go to the cell that you want to copy

Step 2: Press Ctrl + C on your keyboard

Step 3: Select all the cells where you want to paste the content and then Press Ctrl + V on your keyboard

Copying formula from one cell to another

Step 1: Go to the cell that you want to copy

Step 2: Press Ctrl + C on your keyboard

Step 3: Select all the cells where you want to paste the formula and then Press Ctrl + V on your keyboard

What are the uses of the Cut Function in Excel?

In case you want to move data from one cell to another, you would be required to use cut and paste function. You can use cut function in Excel to relocate content, formulas, charts, and other data. The new cell where the data has to be pasted can be on the same or different worksheet or even in a completely different workbook.

What are the Steps to Cut Something in Microsoft Excel?

Following steps are performed while using copy function in Excel:

Cutting content from one location to another

Step 1: Select the cells which you want to move and press Ctrl + X. In this example we will move B2:E7.

Step 2: Press Ctrl + V, to the cell where you want to move the content. In this case we moved the data up one row to row 1-6.
Cutting formula from one location to another
Step 1: Select the cell whose formula you want to move to another cell and then press Ctrl + X on your keyboard.

Step 2: Press Ctrl + V, to the cell where you want to move the formula i.e. cell F3 in this case.

0 Comments

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

4 + 6 =