Paste List

When we click the downward-pointing arrow below the “Paste” button we get a list of options:

• “Paste’: paste both the data and formatting
• “Formulas”: paste only the formulas
• “Paste Values”: paste only the values, not formulas
• “No Borders”: paste no edges if you have used in the layout of the cell (s)
• “Transpose”: change columns into rows, rows into columns.
• “Paste Link”: paste a link to the cell
• “Paste Special …’: displays a dialog where the options can be choosen from the list of paste of paste options that we have seen in the previous lesson.
• “Paste as Hyperlink”: paste the data to link to this cell
• “As Picture”: paste data from the source as an image in Excel.

“Clipboard”
The “Clipboard” in Excel is an useful tool in which a maximum of 24 cut and copy commands are stored, we can use this in any workbook, worksheet, even in other Microsoft application.

If we paste something this will be the latest data that we have copied or cut from our worksheet.
When we use the “Clipboard” this need not necessarily be so.
The “Clipboard” stores 24 copy and cut commands and we can choose from these.
To add items to the “Clipboard” use the cut or copy commands.

To “paste” command, you only need to select the destination cell, and click the command on the “Clipboard”.

The commands in the “Clipboard” persist until at least one “Office” Application is open.
You can manually remove items from the “Clipboard” by pressing the arrow next to the command and selecting “Delete”.
You can remove all the commands by pressing the “Clear All” button.
You can close the clipboard by clicking the “X” in the upper right corner.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats