Copy, cut and paste

In “Excel”, we can “Cut”, “Copy” and “Paste” data as in any other application from “Microsoft”. This can be done in the same “Worksheet” to another “Worksheet”, or even to another “Workbook”.

To move data, we use the “Cut” command. First, select the cell or cell “Range”, and click the “Cut” button (1) in the “Ribbon”.
Or, use the shortcut and the quickest way by selecting the “Range” and click Ctrl + X on your keyboard.

To “Copy” data, we use the “Copy” command. Again, first select the cell or cell “Range” and click the “Copy” button (2) in the “Ribbon”. Or, use the quickest way and select the “Range” and click CTRL C on your keyboard.

In both cases there appears a moving black frame (3) around the selected cells.

For those of you who do not know the difference between cutting and copying, here is a short explanation:  When you “cut” data from a cell, the cell is left empty when you “Paste” the data elsewhere whereas, copied cells remain unchanged and you can “Paste” them as many times as you want.

What is new in “Excel 2010” however, is that we now see some options to “Paste” from. Just click the downward pointing arrow under the option “Paste”. In the drop-down menu that appears (1) there are different “Paste” options. When the mouse pointer moves over the different “Paste” options (2), you can see the results already appear in the “Worksheet” (3). If you are satisfied, click the icon of the “Paste” option..

All the “Paste” options we discuss here seem very useful. You should try them. Additionally, the options “Transpose” and “Image” are added to the “Paste” options.

“Transpose” changes columns into rows and rows into columns (see above). The “Image” option “Paste”s the copied image as an image in your “Worksheet”.

Both options, especially the first, seem very useful to me.

Paste List

When we have to “Paste” something, there appears a downward pointing arrow to the right bottom of the “Paste” button. When we click this button it opens a list of different “Paste” options. The only difference with the “Paste” in this list is that you do not get to see live example.

The Clipboard

When we “Cut” or “Copy” something , this data is placed in the “Clipboard”.

The “Clipboard” in “Excel” is a useful tool in which a maximum of 24 “Cut” and “Copy” commands are stored. We can “Paste” these randomly in any “Workbook”, “Worksheet”, even in another “Microsoft” application

Normally when we “Paste” something, it 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 saves up to 24 “Copy” and “Cut” commands which we selected in the past. To add items to the “Clipboard”, just “Cut” or “Copy” the commands below.

To open the “Clipboard”, click the “Clipboard” button (1) in the “Ribbon”. To use the “Paste” command, you need to only select the relevant data and click the command button in the “Clipboard” (2). To remove a command from the “Clipboard”, select the command, click from the downward pointing arrow that appears (3) and click the “Delete” option from the drop-down menu.
You can remove all the commands by pressing the “Clear All” button (4).

Commands in the “Clipboard” remain as long as at least one “Office Application” is open.

You can close the “Clipboard” by clicking the X in the upper right corner, or click on the “Clipboard” arrow in the “Ribbon”.

Featured Courses

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