How To Cut, Copy & Paste In Excel Guide

Table of Contents[Show]
Guide To How To Cut Copy Paste In Excel

How to copy and paste in Excel - One of the activities that you often do when working with Excel is to do Copy-Paste and Cut-Paste activities. Namely duplicating or moving data from one place to another.

I am sure you are quite familiar with these two familiar terms.

When using Microsoft Excel, there are various copy and paste activities that you need, such as:

  • How to copy excel formulas
  • How to copy and paste an excel sheet
  • How to copy and paste Excel is exactly the same
  • How to copy paste special in Excel
  • How to copy filtered rows
  • How to copy excel without formulas
  • And so forth.

In Microsoft Office, Copy is a command to save data on the clipboard without deleting the original data.

Similar to Copy, the term Cut is also a command to store data on the clipboard but by deleting or removing the original data.

The Paste command to eject, or put down deposits attach a copy of the results on a clipboard was in a place (cell / range) in an excel (worksheet).


If you run the cut or copy paste command on a cell, range, table or certain objects in Excel, you can adjust the results as needed.

For example, pasting the format along with excel formulas, pasting only values, pasting only formatting, pasting column widths and so on depending on your needs.

Then how to do Copy-Paste or Cut-Paste in Excel correctly?

Our Excel tutorial this time will discuss in depth about Copy or Cut and Paste data in Excel so that you will not only be able to copy and paste or Cut Paste, but also be able to copy and paste excel data or formulas correctly and correctly according to your needs.

Windows Clipboard & Office Clipboard

Copy Paste activity in Excel cannot be separated from the presence of the Office Clipboard.

For that, before discussing more about the command or how to copy and paste in Excel and the Cut Paste command, you need to first understand the two terms Windows Clipboard and Office Clipboard.

Windows Clipboard

The Windows Clipboard is where the last or most recently cut or copied data values ​​are stored.

This stored data can be value data from Office Excel or other Windows applications.

For example, you can (Copy) the values ​​from the browser and paste them into Ms. Excel, Ms. Word, Notepad, and so on.

The Windows Clipboard stores only one data value. So that every time and run the Copy or Cut command, the data stored on the Clipboard will be replaced with the latest or last data.


Office Clipboard

Similar to the Windows clipboard, the Office Clipboard also only stores the value of the last data that was copied or cut.

If you need Excel to remember more than one data value, then click the button in the lower right corner of the TAB HOME - Clipboard group.

By pressing this button, the Office Clipboard will appear on the left side of your excel application screen.

Try to copy several different Excel cells, and the results will automatically appear in the clipboard list.

Try to copy several different Excel cells


Bringing up the Office Clipboard is very helpful if you need to repeatedly copy or copy the same data.

If you want to enter one of the copies of the cell, select the cell where you want to paste or insert the data and click on one of the data in the clipboard list.

If you want to paste or paste all values ​​or data on the Office Clipboard at once use or click the Paste All button or click Clear All if you want to clean the office clipboard.

Values stored in the Office Clipboard in one application can be accessed by other Microsoft Office applications. For example, if you copy the cell contents in Excel, it will also be available in Word and vice versa.

Cut, Copy & Paste Excel Data

Furthermore, in this section we will learn how to run the Copy, Cut and Paste data commands in Excel.

How to Copy and Paste Excel data

There are several ways you can do to Copy-Paste data in Excel.

How to Copy and Paste Excel data


The first way is to use the COPY and PASTE command buttons on the Excel Ribbon on the HOME TAB.

The steps for copy and paste in Excel are as follows:

  1. Activate or select the cell / range to be copied
  2. Click the button Copy on the Ribbon
  3. Select the cell where you will paste the copy of the data earlier
  4. Finally, click the button Paste to paste the copy of the data.

The second way is to use a shortcut or keyboard on the keyboard. You do this by pressing the button to copy and to paste. The steps for copy and paste in Excel in the second way are as follows: Ctrl + C Ctrl + V

  1. Activate or select the cell / range to be copied
  2. Press to copy data Ctrl + C
  3. Select the cell where you will paste the copy of the data earlier
  4. Press to paste data Ctrl + V

The third way is to use the mouse directly.

The third way is to use the mouse directly.

