Tuesday, January 25, 2022

Paste special when copying from programs other than excel

You can use the Paste Special dialog box to copy complex items from a program other than Excel and paste those items into an Excel worksheet.

Source    Displays the name of the source data and its location. If you copied the data from a program that did not provide the source data and its location to the Clipboard, the source is identified as "Unknown."

Paste    Inserts or embeds the Clipboard contents at the insertion point in the format specified in the As box. When you select this option, the Clipboard contents are pasted or embedded as an object, but no link is created. If the data is embedded as an object, the source program is started when you double-click the worksheet data, and you then use the source program to edit the data.

Paste link    Creates a link from the pasted data to its source file. When you select this option, changes that are made to the source file will be reflected in the worksheet.

As    Specifies the type of data that you want to paste from the Clipboard.

Display as icon    Displays the Clipboard contents as an icon in the worksheet. When you select this check box, an icon appears in the destination area that you can click to see the embedded or linked data. Use this option if you do not want the embedded or linked data to be displayed in the worksheet.

Result    Describes the effects of the options that you select.

2 comments:

  1. Nice! Very useful information. Looking for a car finance hub to answer your questions on getting car finance

    Car Finance Questions
    Buying a Car Online

    ReplyDelete
  2. HAVE YOU BEEN SCAMMED OF YOUR COINS AND WANTS TO GET IT RECOVERED BACK???

    I invested a total of$95,000.00USD worth of Bitcoin with an online company who does trading and was guaranteed a payout of 25% a week. They ended up shutting down their company website but their website was still running. So I could still see my dashboard at that time and instead of paying weekly they ended up compounding my money. It ended up compounding to$179, 000USD so I requested for a withdrawal which was declined before they shutdown their website, I complained to my colleague at work who directed me about this recovery expert, Mr. Morris Ray, that helped him, I contacted him immediately, what surprised me most, was that I recovered my money that same week. You can contact him on his email at MorrisGray830 @ Gmail . com and on WhatsApp: + 1 (607) 698-0239 and he will assist you on the steps to recover your invested funds.
    Just trying to help those who where scammed just the way I was too.

    ReplyDelete