COPY AND PASTE

Here we will learn about COPY AND PASTE and SPECIAL PASTE.

Learn how to COPY AND PASTE very easily in just 4 STEPS: –

STEP – 01 # SELECT WHO TO COPY.

STEP – 02 # SELECT COPY by going to CLIPBOARD block of HOME TAB. (Or PRESS SHORTCUT KEY CTRL + C.)

STEP – 03 # Then SELECT the CELL where PASTE is to be done.

STEP – 04 # SELECT PASTE in the CLIPBOARD block of HOME TAB. (Or PRESS SHORTCUT KEY CTRL + V.)

And our DATA becomes COPY AND PASTE in just 4 STEPS.

Let’s see with the help of EXAMPLE.

1 .LEARN COPY AND PASTE

So first of all we know how to DATA COPY AND PASTE in MS EXCEL. In MS EXCEL, we can do DATA in just 4 STEPS COPY AND PASTE.

STEP -1  #   First, select the DATA that you want to COPY. (Here in EXAMPLE we will learn how to do a TABLE.) Then we will SELECT TABLE.

COPY AND PASTE

STEP -2 #   After that HOME will CLICK on COPY in CLIPBOARD BLOCK in TAB.

 COPY AND PASTE

STEP -3 #   After CLICK on COPY, we will SELECT this COPY DATA where you want to PASTE it.

STEP -4 # After SELECT CELL, HOME will CLICK on PASTE in CLIPBOARD BLOCK in TAB.

And after CLICK our DATA becomes COPY AND PASTE.

So in this way we can do COPY AND PASTE in MS EXCEL. 

 

2 - LEARN COPY AND SPECIAL PASTE

So now we know how to DATA COPY AND SPECIAL PASTE in MS EXCEL.

In SPECIAL PASTE we can PASTE DATA regardless of VALUE and FORMAT.

(i) So first we will learn to PASTE the VALUE of DATA.

STEP -1  #   First, select the DATA that you want to COPY. (Here in EXAMPLE we will learn how to do a TABLE.) Then we will SELECT TABLE.

COPY AND PASTE

STEP -2 #   After that CLICK on COPY.

COPY AND PASTE

STEP -3 #  After CLICK on COPY, we will SELECT this COPY DATA where you want to PASTE it.

COPY AND PASTE

STEP -4 #  Then CLICK on the small arrow sign below PASTE and CLICK on PASTE SPECIAL.

STEP -5  # After clicking on PASTE SPECIAL, we will see OPTION. In that we will select VALUE and click OK.

After CLICK OK, we get only VALUE for TABLE done by COPY.

So in this way we can PASTE VALUE of DATA COPY done in MS EXCEL.

 

 

 

(ii) Next we will learn to PASTE the FORMAT of DATA.

To PASTE FORMAT of a TABLE, we have to work SAME up to 4 STEPS.

STEP -1 #   SELECT will be done by COPY.

STEP -2  #   After that CLICK on COPY.

STEP -3  #   After CLICK on COPY, we will SELECT this COPY DATA where you want to PASTE it.

STEP -4  #   Then CLICK on the small arrow mark below PASTE and CLICK on PASTE SPECIAL.

STEP -5   #  After clicking on PASTE SPECIAL, we will see OPTION. In that we will select FORMAT and click OK.

After OK CLICK, we get only FORMAT of TABLE done COPY.

So in this way we can PASTE the FORMAT of COPY DATA in MS EXCEL.

 

 

 

(iii) Next we will learn to PASTE ADD to DATA (by adding).

To do ADD or added PASTE to a DATA, we have to do the same SAME work for up to 4 STEPS.

STEP -1 #   

STEP -2  #   After that CLICK on COPY.

STEP -3  #    After CLICK on COPY, we will SELECT this COPY DATA where you want to PASTE it. (Here we want to PASTE the DATA of TABLE A added to TABLE B in the photo. So we will SELECT the first CELL of TABLE B after COPY.)

STEP -4  #   Then CLICK on the small arrow mark below PASTE and CLICK on PASTE SPECIAL.

STEP -5   #  After clicking on PASTE SPECIAL, we will see OPTION. In that we will select ADD and click OK.

After CLICK OK, we get COPY done TABLE (A), TABLE (B) only through ADD.

So in this way we can PASTE ADD COPY DATA in MS EXCEL.

 

 

 

 

(iv) Next we will learn to PASTE DATA from ROW heading to COLUMN heading.

We have to work SAME for up to 4 STEPS to PASTE a TABLE from ROW heading to COLUMN heading.

STEP -1 #   SELECT will be done by COPY.

STEP -2  #   After that CLICK on COPY.

STEP -3  #    After CLICK on COPY, we will SELECT this COPY DATA where you want to PASTE it.

STEP -4  #   Then CLICK on the small arrow mark below PASTE and CLICK on PASTE SPECIAL.

STEP -5   #  After clicking on PASTE SPECIAL, we will see OPTION. In that, we will select TRANSPOSE and click OK.

After OK CLICK, we get to CHANGE in COLUMN heading to PASTE from COPY DATA ROW heading.

So in this way we can PASTE the DATA COPY in MS EXCEL from the ROW heading to the COLUMN heading.

For more information see VIDEO -

Come see how much you learned in COPY AND PASTE

CLICK ON START QUIZ TO START THE QUIZ 

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram