To copy data to a different location on the same page

·       Select the cell or range you wish to copy.

·       Click on the border edge of the highlighted range with the mouse pointer, whilst holding down the Ctrl key.  Before you click, the mouse pointer should turn into an arrow.

·       Whilst holding down the mouse button, drag the selection to the required location.

·       Release the mouse button to insert the selection.  

NOTE:   Any formulae contained in the copy of the selection will adjust relative to the new location.

To use the Clipboard to copy data to other programs

·       Select the cell or range you wish to copy.

·       From the Edit menu select Copy (or press Ctrl+C , or click on the Copy icon on the Standard toolbar).

·       Switch to the required destination program.

·       Place the cursor where you want the data to appear.

·       Select Paste from the Edit menu (or press Ctrl+V or select the Paste icon from the Standard toolbar).  

Note:  With the introduction of Office 2000 more than one item may be stored on the Clipboard at the same time, however the facility is only available within Office 2000 compatible programs.  Normally if you copy more than one item to the Clipboard, the previous item will be lost.

To copy multiple items to the Clipboard

·       As Microsoft Office (Office 2000 onwards) now supports up to 12 items on the Clipboard, when you have copied 12 items you will see a message similar to that illustrated.  To copy multiple items, simply select items, one at a time, and copy them to the Clipboard.  

To view the Clipboard toolbar

·       If the Clipboard toolbar is not displayed, then you can display it by clicking on the View drop down menu, selecting Toolbars , and then selecting Clipboard .  

Icons on this toolbar include Copy , Paste All and Clear Clipboard .

Pasting multiple items from the Clipboard

·       If the Clipboard toolbar is not displayed, then you can display it by clicking on the View drop down menu, selecting Toolbars , and then selecting Clipboard .

·       Icons on this toolbar include Copy , Paste All and Clear Clipboard .  If you move the mouse over one of the icons held within the Clipboard toolbar, then you will see the first 50 characters displayed.  If the item is a picture, then the pictures will be labeled in the order in which they were copied to the Clipboard.

To move and copy data to another worksheet

·       Select the cell or range that contains the data to be copied.

·       Press and hold the Alt key and drag any edge of the selected range to the required worksheet tab.

·       Place the range where required and release the mouse button.

·       To copy the data carry out the above procedure holding down both the Ctrl and Alt keys.

To copy data to another workbook

·       Open the other workbook.

·       Select the Window menu and choose Arrange .

·       Choose Tiled and click on the OK button.

·       Select the cell range you wish to copy.

·       Press and hold the Ctrl key and drag any edge of the selected range to the required position in the destination workbook.

·       Release the mouse button.

To copy data over several cells (fill)

·       Select the cell or range that contains the data you wish to copy.

·       Click and drag on the bottom-right corner of the selected cell or range.

·       The corner has a small box in it and the mouse pointer will change to a plus sign.

·       Drag the selection up, down, left, or right to copy the data over several cells.

·       Release the mouse button when you have finished.

To use the Clipboard to copy an object between pages, workbooks, or programs

·       Click on the object to select it and choose Copy from the Edit menu (or press Ctrl+C , or click on the Copy icon on the Standard toolbar).

·       Move to a different application, or move to the new sheet or workbook.

·       Select a location for the top left-hand corner of the object.

·       From the Edit menu, choose Paste (or press Ctrl+V , or click on the Paste icon on the Standard toolbar).

To copy an object to a different location on the sheet

·       Click on the object to select it.

·       Click and drag the object whilst holding down the Ctrl key.  The copy will move with the mouse pointer as you drag.

·       Place the object in a new location and release the mouse button.

To insert new cells to make space for the copied data

·       Select the cell or range you wish to copy.

·       Click and drag on the border edge of the selected range whilst holding down the Ctrl and Shift keys.

·       As you drag, the insert indicator shows you where the copied cells will be inserted.  A vertical indicator shows that the cells to the right will be moved to make room, a horizontal indicator shows that cells below will be moved to make room.

·       When you release the mouse button, the copy will be inserted into the worksheet at the desired location.  Existing data will move to make space for the copied data.

To copy a numeric value down a column

·       In the first cell of the column, enter the first numeric value or formula.

·       Select the second cell in the column.

·       To copy the data in the selected cell, press Shift+Ctrl+”

·       Press Enter to insert the value into the selected cell.

NOTE :  If there is already a formula in the original cell, the copied version will only contain the value for the formula. If you want to copy the whole formula, press Ctrl   +    ’     (Apostrophe) .

To copy a column of text into a row

·       Select the range of data you wish to copy and transpose.

·       From the Edit menu, choose Copy (or press Ctrl+C , or click on the Copy icon on the Standard toolbar).

·       Highlight the cell where you want to place the range.

·       Select Paste Special from the Edit menu, to display the Paste Special dialog box.

·       Select the Transpose check box and select OK .

To copy a formula across several cells in a column or row

·       Insert the formula, which you require in the first cell of the row or column.

·       Select the cell, which contains the formula you want to copy.

·       Click on the bottom right-hand corner of the cell border, the mouse pointer will change to a plus sign.  Drag the selection over the row or down the column.