SECTION 2
Lesson 2.4 Moving your Data

   

 

 

Cutting copying and pasting multiple cells is a lot like cutting copying and pasting single cells. The important difference is that you must select a range of cells first.

 

To begin, select a range of cells by dragging the thick cross pointer.

When you have made your selection, right click on any cell in the selected range and choose Cut or Copy from the dropdown menu. The selected range will have a light and dark flashing border.

 

Text Box: If we select this cell and Paste, the upper left cell of the data block will be located here in this cell. H3

 

 

 

The next step is to select a destination area by dragging and dropping, pointing and clicking, or using the arrow keys. If you choose a destination cell by pointing and clicking the mouse, or with the arrow keys, the selected block of cells will be copied so that the destination cell is in the upper left corner of the new block.

 

 

 

If you cut a selection of data, it is just like cutting a single cell in the sense that the cell information in the original selected area will be removed (cut) from the worksheet.

 

When you cut or copy items, they are saved to the clipboard. You can view the items on your clipboard at any time by accessing the Clipboard Task Pane. You can do this by choosing Edit->Office Clipboard from the menu bar. You can also select   View->Task Pane from the menu bar and select the Clipboard option from the dropdown list at the top of the task pane that is displayed.

 

Any items copied from other Microsoft Office applications like Power Point, Word, or Access, (up to 24 items) will be saved on this clipboard. You can paste items to your Excel worksheet (at the location of the active cell). You can also copy items to the clipboard from Excel, and paste them to another program like Word.

 

 

 

You can clear all the items from the office clipboard by clicking the Clear All button. You can paste all of the items on the clipboard by using the Paste all button.