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 

This Post Has One Comment

  1. learn more

    Markeeting site is just about all that difficult to do. You need be persistent and
    want success will go youu would like blog to complete well.
    Youu can’t just create a post and then forgewt about it’s.
    You have to continue updating youur site and
    marketing it to let it will become popular and that we all want to take a look at.
    There are other ways ass well that are excellent marketing our blog.
    Keep reading tto find outt more.

    Probably involving marketrs have created the mistake of putting
    the cart before the horse, soo don’t improve your site before you have these studies done.
    In the event yyou hire an artist to help maake your site, then be careful it isn’t
    done in Flash, or with heavy use of graphics
    unless your niche calls aas it. Yourr site needs
    for totally SEO friendly, and appearance engine
    bots cannot read Flash – only texting. If you for you to SEO your website annd just
    ggo ahead and rank your past search engines, then you will need to stay cleasr of Flash, in.

    Keywords a single? You may not realize this, but content on Myspace is
    picked up by bing very, at ennoromus speed. If you share good content and good
    keyword concentrations, you’ll get indexed by the search motor.
    Justt make sure it iis good, quality substances!

    SEO is not something a person does for 8 hours just once and then neger
    need to worry about again. Your new purchase continual process, with
    new content haviing to be contributed to your sige everyday, lijnks exchanged, and articles
    listed in databases.

    Another approach to get users are to wrote articles of your products and publish them on formed
    websites more than the thhe vast web. This is a very gopod means of getting initial traffic for your site.
    Your reader who is interested in your article most likely bee be fascinated by your offer on web site – may become litigant!

    The final blog marketing tip through using work to acquire famous with your own yes.
    Many new bloggers are really intent on getting featyred on being released .
    blog they forget going after their own fame, in order to speak.

    Even set up a clean looking blog that ccontain great content, it stays not
    enough. You have to compete with millions of otherr blogs too get the attention of this reader present.
    It is tough, nevertheless the reality happens when your blog ddo not applear a first 10 poisitions from the web search engine,
    your owwn channces are that your superb blog
    will never get anyone audience. Lots ways to get your blog
    to the top of the search conttinuous motor. However, there are no short cuts.
    Gaining credibility and rqnking for that blog is really a long drawn process.
    Discover of course speed up this process with some kind legitimate SEO
    methods. Incorporate different marketing methods onn an mayy take years to happen, using thhe right SEO technique, you can potentially
    shorten iit to months’.

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

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

WhatsApp
Google+
Facebook
Telegram