The steps are as follows:

  1. Select and activate the cell or Range to be copied
  2. Press and hold the button Ctrl, then hover over the edge of the selected cell or range (Usually green, so the cursor becomes an arrow with a plus sign next to it.
  3. After the cursor changes and a plus sign appears, drag the cursor to another cell where you want to copy or paste it.

With this third method, the copied data will not be stored on the clipboard.

Of the three ways to copy and paste above, which one do you use often?

I believe the answer is - . Is not it? If you are familiar with the 3rd method, I think it will be more practical to use this method if the location for pasting the copied data is close together. Ctrl + C  Ctrl + V

TIP:

Use Shortcut to copy data above the active cell in the active cell. Ctrl + D

How to Cut and Paste Excel Data

In general, the way to do the Cut-Paste command is actually similar to the Copy-Paste method. There is only a slight difference as explained below:

The first way is to use the CUT and PASTE command buttons on the Excel Ribbon on the HOME TAB.

  1. Select the cell / range to be cut
  2. Click the button Cut on the Ribbon
  3. Move the cursor to another cell where you will move the data earlier
  4. Click the button Paste to paste the data transfer result.

The second way is by pressing the button to cut data and to paste. Ctrl + X  Ctrl + V

  1. Select the cells / range to cut or move
  2. Press on the keyboard to cut data Ctrl + X
  3. Select the cell where you want to move the data
  4. Press to paste data Ctrl + V

The third way is by using the (Mouse). The steps are as follows:

How to Cut and Paste Excel Data


Select the cell or Range to cut

Move the cursor to the edge of the selected cell or range without holding the key Ctrl on the keyboard like when copying earlier.

After the cursor changes, the arrow has 4 black arrow directions, drag the cursor to another cell where you want to paste the data.

So, isn't it easy enough to copy and paste data in Excel?

INFO:

A dotted line around the cell or range that you are copying or cutting indicates that the cut or copy mode for that cell or range of data is active. As long as this sign is there, you can repeatedly paste the data on the cell.

Press the key Esc on the keyboard to get rid of this dotted line.

Paste Special in Excel

Apart from using the standard method described in the previous section, Excel also allows you to paste or paste data in a special way.

Unlike regular pasting, special pasting gives you more control over how pasted data is copied.

Paste Special function only appears if you do the Copy command. For the Cut command, Paste Special does not apply.

To use the Paste Special feature, copy the contents of the selected cell and move the cursor to the place where you want to paste it. Then use right click to open the contextual menu.

Paste Special in Excel


Hover the mouse over the menu buttons of this command to find out the name or function of each of these Paste Special commands.

If the paste special does not appear and you are sure you are copying an excel cell / range, look at the excel options in the File - Options - Advanced tab and make sure that in the Under Cut category , copy and paste the option " Show Paste Options button when content is pasted " ticked.

Paste Options button when content is pasted

In addition to right-clicking while pasting, you can also find Paste Special commands on the TAB HOME- Clipboard Group, then click the little triangle under the Paste button.

Paste, Paste values, and Other Paste Options.


In the section that appears, Paste Special Commands are divided into 3 parts: Paste, Paste values, and Other Paste Options.

Paste

The menu buttons for commands in this section are as follows:

ORDER PASTE INFORMATION
Paste (P) This is the standard method for pasting data which has the same effect as keyboard shortcuts .Ctrl + V
Formulas (F) With this button Excel will only paste the copied cell formula without including any cell formatting if any.
Formulas & Number Formatting (O) With this method, in addition to pasting formulas, Excel will also past number formatting. Number Format is not the same as Cell Format
Keep Source Formatting (K) This Paste method is a combination of the two previous paste methods Plus the Cell format as well.
No Borders (B) Paste all contents of the copied data except the border or outline.
Keep Source Column Widths (W) Paste the cells like the Keep Source Formatting method and also copy the column widths.
Transpose (T) This method will transpose (replace or reverse) the position of the columns and rows.
 

Paste Values

The menu buttons for the Paste Special commands in this section are as follows:

ORDER PASTE INFORMATION
Values (V) Excel will only paste the value from the copied cells. For example, if the cell you copied contains the formula "= 10 + 20", the result of this method is pasting the value 30.
Values & Number Formatting (A) Apart from pasting only the cell value, this method also pastes the copied cell number format.
Values & Source Formatting (E) This method will paste the cell value along with the number format as well as the cell format.


Other Paste Options

The third part of Paste Special contains a menu of the following commands:

ORDER PASTE INFORMATION
Formatting (R) This pasting model copies cell values, but copies the formatting (background, size, font color, etc.).
Paste Link (N) This method pastes the link to the copied cells. If you copy cell A1 to B1, cell B1 will contain a link to cell A1 (= $ A $ 1). This means that when you change the contents of cell A1, the contents of cell B2 will change automatically. In this case, the format was not pasted.
Picture (U) Copy cell contents and format and save them as picture.
Linked Picture (I) Similar to the previous method, this pasting renders the contents of the copied cell as an image. With this pasting method, the resulting image is related to the copied cells so that if you change or update the copied cells, the pasted image will also change.


Advanced Paste Special

In addition to the buttons that are already available in the three sections, you can also adjust the results of the paste further by selecting the menu that says Paste Special at the bottom of the Paste menu.

This option will bring up the Paste Special setting box as shown below:

In this dialog box, you will find other additional features such as addition, subtraction, division or multiplication when pasting from the copied data.

Advanced Paste Special

You can also display excel Paste Special dialog box with Shortcut. Ctrl + Alt + V

That's all for our discussion this time about how to copy and paste and how to cut paste in Excel. Hopefully this is useful and adds new useful information for you. See you in another tutorial. If you have questions, please submit them in the comments column provided.

Leave a Comment