Excel: The copy and paste function

Excel: The copy and paste function:YOUR OBJECTIVE

If you also want to use the content of a cell in a different place, you can copy it and save yourself some typing.

In this learning module “Excel:The copy and paste function” you will learn how to copy and paste cell content.

Excel: Copy and paste function:  HOW DOES IT WORK?

(1)   Excel: Copy and paste – How to copy?

Copy

To copy the content of a cell, first select the cell range that contains the content that you want to copy.

Click the Copy  button in the Clipboard group on the Home tab.


#

Excel copy paste : KEY COMBINATION:

Alternatively, you can press [Ctrl]+[C] to access the Copy function.

The copied cell range will now receive a running border.

HINT

You can also use the pop-up menu to copy a selected section. Right-click in the selected section and select Copy.

 (2)   Excel: Copy and paste – How to paste?

Paste

The copied cell content is now added to the clipboard and can be inserted into a different place in the same or different worksheet or into a different Excel file. The active cell is most important for the new location, since the top left cell of the copied cell range will be inserted into this cell. Click where you want the content to be inserted. Click the  button to paste the content.

Excel copy paste:KEY COMBINATION:

Alternatively, you can press [Ctrl]+[V] to access the Paste function.

Once you have pasted the copied cell range, you will notice the Paste Options button at the bottom right corner of the inserted section. You will find several paste settings here. Click the button to use one of these options. Select the paste option of your choice.

Paste (P): All values and their formatting are pasted.

Formulas (F): All values are pasted without formatting.

Formula and number formatting(O): Values and their number format are pasted. Other formatting is lost.

Keep source formatting (K): Values are pasted with all formatting intact.

No borders (B): Values are pasted with formatting intact, however, borders are not copied.

Keep source column width (W): The column width of the copied cells will also be transferred.

Transpose (T): Select this option if you want to transpose the pasted cells, i.e. if you want to swap rows and columns.

Values (V): Only the values, without any formatting, are pasted. If you entered a formula in one of the copied cells, it will not be pasted – only the calculated result will.

Values and number formatting (A): Again, only values are pasted (formulas and functions are lost, only the result is pasted), but number formats are transferred.

Values and source formatting (E): Pastes values and the source formatting.

Formatting (R): The content of cells is not pasted, only the formattng of the copied cells. In this way you can transfer the formatting from one cell/cell range to another.

Paste link (N): The content of cells is not pasted, only links to these cells. If, for instance, you select cell A4 and paste it into cell B12 using this option, the content of cell B12 =A4.

Picture (U): The copied content is pasted as a picture. You can therefore access all the picture editing tools, such as effects, shadows, etc.

Linked picture (I): Also pastes the content as a picture, however the picture remains linked to the source cell so that changes in this cell are automatically transferred to the picture.

You can access all these paste options direcly if, instead of clicking the  button, you click the arrow of the   button when you want to paste the copied cells . This will open a submenu, where you can select one of the paste options:

HINT

You can also use the pop-up menu to paste a copied section. Right-click in the cell where you want to paste the copied content, and select one of the paste options from the pop-up menu now displayed.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen