[ Home ] [ Up ] [ Introduction to Excel ] [ Entering a Range of Data ] [ Formatting Cells to Match Data Types ] [ Cut, Copy, Paste and Move Data ] [ Inserting and Deleting Rows and Columns ] [ Entering and Replicating Formulas ] [ Using Simple Functions ] [ Producing Charts with Labels ] [ Printing Selected Areas ]

Cut, Copy, Paste and Move Data Between Cells, Rows and Columns

Selecting Data

Selecting the Whole Sheet

Selecting an Entire Column or Row

Selecting Groups of Data Not Adjacent to Each Other

Moving the Contents of a Single Cell

To Move an Entire Row or Column

To Cut and Paste and Entire Cell, Column, or Row

Copying Information from One Cell, Row or Column to Another

Copying and Pasting a Spreadsheet into another Document

Selecting Data

If you wish to select a range of data follow these instructions:

1. Click and hold on the first cell in the range.
2. Drag the mouse to the last cell in the range.
3. Release the mouse mouse button.

Selecting the Whole Sheet

You can select the whole worksheet in a couple of ways:

1. Click on the select all button at top left hand corner of the worksheet.
2. Press control + A.

Selecting an Entire Column or Row

To select an entire row or column simply:

1. Click whichever row or column heading you want. 
2. The selected row or column will be highlighted.

Selecting Groups of Data Not Adjacent to Each Other

1. Press and hold the Control key on you keyboard.
2. Select a group of data from your worksheet continue holding the Control key.
3. Select other groups of data while still holding the control key.
4. Release the Control key when finished.

Moving the Contents of a Single Cell

To move the content of a cell to a new cell do this:

1. Click on the cell you wish to move.
2. Place the cursor over the black border of the cell.  Make sure the cursor looks like an arrow not a cross.                                                                        
3. Click, hold, and drag the cell to it's new location.
4. Release the mouse button.

To Move an Entire Row or Column

If you want to move an entire row or column to a new location then follow these instructions:

1. Highlight the entire row or column.                     
2. Place the cursor over the black border of the row or column.  Again make sure the cursor is an arrow not a cross.
3. Click, hold, and drag the row or column to it's new location.

To Cut and Paste and Entire Cell, Column, or Row

Use this option if you want to cut a cell, column, or row and paste the information into a new location on your worksheet.

1. Click on the cell, row heading, or column heading that is to be cut then pasted.
2. Right click on the item to be cut and select Cut from the menu.
3. Click on the cell, row heading, or column heading where your item is to be pasted.
4. Right click on the cell, highlighted row, or highlighted column and select Paste from the menu.
5. The data will then be cut from the old location and pasted into the new.

Copying Information from One Cell, Row or Column to Another

Use this option if you want to copy data from one cell and move it to another with out losing the data from the original cell.

1. Select the cell, column, or row you wish to copy.
2. Right click on the cell, column, or row and select Copy from the menu.
3. Select the cell, column, or row you wish to copy to.
4. Right click on the cell, column, or row you wish to copy to and select Paste from the menu.
5. You can continue pasting this data into as many cells, rows, or columns you wish.

Copying and Pasting a Spreadsheet into another Document

1. Select the area of the spreadsheet to be copied.
2. Right click on the selected area and select Copy.
3. Open your other document.
4. Place the cursor where you want your spreadsheet pasted, right click, and select Paste Special.
5. Select Microsoft Excel Worksheet Object.